$ sqlite3 root/database
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> .tables
posts
sqlite> .schema posts
CREATE TABLE posts (id integer primary key, title text not null, body text not null, author text not null, posted date not null);
sqlite> select * from posts;
1|test|a new post|Foo|2007-01-01 00:01
2|another test|another post|Bar|2007-01-01 00:02
sqlite>