SQLite

small RDBMS engine

http://www.sqlite.org/

command-line

• sqlite3 {db}.db
• ctl-d to exit
• semicolons at end of lines
• schema is in sqlite_master table - or type .schema to view
• to export/dump schema and all data: sqlite3 {db}.db .dump > {db}.sql
• to regenerate db from export file: sqlite {db}.db < {db}.sql

2022 - JSON support

• de-facto NoSql approach possible?

accessing with Python

• whatever is built into your PythonWebFramework!
• http://trac.edgewall.org/wiki/PySqlite
• http://www.devshed.com/c/a/Python/Using-SQLite-in-Python/
• http://www.doughellmann.com/PyMOTW/sqlite3/