Hi everybody,
I was reading the new proposal for Virtual Tables. While at the same
time working on a DbExpress driver for SQLite where I need metadata
about the connected database. It requires me to deliver metadata in a
different format than SQLite can give me. I'm coding resultset caching
and transformations by hand, since no SQL-queries for metadata is supported.
I'm waiting for SQLite to have SQL queriable metadata for a long time,
but than I read Virtual Tables. Virtual tables could easily be
implemented on top of the PRAGMA settings to retrieve metadata. Every
PRAGMA statement which delivers a resultset could be mapped as a Virtual
Table. This way simple and standard SQL can be used to retrieve
metadata. This could enable metadata-sql-driven applications on top of
SQLite.
SQLite could even add these Virtual Tables by default within the engine
and hide these no-guarantee-PRAGMA-settings for public use !
Thanks for reading my insights.
Marco Wobben.
Relevant docs :
http://www.sqlite.org/pragma.html#schema
http://www.sqlite.org/cvstrac/wiki?p=VirtualTables
