SQLite

Getting Started

• https://docs.python.org/2/library/sqlite3.html
• https://www.sqlite.org/datatype3.html

Altering Table Limitation Work-around

https://stackoverflow.com/questions/5938048/delete-column-from-sqlite-table/5987838#5987838

BEGIN TRANSACTION;
CREATE TEMPORARY TABLE t1_backup(a,b);
INSERT INTO t1_backup SELECT a,b FROM t1;
DROP TABLE t1;
CREATE TABLE t1(a,b);
INSERT INTO t1 SELECT a,b FROM t1_backup;
DROP TABLE t1_backup;
COMMIT;