Well, an interesting illustration of basic sqlite; but no relation to the question being asked.
> On 5/30/08, Mark Stewart <[EMAIL PROTECTED]> wrote: >> >> Is there a recommended way to save an in-memory database to a file? Is >> there >> a way to access the underlying in-memory data directly to save out to disk >> (if that would even work)? >> >> My other thought was to create an empty file based db and attach it, >> creating tables and transferring all the data through sql. >> >> Maybe there is some other option? >> > > > [12:04 AM] ~/foo$ ls > [12:04 AM] ~/foo$ sqlite3 > SQLite version 3.5.6 > Enter ".help" for instructions > sqlite> CREATE TABLE t (a, b); > sqlite> INSERT INTO t VALUES (1, 'one'); > sqlite> INSERT INTO t VALUES (2, 'two'); > sqlite> SELECT * FROM t; > 1|one > 2|two > sqlite> .q > [12:04 AM] ~/foo$ ls > [12:04 AM] ~/foo$ sqlite3 > SQLite version 3.5.6 > Enter ".help" for instructions > sqlite> CREATE TABLE t (a, b); > sqlite> INSERT INTO t VALUES (1, 'one'); > sqlite> INSERT INTO t VALUES (2, 'two'); > sqlite> SELECT * FROM t; > 1|one > 2|two > sqlite> .o foo.sql > sqlite> .dump > sqlite> .q > [12:05 AM] ~/foo$ ls > foo.sql > 12:05 AM] ~/foo$ cat foo.sql > BEGIN TRANSACTION; > CREATE TABLE t (a, b); > INSERT INTO "t" VALUES(1,'one'); > INSERT INTO "t" VALUES(2,'two'); > COMMIT; > [12:06 AM] ~/foo$ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
