SQLite

wikipedia:SQLite (2000) is ACID-compliant and implements most of the SQL standard, generally following PostgreSQL syntax.

SQLite read operations can be multitasked, though writes can only be performed sequentially.

file grafana.db
grafana.db: SQLite 3.x database, last written using SQLite version 3029000

sudo sqlite3 /var/lib/nfs/nfsdcltrack/main.sqlite "select * from clients"

Changelog

• SQLite version 3.9 introduced JSON content managing.
• SQLite version 3.33.0 increased max db size to 281 TB.

yarn add sqlite3
sqlite3 --help
Berkeley DB

sqlite3
SQLite version 3.43.2 2023-10-10 13:08:14
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>

Related

• WAL

See also

• sqlite3
• SQLite, Core Data, FTS5, WAL file
• SQL, NewSQL, RDMS: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DML, DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint, .sql, OpenSearch SQL, Transact-SQL