POV-Ray : Newsgroups : povray.binaries.utilities : df3 SQLite virtual tables : Re: df3 SQLite virtual tables Server Time
10 Aug 2022 16:41:22 EDT (-0400)
  Re: df3 SQLite virtual tables  
From: jr
Date: 3 Sep 2017 17:00:27
Message: <59ac6d6b@news.povray.org>
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)

Copyright 2003-2021 Persistence of Vision Raytracer Pty. Ltd.