Sqlite DDL

C:\work\rb\test>sqlite db\test.db
SQLite version 2.8.16
Enter ".help" for instructions
sqlite> create table articles
   ...> (id integer primary key,
   ...> title varchar(255),
   ...> text varchar(1024)
   ...> );
sqlite> .quit
(or create table articles (id integer primary key, title varchar(255), text varchar(1024) );

C:\work\rb\test>dir db
 Volume in drive C has no label.
 Directory of C:\work\rb\test\db
14.04.2005  14:14             4 096 test.db
               1 File(s)          4 096 bytes
C:\work\rb\test>

Configure database.yml to use sqlite

<p>SQLite does not use authentication and needs only a pointer to the database file.
The adapter parameter tells Ruby to use SQLite for a database.</p> <pre>development:
adapter: sqlite
dbfile: db/dev.db

test:
adapter: sqlite
dbfile: db/test.db

production:
adapter: sqlite
dbfile: db/prod.db
</pre> <p>If you are using SQLite3 use “sqlite3” instead of “sqlite” for the adapter.</p><p> </p><p>(Swiped from a site whose URL I've misplaced </p>