sqlite-dump.el views SQLite
database files in Emacs as
".dump" SQL text. Editing and re-writing works too (though not
within tar-mode sub-files).
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 it, but it does allow for radical edits.
sqlite-dump.el is
free software (free
as in freedom), published under the terms of the
GNU General Public
License (v3 or up). Download version 6 here, or in my
miscbits-el collection:
sqlite-dump.el
(20k, and
sig)
The sig is a Gnu PG ascii armoured signature generated from my key.
This page Copyright 2009, 2010, 2011, 2013 Kevin Ryde, except for the GPLv3 logo which is Copyright Free Software Foundation and used here in accordance with its terms.