Re: creating tables needed for a query on-demand

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ryan Blazecka wrote:
> from the documentation it sounds pretty bleeding-edge though...is it 
> production-ready?

Virtual Tables definitely do work and they were a fairly minimal
addition in SQLite itself.  Effectively instead of calling various
builtin routines to do things on a table, there is a call to a
corresponding virtual table routine.  apsw includes test coverage of all
the functionality.

It has been used for a full text search (aka fts) extension which lets
you search for any text in the database.  fts is even on its second
major version.  I don't know of other users of virtual tables mostly
because people don't complain when things work!

I'd go right ahead an use it.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFx/F6mOOfHg372QQRAlPXAKDLBsFaMug650kXcJ25oXkWydwjnQCfT32W
laE5bhRtfftMcHOhN0WtOhQ=
=RY8O
-----END PGP SIGNATURE-----