Finally, a long-awaited event has happened: sqlite-3.6.19 now supports enforcing foreign key constraints. For me, this was one of the biggest drawbacks of SQLite.
Also, sqlite-3.6.8 had gained support for nested transactions which is sometimes useful.