Sqlite is a file-base SQL database.
When the sqlite3 CLI is instsalled locally, the following commands are relevant:
- Open database:
.open main.dblocally. - Show tables:
.tables - 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.