CREATE TABLE foo ( key TEXT NOT NULL PRIMARY KEY, value TEXT DEFAULT NULL); INSERT INTO "foo" VALUES('hello','world'); ...
Re-writing is a handy way to make changes if you're confident the database is safe for a dump/recreate round-trip. Saving is a complete file replacement not database operations, so it's no good if other processes are accessing the database, but does allow radical edits.
Download version 9,
sqlite-dump.el(22k, and sig)
This page Copyright 2009, 2010, 2011, 2013, 2014 Kevin Ryde, except for the GPLv3 logo which is Copyright Free Software Foundation and used here in accordance with its terms.
(Back to the sitemap.)