Difference between revisions of "SQLite"

From wikieduonline
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.
  
  file [[grafana]].db
+
  file [[grafana.db]]
 
  grafana.db: SQLite 3.x database, last written using SQLite version 3029000
 
  grafana.db: SQLite 3.x database, last written using SQLite version 3029000
  
  
  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 18: Line 16:
 
  [[yarn add sqlite3]]
 
  [[yarn add sqlite3]]
 
  [[sqlite3 --help]]
 
  [[sqlite3 --help]]
  [[BerckleysDB]]
+
  [[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>
  
  

Latest revision as of 08:33, 14 March 2024

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>


See also[edit]

Advertising: