Re: Aggregating multiple databases

[prev] [thread] [next] [Date index for 2004/10/17]

I thought you could "attach" other databases to your current
connection with sqlite?

http://www.opend.org/sqlite/classDatabase.html#a6


On Sat, 16 Oct 2004 08:22:22 +0100, Simon Cozens <simon@xxxxxxxxxxxx.xxx> wrote:
> I don't know if this is possible, but I thought I'd ask to see if anyone has
> any ideas about how to do it.
> 
> I have an application, Songbee, which organises songs and song lyrics. It uses
> an SQLite database with CDBI, and the all-important song table (Songbee::Song
> class) holds information about title, lyrics, key, copyright information and
> so on.
> 
> One of the users has asked for the ability to use multiple databases of songs;
> so, for instance, to have an english.db and a japanese.db and a spanish.db,
> and if they choose to use all three at once, have the contents of the song
> table from all three available from Songbee::Song->retrieve_all, as thought
> they were all in the one table.
> 
> I'm guessing I may well have to write Songbee::Song to inherit from an
> aggregator class that collects data from multiple Song classes generated on
> the fly with Class::DBI::Loader, but that's as far as I can get. Can anyone
> think of how this might be achieved?
> 
> --
> "Do not meddle in the affairs of cats, for they are subtle and will piss on
> your computer."  --Bruce Graham
>