[TOC]
"SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine."
NON INTERACTIVE EXAMPLES
sqlite3 -help
sqlite3 -version
sqlite3 databasename .databases
sqlite3 databasename .tables
sqlite3 databasename .schema (shows the tables as "create" statements)
INTERACTIVE
.exit
fileSystem.db = local computer's understanding of the world
sync.db = authoritative as what's in the cloud (should be the same as CLOUD)
parentid = "if blank probably in a root level space" search tree first for filename
syncitem (state 6 = done)
fschangelog.db = fschangelist (? items that are queued for sync.db)
select * from space;
Select * from Tree where name="filename.txt"
echo '.dump' | sqlite3 ex1 | gzip -c >ex1.dump.gz
zcat ex1.dump.gz | sqlite3 ex2
sqlite> CREATE TABLE tbl2 (
...> f1 varchar(30) primary key,
...> f2 text,
...> f3 real
...> );
sqlite>