I am using SQLAlchemy (currently testing on SQLite, but need it to work elsewhere too) and I have a problem with primary key ID's being reused.
For instance, If I have some content with ID's from 1-6, then delete the content with an ID of 4, I would still like the next content added to have an ID of 7 and not 4 (as it currently happens). The ID's can be reused after a Session reset (or not, doesn't really matter either way).
I'm guessing that this depends on the type of DB you are using (and it's auto increment policy/implementation), but I would need a way to get this to work in at least SQLite, mySQL and PostgreSQL (others aren't important but they wouldn't hurt either).
Any help or pointing in the right direction would be appreciated!