News for hackers. Stuff that matters.
Re:PostgreSQL and UUID as Primary Key by groestl on Saturday July 06, 2024 @10:15AM (#40890607)
> And migrating all of this later on can be a right pain so it's worth getting it right up-frong

I've never had to move from uuids to integers. I've had to move from integers to uuids plenty of times though.

Re:PostgreSQL and UUID as Primary Key by arp242 on Saturday July 06, 2024 @04:47PM (#40893142)
I've migrated tables to more compact formats. Inefficient storage is the sort of of thing that works fine for a lot of things, right up to the point where you're running out of disk space or memory and it's no longer fine.

I'm not against UUIDs nor saying you should optimize everything, I'm just saying you should think about things, and that thinking about things really isn't that time-consuming or that much effort.