Ciro Santilli
OurBigBook.comThe minimalism, serverlessness/lack of temporary caches/lack of permission management, Hipp's religious obsession with efficiency, the use of their own pure Fossil version control[ref]. Wait, scrap that last one. Pure beauty!
Official Git mirror: github.com/sqlite/sqlite
Create a table
sqlite3 db.sqlite3 "
CREATE TABLE 'IntegerNames' (int0 INT, char0 CHAR(16));
INSERT INTO 'IntegerNames' (int0, char0) VALUES (2, 'two'), (3, 'three'), (5, 'five'), (7, 'seven');
"List tables:output:
sqlite3 db.sqlite3 '.tables'IntegerNamesShow schema of a table:outputs the query that would generate that table:
sqlite3 db.sqlite3 '.schema IntegerNames'CREATE TABLE IF NOT EXISTS 'IntegerNames' (int0 INT, char0 CHAR(16));Show all data in a table:output:
sqlite3 db.sqlite3 'SELECT * FROM IntegerNames'2|two
3|three
5|five
7|seven Tagged
Ancestors
Incoming links
- nodejs/sequelize/raw/parallel_create_delete_empty_tag.js
- Delete all duplicate rows in SQL
- DELETE with JOIN (SQL)
- Get Bitcoin transaction id from position in dat file
- Good
- How to decide if an ORM is good?
- ISO SQL TRIGGER syntax
- LevelDB
- Lujakob/nestjs-realworld-example-app SQLite port
- Node.js SQLite bindings
- Sequelize example
- SQL 2D histogram
- SQL contiguous ranges
- SQL example
- SQL histogram
- SQL RECURSIVE prevent infinite recursion
- SQL TRIGGER
- SQL window
RANGE - SQLite C extension
- SQLite import CSV
- SQLite import CSV from stdin
- SQLite import JSON
- SQLite isolation levels
sqlite3Node.js package- The horrors of Sequelize
- The most awesome systems programmers
- UNION (SQL)
- UPDATE with JOIN (SQL)
- Upsert