Re: Aggregating multiple databases

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

On Sun, Oct 17, 2004 at 07:00:14PM +0100, Simon Cozens wrote:
> Y00R0B0T:
> > I thought you could "attach" other databases to your current
> > connection with sqlite?
> > 
> > http://www.opend.org/sqlite/classDatabase.html#a6
> 
> From my reading of that documentation, after I attach english.db on top of
> my existing songbee.db, I get two tables, default.song and english.song.

Yes.

> That's not what I want. I want one (virtual) table with the rows from both
> databases, or one class representing the rows from both tables.

You can create a view: http://www.sqlite.org/lang.html#createview

You can't write directly to the view, but that's easy enough to
handle with Class::DBI.

Tim.