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 it does allow radical edits.
Download version 10,
sqlite-dump.el(21k, and sig)
sqlite-dump.rcp install recipe.
This page Copyright 2009, 2010, 2011, 2013, 2014, 2015, 2016, 2017 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.)