Readit News logoReadit News
riv991 commented on Good system design   seangoedecke.com/good-sys... · Posted by u/dondraper36
mdavid626 · 6 months ago
I disagree. In modern highly scalable architectures I’d prefer doing joins in the layer front of the database (backend).

The “backend” scales much easier than the database. Loading data by simple indexes, eg. user_id, and joining it on the backend, keeps the db fast. Spinning up another backend instance is easy - unlike db instance.

If you think, your joins must happen in db, because data too big to be loaded to memory on backend, restructure it, so it’s possible.

Bonus points for moving joins to the frontend. This makes data highly cacheable - fast to load, as you need to load less data and frees up resources on server side.

riv991 · 6 months ago
High Scale is so subjective here, I'd hazard a guess that 99% of businesses are not at the scale where they need to worry about scaling larger than a single Postgres or MySQL instance can handle.
riv991 commented on VPN use surges in UK as new online safety rules kick in   ft.com/content/356674b0-9... · Posted by u/mmarian
mytailorisrich · 6 months ago
That's different. Yes, everyone complains about the state of the NHS but the "religion" is that the NHS may not be criticised itself. So it is in a bad state because it does not receive enough money, that's it, nothing else. Any suggestion that the organisation itself might be improved or, god forbid, that patients might pay is indeed usually seen as "blasphemy".
riv991 · 6 months ago
> So it is in a bad state because it does not receive enough money, that's it

In real terms the budget is the largest it's ever been, it's a relic of the time when people worked and died shortly (a decade) after retiring, not when they live for 30+ years longer.

riv991 commented on MakeShift: Security analysis of Shimano Di2 wireless gear shifting (2024)   usenix.org/conference/woo... · Posted by u/motorest
voidUpdate · 7 months ago
Wireless gear shifters? What was wrong with a cable? Even if you don't want it to be a mechanical connection, you could still at least send data over that instead of wirelessly...
riv991 · 7 months ago
It's much easier to maintain, as headsets have become integrated it's become harder and harder to work with anything that runs from the brake levers through the frame.
riv991 commented on Code highlighting extension for Cursor AI used for $500k theft   securelist.com/open-sourc... · Posted by u/Daviey
riv991 · 7 months ago
Microsoft were very quick to highlight their extensions being safer after this.

https://x.com/code/status/1943720372307665033?s=46

riv991 commented on Working on databases from prison   turso.tech/blog/working-o... · Posted by u/dvektor
calmoo · 8 months ago
Not to defend the author, but I think a more generous reading of this section from the blogpost:

> A brief summary is that I'm currently serving prison time for poor decisions and lifestyle choices I made in my twenties, all related to drugs.

Is that their poor decisions were related to drugs.

riv991 · 8 months ago
In his earlier blog post that this one links, he says:

> I've spent just under 10 years of my life in Prison (all for non-violent drug crimes.)

u/riv991

KarmaCake day344June 6, 2017View Original