News for hackers. Stuff that matters.
Re:PostgreSQL and UUID as Primary Key by riku_iki on Saturday July 06, 2024 @01:20AM (#40888318)
> https://github.com/arp242/goatcounter/blob/master/db/schema.... - number of IDs is actually 7, not 6.

the point is that some/many of those ids are not timezone and country, and potentially can grow high in cardinality.

Re:PostgreSQL and UUID as Primary Key by arp242 on Saturday July 06, 2024 @04:34AM (#40889021)
No, my point is you accused me of lying at the drop of a hat for no good reason, and that this is demonstrably not true. Don't try and spinelessly slime your way out of that. And no, they I won't run out of IDs for them. "Potentially" anything can happen, but it won't happen here. After five year the furthest sequence is 0.86% on its way of being full.
Re:PostgreSQL and UUID as Primary Key by riku_iki on Saturday July 06, 2024 @11:31AM (#40890995)
> my point is you accused me of lying at the drop of a hat for no good reason

I said you described fictional scenario, and it appears to be true, your table ID fields are very different than timezone, country and user_id.