Difference between revisions of "SQLite"
Jump to navigation
Jump to search
Tags: Mobile web edit, Mobile edit |
|||
| Line 22: | Line 22: | ||
== See also == | == See also == | ||
* {{sqlite3}} | * {{sqlite3}} | ||
| + | * {{SQLite}} | ||
* {{SQL}} | * {{SQL}} | ||
| − | |||
[[Category:Databases]] | [[Category:Databases]] | ||
Revision as of 17:18, 22 April 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
See also
sqlite3- SQLite, Core Data
- SQL, NewSQL, RDMS: GraphQL (2015), SQLite,
select, insert,select count, Distributed SQL, TablePlus, Cache hit ratio,pg_stat_user_tables,EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy,CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint,.sql
Advertising:
