Difference between revisions of "SQLite"
Jump to navigation
Jump to search
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | [[wikipedia:SQLite]] ([[2000]]) is ACID-compliant and implements most of the SQL standard, generally following PostgreSQL syntax. | + | [[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. | SQLite read operations can be multitasked, though writes can only be performed sequentially. | ||
| Line 9: | Line 9: | ||
sudo sqlite3 [[/var/lib/nfs/]]nfsdcltrack/main.sqlite "select * from clients" | sudo sqlite3 [[/var/lib/nfs/]]nfsdcltrack/main.sqlite "select * from clients" | ||
| − | * SQLite version 3.9 introduced JSON content managing. | + | == Changelog == |
| + | * SQLite version 3.9 introduced [[JSON]] content managing. | ||
* SQLite version 3.33.0 increased max db size to 281 TB. | * SQLite version 3.33.0 increased max db size to 281 TB. | ||
| Line 24: | Line 25: | ||
sqlite> | sqlite> | ||
| + | == Related == | ||
| + | * [[WAL file]] | ||
| + | * [[JSONB]] | ||
== See also == | == See also == | ||
Latest revision as of 09:24, 13 May 2026
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[edit]
- 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[edit]
See also[edit]
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
Advertising:
