aboutsummaryrefslogtreecommitdiff
path: root/README.sqlite
diff options
context:
space:
mode:
authorSteve Bennett <steveb@workware.net.au>2011-12-06 08:59:41 +1000
committerSteve Bennett <steveb@workware.net.au>2011-12-12 13:44:01 +1000
commit8a7db88a7cb01cdfbff503c0a89a864f0da5dc53 (patch)
treee12cf615b42e27988c4f6ce44fe9f17c219eeb91 /README.sqlite
parent3f3bc624feab8f7772147d45a43ee29cac0c95c8 (diff)
downloadjimtcl-8a7db88a7cb01cdfbff503c0a89a864f0da5dc53.zip
jimtcl-8a7db88a7cb01cdfbff503c0a89a864f0da5dc53.tar.gz
jimtcl-8a7db88a7cb01cdfbff503c0a89a864f0da5dc53.tar.bz2
Remove old sqlite0 extension
Anything older than sqlite3 is no longer worth supporting Signed-off-by: Steve Bennett <steveb@workware.net.au>
Diffstat (limited to 'README.sqlite')
-rw-r--r--README.sqlite12
1 files changed, 6 insertions, 6 deletions
diff --git a/README.sqlite b/README.sqlite
index cc4761d..dde7de5 100644
--- a/README.sqlite
+++ b/README.sqlite
@@ -17,12 +17,12 @@ Basic usage
The Sqlite extension exports an Object Based interface for databases. In order
to open a database use:
- set f [sqlite.open dbname]
+ set f [sqlite3.open dbname]
-The [sqlite.open] command returns a db handle, that is a command name that
+The [sqlite3.open] command returns a db handle, that is a command name that
can be used to perform operations on the database. A real example:
- . set db [sqlite.open test.db]
+ . set db [sqlite3.open test.db]
sqlite.handle0
. $db query "SELECT * from tbl1"
{one hello! two 10} {one goodbye two 20}
@@ -101,7 +101,7 @@ For default this extension will use the empty string, but it is possible
to specify a different string for the NULL value.
In the above example there were two rows in the 'tbl1' table. Now
-we can add usign the "sqlite" command line client another one with
+we can add using the "sqlite" command line client another one with
a NULL value:
sqlite> INSERT INTO tbl1 VALUES(NULL,30);
@@ -163,8 +163,8 @@ In-memory DBs are used just like regular databases, just the name used to
open the database is :memory:. That's an example that does not use the
filesystem at all to create and work with the db.
- package require sqlite
- set db [sqlite.open :memory:]
+ package require sqlite3
+ set db [sqlite3.open :memory:]
$db query {CREATE TABLE plays (id, author, title)}
$db query {INSERT INTO plays (id, author, title) VALUES (1, 'Goethe', 'Faust');}
$db query {INSERT INTO plays (id, author, title) VALUES (2, 'Shakespeare', 'Hamlet');}