• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: two databases from one application
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: two databases from one application


  • Subject: Re: two databases from one application
  • From: Ken Anderson <email@hidden>
  • Date: Thu, 11 May 2006 07:14:20 -0400

For me, leveraging database facilities is the most appropriate. I worked on a very large EOF system for many years, and the way we decided to deal with this was with database triggers. In our case, the audit tables were in the same database, but most database systems have ways of accessing other databases in triggers so that you can move the appropriate data over.

On May 11, 2006, at 5:32 AM, David Avendasora wrote:

Pierce,

Can you elaborate on some of the easier ways to do this? I am facing this requirement for a project I am working on now. The intent is to add the functionality after the core system is up and running but I'd feel much more comfortable with at least having a strategy now.

I need to maintain a history of a subset of the date in my database for use in forecasting and recall.

Thanks,

Dave

On May 10, 2006, at 11:22 PM, Pierce T. Wetter III wrote:

The original author, Milan, isn't replicating the object, he's migrating it in that he's copying the record from database1 to database2, then deleting the copy in database1.

I suspect some kind of audit trail, like he doesn't really want to "delete" the object, as much as mark it deleted by moving it into the other database. So if I'm following the code correctly, the second database ends up being a record of all the objects that have been deleted.

Which, as I said, there's much easier ways to do...so I was hoping Milan would talk about the real problem...

 Pierce


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40anderhome.com


This email sent to email@hidden

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
References: 
 >Re: two databases from one application (From: "Pierce T. Wetter III" <email@hidden>)
 >Re: two databases from one application (From: David Avendasora <email@hidden>)

  • Prev by Date: Re: two databases from one application
  • Next by Date: Re: FrontBase NooB Question
  • Previous by thread: Re: two databases from one application
  • Next by thread: Re: two databases from one application
  • Index(es):
    • Date
    • Thread