The minimalism, serverlessness/lack of temporary caches/lack of permission management, Hipp's religious obsession with efficiency, the use of their own pure Fossil SMC. Wait, scrap that last one. Pure beauty!
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'
IntegerNames
Show 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
- SQL | 0, 1k, 6
- Relational database management system | 0, 1k, 7
- Relational database | 0, 1k, 8
- Database | 0, 1k, 13
- Software | 0, 15k, 346
- Computer | 136, 23k, 582
- Technology | 0, 38k, 897
- Ciro Santilli's Homepage | 244, 174k, 3k