SQLite database

Posted on Sep 12th, 2018

SQLite is a serverless relational database management system. Since it is self-contained it can be embedded in mobile apps, game consoles, and other media devices. The notes below are for the sqlite3 command-line tool.

# open an existing file or create a new database file
sqlite3 mydatabase.db

# view all tables in a database
sqlite> .tables

# show all databases in current connection
sqlite> .databases

# help menu to see available sqlite commands
sqlite> .help

# exit or quit the sqlite command-line tool
sqlite> .exit
sqlite> .quit