Live data from Hacker News

Spending $5k to learn how database indexes work

briananglin.me

1–10 of 209 posts

Re: Spending $5k to learn how database indexes work

#3
Huh, learning about this "Superwall" product constitutes as my horror-story-of-the-day. It's paywalling as a service, just what the industry needed. Thankfully it appears to be quarantined to iOS right now, but God does it feel like we're headed right back into Stallman's predictions about how SAASS will ruin the landscape of commercial technology.

Re: Spending $5k to learn how database indexes work

#4
post #3

Huh, learning about this "Superwall" product constitutes as my horror-story-of-the-day. It's paywalling as a service, just what the industry needed. Thankfully it appears to be quarantined to iOS right now, but God does it feel like we're headed right back into Stallman's predictions about how SAASS will ruin the landscape of commercial technology.

Two sides to every coin. Ethical developers need ways to make low prices work, which is impossible without good testing suites.

Re: Spending $5k to learn how database indexes work

#7
post #6

0,15 $ per query... The world has gone insane.

It's not quite so crazy when you phrase it as $0.15 for reading a million items from the database .

No that's still crazy. Scanning a million items isn't a big workload.

Re: Spending $5k to learn how database indexes work

#8
post #6

Earlier quoted context omitted.

It's not quite so crazy when you phrase it as $0.15 for reading a million items from the database .

No that's still crazy. Scanning a million items isn't a big workload.

I agree, it might be distributed in some way which is driving up the cost?

Re: Spending $5k to learn how database indexes work

#10
No foreign keys to make migrations easier. That doesn't sound like the best trade off to me.

Having the database constrained as much as possible makes maintenance so much easier. Many bugs don't escape into production as they're caught by the database constraints. Those that do get out do less damage to the data.

I know scale comes with trade offs but that seems extreme to me.

Post reply on HN