03
An Introduction to SQLite conclusions:
- Whenever you feel you want to create new file format (be it binary or XML) consider SQLite database.
- Compiles SQL statements to bytecode. Bytecode itself can be examined by adding EXPLAIN in front of a SQL statement.
- SQLite is good for education - single binary you can drop anywhere is everything you need to try it interactively.
- 60% of SQLite code is regression tests giving 90% code coverage.
A bit of Rails doesn't hurt.
