5 ms·

6k visits per week * 5 page views per visit is one view per 20 seconds on average. Even very modest hardware with naively written application code should have n

6k visits per week * 5 page views per visit is one view per 20 seconds on average. Even very modest hardware with naively written application code should have no problem handling thousands of CRUD database queries per second (assuming every query doesn't need a table scan or something). Modern computers are mind-bogglingly powerful. An old laptop off eBay can probably handle the load for business needs for all but the very largest corporations.

npsomaratna 2y ago
My understanding is that DO VPS’ are underpowered (as are VPS offerings from most other VPS vendors). Dollar for dollar, bare metal stuff from Hetzner, OVH, etc are far more powerful. That said, I completely agree-a $4/month DO VPS can run MySQL, and should easily handle this load; in fact I’ve handled far bigger loads in practice. On a tangent: any recommendations for good US-based bare metal providers (with a convenience factor comparable to OVH, etc)?
- diggan 2y ago
  > good US-based bare metal providers The times I've needed it, DataPacket (not based in US, but has servers in the US) and Vultr (based in the US) have both been good to me.
  - npsomaratna 2y ago
    Thank you so much. I’ll take a look at these.
  - mminer237 2y ago
    In a trademark travesty, I must ask DataPacket.com or DataPacket.net?
    - diggan 2y ago
      Sorry, I was referring to datapacket.com
- mxuribe 2y ago
  Hetzner is of course not U.S. based, but has expanded to have 2 U.S. sites (Oregon i think, and Virginia)....so that could be an option maybe. Caveat: i have not leveraged Hetzner in the U.s.....so can not speak to their quality.
  - npsomaratna 2y ago
    That’s news thank you. I’ll check this out.
    - mxuribe 2y ago
      Uh, actually at a quick glance, seems the U.s. sites are more for their cloud offering and maybe not bare metal servers.....i think (sadly): https://www.hetzner.com/cloud https://www.hetzner.com/cloud
horsawlarway 2y ago
So many people don't seem to understand how efficient modern machines are. As someone who is literally using old laptops to host things from my basement on my consumer line (personal, non-commercial) and a business line (commercial)... I can host this for under 50 bucks a year, including the domain and power costs, and accounting for offsite backup of the data. I wish people understood just how much the "cloud" is making in pure profit. If you're already a software dev... you can absolutely manage the complexity of hosting things yourself for FAR cheaper. You won't get five 9s of reliability (not that you're getting that from any major cloud vendor anyways without paying through the nose and a real SLA) but a small UPS will easily get you to 99% uptime - which is absolutely fine for something like this.
- beeboobaa3 2y ago
  The problem is that my coworkers are morons who seem incapable of remembering to run a simple `explain analyze` on their queries. They'd rather just write monstrosities that kindasorta work without giving a single damn about performance. It seems like computers are getting more capable, but developers are becoming less capable at roughly the same pace.
  - 9dev 2y ago
    > It seems like computers are getting more capable, but developers are becoming less capable at roughly the same pace. And that makes perfect sense. Why should humans inconvenience themselves to please the machine? If anyone’s at fault, it’s the database for not being smart enough to optimize the query on its own.
    - beeboobaa3 2y ago
      [flagged]
      - 9dev 2y ago
        That’s besides the point I’m making. Technology should develop towards simplifying humanity’s life, not making it more complicated. It’s a good thing we don’t have to use clever loop constructs anymore, because compilers do it for us. It’s a good thing we don’t have to obsess about the right varchar size anymore, because Postgres‘ text does the right thing anyway. It’s a systemic problem. You’re going to loose the battle against human nature: Ever noticed how, after moving from a college dorm into a house, people suddenly manage to fill all the space with things? It’s not like the dorm was enough to fit everything they ever needed, but they had to accommodate themselves to it. This constraint is artificial, exhausting to keep up, and, if gone, will no longer be adhered to. If a computer suddenly becomes more powerful, developers aren’t going to keep up their good habits performance optimisation, because they had those only out of necessity in the first place.
tmpz22 2y ago
You're right but I'll play devil's advocate for teaching purposes: * Usage won't be uniformly distributed and you may need to deal with burst traffic for example when a new version is released and all your users are pulling new config data. * Your application data may be very important to your users and keeping it on a single server is a significant risk. * You're users may be geographically distributed such that a user on the other side of the world may have a severely degraded experience. * Not all traffic is created equal and, especially paired with burst traffic, could have one expensive operation like heavy analytical query from one user cause timeouts for another user. Vercel does not solve all of these problems, but they are problems that may be exasperated by a $4 droplet. All said I still highly encourage developers to not sell their soul to a SaaS product that could care less about them and their use case and consider minimal infrastructure and complexity in order to have more success with their projects.
- ffsm8 2y ago
  * that's just static files. Even a $4 droplets will hardly ever get into issues serving that, even with hundreds of simultaneous requests. * Okay, I guess that means we should use 2? So that's $8 now. * Vercel really doesn't help you there beyond serving static files from cdn. That hardly matters at this scale, you should keep in mind that you "only" add about 100ms of latency by serving from the other side of the globe. While that has an impact, it's not really that much. And you can always use another cdn too. They're very often free for html/js/css * Burst traffic is an issue, especially trolls that just randomly DOS your public servers for shits and giggles. That's pretty much the only one vercel actually helps you against. But so would others, they're not the only ones providing that service, and most do it for free. Frankly, the only real and valid reason is the previously mentioned: they've likely got the money and don't mind spending it for the ecosystem. And if they like it... Who are we to interfere? Aside from pointing out how massively they're overpaying, but they've gotta be able to handle that if they're willing to publish an article like this
  - jasonm23 2y ago
    People use Vercel ... because... ...haven't worked it out yet, all I can come up with is "they don't know any better". Surely that can't be true?

