3 ms·
> cherry picked some fictional example What an incredibly rude and dismissive accusation. Here's my table: https://github.com/arp242/goatcounter/blob/master/db
by arp242 2y ago
> cherry picked some fictional example
What an incredibly rude and dismissive accusation. Here's my table: https://github.com/arp242/goatcounter/blob/master/db/schema.gotxt#L70 https://github.com/arp242/goatcounter/blob/master/db/schema.... – number of IDs is actually 7, not 6.
I can give a lot more details and context on all of that and why it works the way it works and the savings are certainly not insignificant and theoretical, but save me real money in server costs every month. But I have little interest in talking to you further since you're just going to insult everyone who tries to inject the slightest nuance into "always use bigserial"-extremism. So good day to you.
- riku_iki 2y ago> https://github.com/arp242/goatcounter/blob/master/db/schema 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.
- arp242 2y agoNo, 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.
- riku_iki 2y ago> 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.
- deleted 2y ago[deleted]
- sgarland 2y agoI’d just like to congratulate you on perhaps the nicest “fuck off” I’ve ever read. Unrelated, I quite enjoyed reading your blog posts. Cheers!