I have been working to improve the SQLite adapter for Rails as much as possible, as quickly as possible. Today, I have 6 PRs (3 merged, 3 open). Once all are merged,
#SQLiteOnRails
will have generated columns, deferred foreign keys, auto-populating columns & custom primary keys