Re: APSW support for virtual tables?

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

Joe Pham wrote:
> Any chance we can get APSW 

I have pretty much finished APSW updates.  Unfortunately I found a nasty
bug in SQLite which the author fixed today.  SQLite 3.3.10 will be needed.

> to do virtual tables

Virtual tables are done via plain Python code.

> via Python loadable 
> modules? 

Do you really mean loadable modules?  SQLite has that feature (disabled
by default) and APSW has support for it.  But it seems weird in this
context since you would have a separate Python interpreter.

http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions

> I'm thinking of using the feature to store media files info 
> in the DB and data in the virtual tables.

http://bitpim.svn.sourceforge.net/viewvc/*checkout*/bitpim/subprojects/apsw/trunk/apsw.html?revision=3845&content-type=text%2Fhtml

At the end of the examples section you can see sample code for one and
there is more doc which you can find in the relevant section.

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

iD8DBQFFoueumOOfHg372QQRAiRcAKC4BDCFFJorjr0H0woc7hFCSDN1vgCgqVj/
meM7c0fEIaruI+fTvXrkZoU=
=5pVA
-----END PGP SIGNATURE-----

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV