Difference between revisions of "SQLite"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
Line 18: Line 18:
 
  [[yarn add sqlite3]]
 
  [[yarn add sqlite3]]
 
  [[sqlite3 --help]]
 
  [[sqlite3 --help]]
 +
[[BerckleysDB]]
  
  

Revision as of 10:02, 3 September 2023

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"


  • 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
BerckleysDB


See also

Advertising: