> Use uuidv7 not uuid in general (typically v4)
7/4 'converters' have been featured on HN a few times:
7/4 'converters' have been featured on HN a few times:
I find that most ID's in majority of tables are internal and only used for internal joins, so I use v7
The tables where the uuid will be sent to the client e.g. UserId etc, I also store an external_id of v4.
Much rather have a static column than continually convert.