riku_iki

36 ms·

751.
by riku_iki 2y ago
> It’s orthogonal I disagree its orthogonal and explained why. I guess lets agree on disagree.
752.
by riku_iki 2y ago
> But as has been pointed out, most apps are never, ever going to have close to 2 billion users, or for that matter 2 billion anything. T all computers will be fine with 640kb of ram
753.
by 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.
754.
by riku_iki 2y ago
price for various features, like ACID.
755.
by riku_iki 2y ago
scale of damage is very different, so "as" is up to discussion.
756.
by riku_iki 2y ago
> 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 potential
757.
by riku_iki 2y ago
> I'm saving 48 bytes per row you saving 24 bytes per row: downsizing 6 columns from 8 bytes to 4, which is fraction of your table size. If your system is sensitive to such change, you likely should optimize something else. > Usi
758.
by riku_iki 2y ago
so, what about my argument that PG has 23 bytes overhead per row and your space win is very small compared to that overhead?
759.
by riku_iki 2y ago
> 4 bytes * 2^31 (because Postgres doesn’t allow have unsigned ints, unlike MySQL) is 8.6 GB I didn't get your point. When it is 2^31, you definitely need bigint already. When it is much smaller, it will be much smaller overhead. Al
760.
by riku_iki 2y ago
there is unlikely significant performance degradation for int vs big int, but it will be huge PITA, if 10 years later and tons of legacy code written that table will grow over 4B rows..
761.
by riku_iki 2y ago
what is the appeal of having any of this compared to DigitalOcean droplet(besides playing with new toy..)?
762.
by riku_iki 2y ago
> I've got a long list of side projects to plough through. It'll be fun." Hacker's retirement.
763.
by riku_iki 2y ago
But this is not open source? It is some cloud stuff.
764.
by riku_iki 2y ago
> Livestock accounts for somewhere between 10-20% of global greenhouse gas emissions livestock returns back CO2 captured by plants + transportation cost. So, transportation cost part is not CO2 neutral if they use fossils(very likely) an
765.
by riku_iki 2y ago
its just mean that new home buyers pay taxes for rest of the people. If the goal is to solve housing by building more homes, this is very wrong direction.
766.
by riku_iki 2y ago
your situation is probably not completely relevant to age, many injuries are not recoverable no matter how old you are. You accumulated risks of such injuries which produced result. If you switch to safer kinds of sport/workout, you st
767.
by riku_iki 2y ago
> To give it up, would be to give up the one thing that their entire life has revolved around since childhood. I imagine they could try to transfer to some coaching carrier, open personal business, etc.
768.
by riku_iki 2y ago
> Seems like sociopathic behavior to me, which these professions tend to attract. given how cheap is to say hello, and maybe get some advantage from this in the future, this is not very smart sociopathic behavior. But this maybe be resul
769.
by riku_iki 2y ago
new buyer of existing house will have tax reassessed base on transaction (current market price)
770.
by riku_iki 2y ago
I am not expert, but first google link says that simplest curing process is to brine it for 3 days in salted water and then bake, I don't think it will be counted as ultra-processed: https://www.homesicktexan.com/how-to
771.
by riku_iki 2y ago
> it has four-times the daily recommended saturated fats. These will give you heart disease I think this is very debatable and doesn't have clear backing evidence.
772.
by riku_iki 2y ago
> I agree that this proposed regulation seems like it probably won't help. I would personally use this as a signal when making choice among other factors. Say I am choosing between two types of ham.
773.
by riku_iki 2y ago
there is also internet belief that this happens because of lack of electrolytes, and can be mitigated by adding nutrition additions.
774.
by riku_iki 2y ago
> the brain related to anxiety anxiety likely may produce some healthy behaviour reaction: animal starts running/hunting/escaping more, which may increase health indicators. Many humans start overeating, which is bad. Story fro
775.
by riku_iki 2y ago
is it fair that you pay much smaller taxes compared to fresh buyer?
776.
by riku_iki 2y ago
> If you manage to solve the halting problem first. there is a large slice of algorithms, which are possible to prove that they are not affected by halting problem. I think having tooling for this slice of algorithms is already a big win
777.
by riku_iki 2y ago
why do you think so?
778.
by riku_iki 2y ago
US's president elections are effectively decided by 10k delegates in two parties during primaries, population chooses from two options they are given. It is better than in China(which has one party), but is it really by far better?
779.
by riku_iki 2y ago
It was funny seeing their front page saying "World's faster analytical and search database" has 90MB/s streaming ingest speed..
780.
by riku_iki 2y ago
10b+ record table and trillions indexed rows on single machine are very different tasks.

More ›