One danger with auto incrementing ids is to be tempted to use the key for sorting instead of using a separate creation timestamp. At some point you might have

One danger with auto incrementing ids is to be tempted to use the key for sorting instead of using a separate creation timestamp. At some point you might have to create out of order records (ex: inserting missing data) and that will break the order.