sqlite-dump.el
sqlite-dump.el
views
SQLite database files in
Emacs
as ".dump
" SQL text. This is good for browsing the schema and
contents. Editing and re-writing works too (but not in 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 the database, but it does allow 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 10,
sqlite-dump.el
(21k, and
sig)
sqlite-dump.el
sqlite-dump.el
The sig is a Gnu PG ascii armoured signature generated from my key.
el-get
includes
an 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.