Difference between revisions of "SQLite"
Jump to navigation
Jump to search
Tags: Mobile web edit, Mobile edit |
Tags: Mobile web edit, Mobile edit |
||
| Line 10: | Line 10: | ||
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. | ||
| + | |||
| + | * SQLite version 3.33.0 increased max db size to 281 TB. | ||
Revision as of 04:35, 17 August 2020
This article is a Draft. Help us to complete it.
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.
See also
- 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 - Databases: Database management, SQL, NoSQL, Wide column, PostgreSQL, MariaDB, MySQL, Derby DB, MongoDB, Cassandra, SQLite, HSQL2, H2, RocksDB, Microsoft SQL Server, DB2, Oracle Database, Memcached, Berkeley DB, Collation, SingleStore, Amazon Aurora, Graph database, Amazon DynamoDB, PrestoDB, Cache hit ratio, ACID, WAL, ARIES, DBMS, OLTP, OLAP, Database Schema, CockroachDB, Tables, Views, Apache Druid, RDMS
Advertising:
