On Feb 7, 2008 3:21 PM, Jason Tudor <[EMAIL PROTECTED]> wrote:
> In general, what is the benefit of attaching databases verses maintaining
> multiple connections?
Well, let's say that you don't have the same schema in both databases.
Attaching two databases allows you to do queries across multiple
tables and would require much more effort if you maintained separate
connections.
e.g.
SELECT People.name, Pets.name
FROM
People AS People
other_database.Pets AS Pets
WHERE
People.id = Pets.owner_id;
It would be less pleasant to do that query via multiple connections.
-David
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
