Difference between revisions of "SQLite"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Draft}}
+
[[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"
  
 +
== Changelog ==
 +
* SQLite version 3.9 introduced [[JSON]] content managing.
 +
* SQLite version 3.33.0 increased max db size to 281 TB.
  
  
* SQLite version 3.9 introduced JSON content managing.
+
[[yarn add sqlite3]]
 +
[[sqlite3 --help]]
 +
[[Berkeley DB]]
  
* SQLite version 3.33.0 increased max db size to 281 TB.
+
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 ==
 
== See also ==
 +
* {{sqlite3}}
 +
* {{SQLite}}
 
* {{SQL}}
 
* {{SQL}}
* {{DBs}}
 
  
 
[[Category:Databases]]
 
[[Category:Databases]]

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: