On 23 November 2010 17:39, Roger Binns <rog...@rogerbinns.com> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 11/23/2010 02:04 AM, Vivien Malerba wrote: >> The Libgda library (http://www.gnome-db.org) uses virtual tables > > Are you sure? It looks like an abstraction layer that sits above several > databases, with similar functionality to ODBC/JDBC.
Yes, it is, but with some more features. Basically here is how one uses it to execute statements involving data stored in two different databases: * open a connection (let's name it c1) to, for example, a PostgreSQL db, * open a connection (c2) to, for example, a MySQL db, * open a connection (c3) binding c1 and c2 and execute the SELECT, UPDATE,... statements in c3 using tables from c1 and c2 c3 is actually an SQLite (in memory) connection which takes all the tables in c1 and makes them appear as tables in c3 using SQLite's virtual tables (and the same for c2's tables). The SQL used in c3 is parsed and executed by SQLite (internally it creates some other statements to access data from c1 and c2's tables). It is also possible to add individual tables in c3 (for example from a CVS file), or add other connections (c4, c5,...) to c3. Regards, Vivien _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users