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

accessing with Python


Edited: |

blog comments powered by Disqus