hi,

announcing an updated version (0.1.2) of the 'df3vt', the virtual table
module for SQLite3 databases.  the SQL UPDATE statement is now
supported, meaning DF3 files can be written as well as read.

the source is attached.

the usage example assumes a working copy of 'spiral.df3' in the current
working directory:

$ sqlite3
sqlite> .header on
sqlite> .load /path/to/df3vt
sqlite> CREATE VIRTUAL TABLE t1
   ...> USING df3vt(file='spiral.df3', readonly='no');
sqlite> SELECT * FROM t1 WHERE v = 255;
x   y   z  v
25  25  2  255
sqlite> UPDATE t1 SET v = 0 WHERE x = 25 AND y = 25 AND z = 2;
sqlite3>

as always, all feedback, hints, tips and constructive criticism will be
welcomed.

enjoy, jr.

Post a reply to this message

Attachments:
Download 'df3vt-0.1.2.tar.gz' (17 KB)