Sqlite

Sqlite is a file-base SQL database.

---

When the sqlite3 CLI is instsalled locally, the following commands are relevant:

• Open database: .open main.db locally.
• Show tables: .tables
• Get all columns in a table: pragma table_info("<your-table>");
• Quit CLI: ctrl + c

JS interopt

better-sqlite3is a relevant library for working with SQLite.

Production grade with Docker volumes

As SQlite is stored in a single file, this file must be taken care of.

More contents on Sqlite

There is a dedicated directory. See:

• Sqlite in production
• LibSQL
• WAL mode