I'm using SQLite for a brief tutorial on how to make an alternative to SQLite's autoincrement attribute on primary keys in your tables. I don't personally recommend using SQLite's autoincrement attribute in your database. This works as well, or better, and is not limited to SQLite. Try it with other databases.