Re: looks like one database from the outside, but it's two inside

2007-07-19 Thread Theron Stanford
This sounds like a good idea. I guess I just don't know enough about databases yet to know how to do this linking. Mostly I just know about how to get DBI to interact with MySQL. I should mention that I'd also like to be able to make some rules in the "real" database temporarily disappear while

Re: looks like one database from the outside, but it's two inside

2007-07-19 Thread Theron Stanford
Thanks to all, and apologies to all. I should have waited another day to flesh this out before sending, but I was trying to take advantage of living on the west coast of the USA to send this out last night and come to work this morning to find my inbox teeming with lots of interesting ideas. Dum

looks like one database from the outside, but it's two inside

2007-07-18 Thread Theron Stanford
Overview: I'm trying to create the situation in the subject line: from the outside, the database handle thinks it's just one database, but inside it's really two databases containing tables with the same schema but not necessarily the same data. Specifics: Where I work we have a web site with c