SQLite

SQLite is a relational Database that resides in a single file on disk.

Comparison between SQLite and Postgres

Open and connect to a database file:

sqlite <my_db.db>

See a list of tables in the database:

sqlite> .tables

Describes the fields in the table:

sqlite> PRAGMA table_info(<table>);

See rows from a table:

sqlite> SELECT * from <table>;

Exit sqlite command line:

sqlite> .quit

See more commands here.

See also:

• SQLite C - SQLite programming in C
• Sqlime - SQLite Playground