I have a database library that abstracts various DB types, such as DBF, shapefiles, CSV, PostGIS, etc. I use the Sqlite virtual table mechanism to provide SQL functionality on top of any of these DB types. Normally one would only need to do this for crude databases, such as a CSV file, but the manner in which I cater for long transactions makes it necessary for me to strap Sqlite onto, for instance, a modified Postgres table that has not yet been committed to the DB.
Ben -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dcharno Sent: 23 November 2010 05:00 AM To: sqlite-users@sqlite.org Subject: [sqlite] virtual tables What are some of the things that people use virtual tables for? Are there any good example usages? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users