Live data from Hacker News

I run multiple $10K MRR companies on a $20/month tech stack

stevehanov.ca

341–350 of 539 posts

Re: I run multiple $10K MRR companies on a $20/month tech stack

#341
post #84

Earlier quoted context omitted.

It is. With 10k MRR it represents 0.15% of the revenue. Having the whole backend costing that much for a company selling web apps is like it’s costing zero.

You probably don't make 10k MMR on day one. If you make many small apps, it can make sense to learn how to run things lean to have 4x longer runway per app.

The runway is going to be your time and attention span, not $10/mo.

I don't know what you value your time or opportunity cost as... but the $10/mo doesn't need to save very many minutes of your time deferring dealing with a resource constraint or add too much reliability to pay off.

If resource limitations end up upsetting one end user, that costs more than $10.

Re: I run multiple $10K MRR companies on a $20/month tech stack

#342
post #231

Earlier quoted context omitted.

> Sqlite smokes postgres on the same machine even with domain sockets [1]. SQLite on the same machine is akin to calling fwrite. That's fine. This is also a system constraint as it forces a one-database-per-instance design, with no data shared across nodes. This is fine if you're putting together a site for your neighborhood's mom and pop shop, but once you need to handle a request baseline beyond a few hundreds TPS…

https://antonz.org/sqlite-is-not-a-toy-database/ — 240K inserts per second on a single machine in 2021. The problem you describe is real, but the TPS ceiling is wrong by three orders of magnitude on modern hardware.

Do you know why it is a toy? Because in a real prod environment after inserting 240k rows per second for a while you have to deal with the fact that schema evolution is required. Good luck migrating those huge tables with Sqlite ALTER table implementation

Re: I run multiple $10K MRR companies on a $20/month tech stack

#343

> I use Linode or DigitalOcean. Pay no more than $5 to $10 a month. 1GB of RAM sounds terrifying to modern web developers, but it is plenty if you know what you are doing. If you get one dedicated server for multiple separate projects, you can still keep the costs down but relax those constraints. For example, look at the Hetzner server auction: https://www.hetzner.com/sb/ I pay about 40 EUR a month for this: Disk: 7…

Agreed. Though, now that hetzner has increased pricing, OVH is quite competitively priced and has some newer hardware available.

Re: I run multiple $10K MRR companies on a $20/month tech stack

#344
post #216

Earlier quoted context omitted.

>But, in all honesty, all RR numbers are estimates. Sure, but I would expect you to have at least one data point or at least near it, before making any estimates for that timescale. I don't see many people make MRR projections based on 2 days of of sales, it's just something I've noticed with startups and ARR.

2 days is optimum, you can fit a nice curve - 1, 2 ... at the current rate we will have 536,870,912 by day 30.

Nice, the investors will be overjoyed to hear this.

Re: I run multiple $10K MRR companies on a $20/month tech stack

#346
post #162

Earlier quoted context omitted.

About security, wall of shame story, Once I had Postgresql db with default password on a new vps, and forgetting to disable password based login, on a server with no domain. And it got hacked in a day, and was being used as bot server. And that was 10 years ago. Recently deployed server, and was getting ssh login attempts within an hour, and it didn't had a domain. Fortunately, I've learned my lesson, and turned of p…

Nothing would happen, ssh is designed to be open to the world. Using tailscale or a vpn to hide your IP is fine, but using tailscale ssh maybe not.

Well continuous attempts definitely bogged down my desktop pretty bad. Also, getting OOM on a 64gb machine multiple times a day is quiet annoying.

And one simple mistake, and we're screwed

Re: I run multiple $10K MRR companies on a $20/month tech stack

#347

> The enterprise mindset dictates that you need an out-of-process database server. But the truth is, a local SQLite file communicating over the C-interface or memory is orders of magnitude faster than making a TCP network hop to a remote Postgres server. I don't want to diss SQLite because it is awesome and more than adequate for many/most web apps but you can connect to Postgres (or any DB really) on localhost over…

you also get a much better query execution engine, so if you need to run reports or analytics they will be faster

Re: I run multiple $10K MRR companies on a $20/month tech stack

#348
post #231

Earlier quoted context omitted.

https://antonz.org/sqlite-is-not-a-toy-database/ — 240K inserts per second on a single machine in 2021. The problem you describe is real, but the TPS ceiling is wrong by three orders of magnitude on modern hardware.

Do you know why it is a toy? Because in a real prod environment after inserting 240k rows per second for a while you have to deal with the fact that schema evolution is required. Good luck migrating those huge tables with Sqlite ALTER table implementation

Try doing that on a “real” DB with hundreds of millions of rows too. Anything more than adding a column is a massive risk, especially once you’ve started sharding.

Re: I run multiple $10K MRR companies on a $20/month tech stack

#349
post #79

If this sounds like basic advice, consider there are a lot of people out there that believe they have to start with serverless, kubernetes, fleets of servers, planet-scale databases, multi-zone high-availability setups, and many other "best practices". Saying "you can just run things on a cheap VPS" sounds amateurish: people are immediately out with "Yeah but scaling", "Yeah but high availability", "Yeah but backups"…

And now big tech often doesn't even have the high availability to show for all that complexity.

Remember if you ever feel disappointed, the king of scale Google playstore updates stats once a day

Re: I run multiple $10K MRR companies on a $20/month tech stack

#350
post #64

Earlier quoted context omitted.

I mean, you’re not wrong about the facts, but it’s also pretty trivial to migrate the data from SQLite into a separate Postgres server later, if it turns out you do need those features after all. But most of the time, you don’t.

I bet that takes more time than the 5 extra minutes you take to setup Postgres in the same box upfront.

To export a database? Probably even faster. And that's ignoring the difference in performance.
Post reply on HN