sqlite 10 sec guide

[problem]

You want to get up and running with sqlite

[/problem]

[solution]

Install sqlite3 on linux, via yum: yum install sqlite3

Then just run sqlite dbname

[/solution]

[example]


% sqlite3 testdata.db
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> create table memos(text,priority INTEGER);
sqlite> insert into memos values('deliver project description',10);
sqlite> insert into memos values('lunch with Christine',100);
sqlite> select * from memos;
deliver project description|10
lunch with Christine|100
sqlite>

[/example]

[reference]

  1. sqlite3 linux man page
  2. sqlite official site

[/reference]