Spending $5k to learn how database indexes work • Hacker News Board

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

#121

Post by marcinzm » Sat, Nov 06, 2021, 10:16 PM UTC

rytcio wrote: post #114

marcinzm wrote: post #81

Earlier quoted context omitted.

The time spent setting it up and managing it and then having to deal with backups/environment clones/access control/scaling limitations/etc. outweighs the savings for almost any company paying US wages. Especially since you'd need metal for everything and not just the db due to network latency.

I think you're over estimating how complicated that stuff is...

It's very easy to do it in a half-assed way and much harder to do it at scale in a production environment with many developers without hurting developer productivity at all.

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

#122

Post by marcinzm » Sat, Nov 06, 2021, 10:19 PM UTC

Nextgrid wrote: post #87

marcinzm wrote: post #81

Earlier quoted context omitted.

The time spent setting it up and managing it and then having to deal with backups/environment clones/access control/scaling limitations/etc. outweighs the savings for almost any company paying US wages. Especially since you'd need metal for everything and not just the db due to network latency.

Every cloud-hosted startup I've consulted for had a full-time devops guy wrangling Terraform and YAML files. The cloud requires an equivalent time investment.

Bare metal requires the equivalent of all of that devops stuff and then more. That is if you actually want parity and not just a half assed version that hurts developer productivity and causes technical debt.

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

#123

Post by eknkc » Sat, Nov 06, 2021, 10:21 PM UTC

radu_floricica wrote: post #54

I'm just leaving this here: https://www.hetzner.com/dedicated-rootserver/ax161/configura... Draw that nice red slide all the way to the right. No, it's not storage. Yeah, it's actually affordable. Yeah, that was a sexual sound you just made. You do have to be prepared to know some basic sysadmin, or pay somebody to do it for you. My newest server has about 60 cores and half a tera of ram. Surprisingly, it's not uber…

We are currently on AWS, and we have several dedicated servers on LeaseWeb that we offload computational work on. These are cheap beasts.

Still, I'd not run my RDBMS on an unmanaged, non replicated dedicated server and I'd not bother setting up multiple servers with failover, automated backups etc and keep updating them. Fuck that, I'll pay whatever AWS says RDS costs.

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

#124

Post by kingcharles » Sat, Nov 06, 2021, 10:22 PM UTC

radu_floricica wrote: post #108

throwawayapples wrote: post #101

Earlier quoted context omitted.

I was just comparing the pricing to OVH's cloud VPS's ( https://us.ovhcloud.com/ ) and, accounting for the currency conversion and OVH's huge amount of free unmetered bandwidth (vs 20TB for H), it actually looks like OVH is even cheaper. How can DO and Vultr even compete? Probably on the basis of their nicer dashboards and easier sign-up flow (especially OVH's)

Tried OVH once. Couldn't even finish the account setup. Was rather dissapointed because I wanted not to depend on just one provider. Might give them a chance again.

I just recently signed up for some stupidly low-priced VPS on OVH and encountered no problems at all with the sign-up. The only issue I had was when I went to increase the RAM - it said the price was $1/month, but when I bought it I was charged $5 and it took support a week to get back to me to tell me I didn't read the small print properly and that it said they would have to upgrade the Windows license which was an extra fee.

tl;dr: watch the small print and their support is slow as fuck. otherwise, incredible value for money.

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

#125

Post by racl101 » Sat, Nov 06, 2021, 10:35 PM UTC

AnotherGoodName wrote: post #15

I've seen things you people wouldn't believe. Millions burnt on consultants and licensing Oracle. I watched C series startups throwing it all away in a move to NoSQL. All those Amazon RDS fees will be lost in time.

I knew the cadence of this sentence sounded familiar.

Nice!

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

#126

Post by max_hammer » Sat, Nov 06, 2021, 10:36 PM UTC

I hate this pricing model

My company in boarded `fivetran` to source data from different tools.

Budget got exhausted in sourcing `iterable` data

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

#127

Post by racl101 » Sat, Nov 06, 2021, 10:37 PM UTC

Yeah, It cost me two bad months of high RDS fees to learn about indexes. $900 in total.

Then a bro showed me one night about the magic of indexes. 5 minutes worth of advice saved me hundreds of dollars per month in the future and all he asked in return was for some beer and chicken wings.

Now that is a good bro.

I'm happy to say I've paid it forward myself.

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

#128

Post by NicoJuicy » Sat, Nov 06, 2021, 10:47 PM UTC

joconde wrote: post #117

radu_floricica wrote: post #108

Earlier quoted context omitted.

Tried OVH once. Couldn't even finish the account setup. Was rather dissapointed because I wanted not to depend on just one provider. Might give them a chance again.

I rented a VPS from the French website (their native language), and it was confusing. I remember looping through the same 2 pages 10 times before actually finding the instance's access instructions. Of course, you don't have to care about the console once you have SSH access to the server. It seems to be pretty good service for the money.

Hetzner is German, not french.

Ovh is french.

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

#129

Post by adventured » Sat, Nov 06, 2021, 10:48 PM UTC

jaden wrote: post #104

amenod wrote: post #90

Earlier quoted context omitted.

...and Hetzner just started offering their services in the US a few days ago. (EDIT: not affiliated) If you do something stupid with your code at least you won't go bankrupt, only your service will be slower.

Just to clarify, Hetzner now has Cloud servers in the US. Dedicated servers are still only available in Europe.

I appreciate that info. I tried Hetzner a decade ago from the US just to see what kind of latency I might expect. I've been waiting for them to finally get US located services to give them a serious shot (vs Digital Ocean & Co.).

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

#130

Post by bombcar » Sat, Nov 06, 2021, 10:49 PM UTC

AnotherGoodName wrote: post #15

I've seen things you people wouldn't believe. Millions burnt on consultants and licensing Oracle. I watched C series startups throwing it all away in a move to NoSQL. All those Amazon RDS fees will be lost in time.

I felt a great disturbance in the Billing, as if millions of rows suddenly cried out in read and were suddenly repeated. I fear something terrible has happened.