npsomaratna 2y ago

My understanding is that DO VPS’ are underpowered (as are VPS offerings from most other VPS vendors). Dollar for dollar, bare metal stuff from Hetzner, OVH, etc are far more powerful. That said, I completely agree-a $4/month DO VPS can run MySQL, and should easily handle this load; in fact I’ve handled far bigger loads in practice. On a tangent: any recommendations for good US-based bare metal providers (with a convenience factor comparable to OVH, etc)?

diggan 2y ago
> good US-based bare metal providers The times I've needed it, DataPacket (not based in US, but has servers in the US) and Vultr (based in the US) have both been good to me.
- npsomaratna 2y ago
  Thank you so much. I’ll take a look at these.
- mminer237 2y ago
  In a trademark travesty, I must ask DataPacket.com or DataPacket.net?
  - diggan 2y ago
    Sorry, I was referring to datapacket.com
mxuribe 2y ago
Hetzner is of course not U.S. based, but has expanded to have 2 U.S. sites (Oregon i think, and Virginia)....so that could be an option maybe. Caveat: i have not leveraged Hetzner in the U.s.....so can not speak to their quality.
- npsomaratna 2y ago
  That’s news thank you. I’ll check this out.
  - mxuribe 2y ago
    Uh, actually at a quick glance, seems the U.s. sites are more for their cloud offering and maybe not bare metal servers.....i think (sadly): https://www.hetzner.com/cloud https://www.hetzner.com/cloud

horsawlarway 2y ago

So many people don't seem to understand how efficient modern machines are. As someone who is literally using old laptops to host things from my basement on my consumer line (personal, non-commercial) and a business line (commercial)... I can host this for under 50 bucks a year, including the domain and power costs, and accounting for offsite backup of the data. I wish people understood just how much the "cloud" is making in pure profit. If you're already a software dev... you can absolutely manage the complexity of hosting things yourself for FAR cheaper. You won't get five 9s of reliability (not that you're getting that from any major cloud vendor anyways without paying through the nose and a real SLA) but a small UPS will easily get you to 99% uptime - which is absolutely fine for something like this.

beeboobaa3 2y ago
The problem is that my coworkers are morons who seem incapable of remembering to run a simple `explain analyze` on their queries. They'd rather just write monstrosities that kindasorta work without giving a single damn about performance. It seems like computers are getting more capable, but developers are becoming less capable at roughly the same pace.
- 9dev 2y ago
  > It seems like computers are getting more capable, but developers are becoming less capable at roughly the same pace. And that makes perfect sense. Why should humans inconvenience themselves to please the machine? If anyone’s at fault, it’s the database for not being smart enough to optimize the query on its own.
  - beeboobaa3 2y ago
    [flagged]
    - 9dev 2y ago
      That’s besides the point I’m making. Technology should develop towards simplifying humanity’s life, not making it more complicated. It’s a good thing we don’t have to use clever loop constructs anymore, because compilers do it for us. It’s a good thing we don’t have to obsess about the right varchar size anymore, because Postgres‘ text does the right thing anyway. It’s a systemic problem. You’re going to loose the battle against human nature: Ever noticed how, after moving from a college dorm into a house, people suddenly manage to fill all the space with things? It’s not like the dorm was enough to fit everything they ever needed, but they had to accommodate themselves to it. This constraint is artificial, exhausting to keep up, and, if gone, will no longer be adhered to. If a computer suddenly becomes more powerful, developers aren’t going to keep up their good habits performance optimisation, because they had those only out of necessity in the first place.

tmpz22 2y ago

You're right but I'll play devil's advocate for teaching purposes: * Usage won't be uniformly distributed and you may need to deal with burst traffic for example when a new version is released and all your users are pulling new config data. * Your application data may be very important to your users and keeping it on a single server is a significant risk. * You're users may be geographically distributed such that a user on the other side of the world may have a severely degraded experience. * Not all traffic is created equal and, especially paired with burst traffic, could have one expensive operation like heavy analytical query from one user cause timeouts for another user. Vercel does not solve all of these problems, but they are problems that may be exasperated by a $4 droplet. All said I still highly encourage developers to not sell their soul to a SaaS product that could care less about them and their use case and consider minimal infrastructure and complexity in order to have more success with their projects.

ffsm8 2y ago
* that's just static files. Even a $4 droplets will hardly ever get into issues serving that, even with hundreds of simultaneous requests. * Okay, I guess that means we should use 2? So that's $8 now. * Vercel really doesn't help you there beyond serving static files from cdn. That hardly matters at this scale, you should keep in mind that you "only" add about 100ms of latency by serving from the other side of the globe. While that has an impact, it's not really that much. And you can always use another cdn too. They're very often free for html/js/css * Burst traffic is an issue, especially trolls that just randomly DOS your public servers for shits and giggles. That's pretty much the only one vercel actually helps you against. But so would others, they're not the only ones providing that service, and most do it for free. Frankly, the only real and valid reason is the previously mentioned: they've likely got the money and don't mind spending it for the ecosystem. And if they like it... Who are we to interfere? Aside from pointing out how massively they're overpaying, but they've gotta be able to handle that if they're willing to publish an article like this
- jasonm23 2y ago
  People use Vercel ... because... ...haven't worked it out yet, all I can come up with is "they don't know any better". Surely that can't be true?