SQLite Wrapper

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

SQLite Wrapper

Ben Clewett
All,

D. Richard Hipp was kind enough to allow me to upload my wrapper for
SQLite.  This assists locking problems by copying result table to memory
and releasing locks on DB.  As well as allowing a very simple API, and a
few useful tools.

I've uploaded a new version which contains a SQLite shell.  This outputs
in MySQL format.  Sorry for all of you who believe MySQL is not worth
copying.  Probably very rightly.  But I am sorry I like it's clear output :)

Sample:


lw_shell> .schema registry
+--------+-----+----------------------------------------------+
|name    |type |sql                                           |
+--------+-----+----------------------------------------------+
|registry|table|CREATE TABLE registry (                       |
|        |     |  key VARCHAR(200) COLLATE NOCASE PRIMARY KEY,|
|        |     |  value VARCHAR(200) COLLATE NOCASE           |
|        |     | )                                            |
+--------+-----+----------------------------------------------+
   (0.000 seconds)


Here: http://www.sqlite.org/contrib

Maybe somebody may find this useful :)

Regards,

Ben.

(Sorry but shell part only works in UNIX.)