Hacker News new | ask | show | jobs
by simonw 1849 days ago
Something I really like about integer incrementing IDs is that you can run ad-hoc "select * from table order by id desc limit 10" queries to see the most recently inserted rows.

I end up doing this a lot when I'm trying to figure out how my applications are currently being used.

Strictly incrementing UUIDs can offer the same benefit.