Earlier quoted context omitted.
Sqlite smokes postgres on the same machine even with domain sockets [1]. This is before you get into using multiple sqlite database. What features postgres offers over sqlite in the context of running on a single machine with a monolithic app? Application functions [2] means you can extend it however you need with the same language you use to build your application. It also has a much better backup and replication st…
> 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…
I run multiple $10K MRR companies on a $20/month tech stack
231–240 of 539 posts
Re: I run multiple $10K MRR companies on a $20/month tech stack
#232I know this article is about the stack, but I'd like to point out that the success of the author has probably more to do with their marketing/sales strategy than their choice of technical infrastructure. Something to remind to many tech folks on HN
But 10k MRR sounds to me like travelling to Mars. I have 0 ideas and 0 initiative to push them ahead.
Re: I run multiple $10K MRR companies on a $20/month tech stack
#233I read it as an article in defence of boring tech with a fancier/clickbaity title. Here’s the more honest one i wrote a while back: https://aazar.me/posts/in-defense-of-boring-technology
While I agree with your points, this one could be more nuanced: > Infrastructure: Bare Server > Containers > Kubernetes The problem with recommending a bare server first is that bare metal fails. Usually every couple of years a component fails - a PSU, a controller, a drive. Also, a bare metal server is more expensive than VPS. Paradoxically, a k3s distro with 3 small nodes and a load balancer at Hetzner may cost you…
IME, hardware is much more reliable than people think.
Re: I run multiple $10K MRR companies on a $20/month tech stack
#234Nice list! I'd say the SQLite with WAL is the biggest money saver mentioned. One note: you can absolutely use Python or Node just as well as Go. There's Hetzner that offers 4GB RAM, 10TB network (then 1$/TB egress), 2CPUs machines for 5$. Two disclaimers for VPS: If you're using a dedicated server instead of a cloud server, just don't forget to backup DB to a Storage box often (3$ /mo for 1TB, use rsync). It's a good…
If you’re backing up to a third party losing your account isn’t a disaster, bring up a VM somewhere else, restore from backups, redirect DNS and you’re up and running again. If the backups are on a disk you can’t access anymore then a minor issue has just escalated to an existential threat to your company.
Personally I use Backblaze B2 for my offsite backups because they’re ridiculously cheap, but other options exist and Restic will write to all of them near identically.
Re: I run multiple $10K MRR companies on a $20/month tech stack
#235Nice list! I'd say the SQLite with WAL is the biggest money saver mentioned. One note: you can absolutely use Python or Node just as well as Go. There's Hetzner that offers 4GB RAM, 10TB network (then 1$/TB egress), 2CPUs machines for 5$. Two disclaimers for VPS: If you're using a dedicated server instead of a cloud server, just don't forget to backup DB to a Storage box often (3$ /mo for 1TB, use rsync). It's a good…
First step is to get ssh setup correctly, and second step is to enable a firewall to block incoming connections on everything except the key ports (ssh but on a different port/web/ssl). This immediately eliminates a swathe of issues!
Re: I run multiple $10K MRR companies on a $20/month tech stack
#236> 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…
Sqlite smokes postgres on the same machine even with domain sockets [1]. This is before you get into using multiple sqlite database. What features postgres offers over sqlite in the context of running on a single machine with a monolithic app? Application functions [2] means you can extend it however you need with the same language you use to build your application. It also has a much better backup and replication st…
Re: I run multiple $10K MRR companies on a $20/month tech stack
#237SQLite is fine, but I have ran Postgresql on a $20 server without any issues, and I would suggest if you have to deal with concurrent users and tasks, Postgresql is the way to go. SQLite WAL works, but sometimes it caused some issues, when you have a lot of concurrent tasks running continuously. And, not sure I'm correct, but I felt Postgresql has more optimized storage if you have large text data than SQLite, at lea…
Re: I run multiple $10K MRR companies on a $20/month tech stack
#238Earlier quoted context omitted.
But then you don't get the benefits of having the DB locally, with in-process access.
It's local to the worker? I don't understand what you mean.
Re: I run multiple $10K MRR companies on a $20/month tech stack
#239I'm taking the opposite approach - managed services all the way, and my monthly infrastructure costs are higher than what's described here. No regrets. Infrastructure isn't the problem I'm trying to solve. The problem is: who's actually going to pay for this? Optimizing infrastructure before you have customers is like designing a kitchen before you've written the menu. I launched within 72 hours of starting developme…
Re: I run multiple $10K MRR companies on a $20/month tech stack
#240Earlier quoted context omitted.
Or better yet, go with a euro provider like Hetzner and get 8GB of RAM for $10 or so. :) Even their $5 plan gives 4GB.
They also have servers in the US (east and west coast).