Earlier quoted context omitted.
> It's not much harder to use than SQLite, you get all of the Postgres features [..] More features is a net negative if you don't need those features. Ideally you want your DB to support exactly what you need and nothing more. Not typically realistic but the closer you can get the better.
A feature you don't think you need today, might be one you actually need tomorrow. It would be short-sighted to choose some tech based only on what you need today. If the extra features don't cost you anything, I can't see that as a "net negative".
I run multiple $10K MRR companies on a $20/month tech stack
431–440 of 539 posts
Re: I run multiple $10K MRR companies on a $20/month tech stack
#432Earlier quoted context omitted.
Thank you for clarification, I was wrong in my prev comment. > - [1] An interactive transaction is a transaction where you intermingle database queries and application logic (running on the application). could you give specific example why do you think SQlite can do batching and PG not?
Not the person you are responding to, but sqlite is single threaded (even in multi process, you get one write transaction at a time). So, if you have a network server that does BEGIN TRANSACTION (process 1000 requests) COMMIT (send 1000 acks to clients), with sqlite, your rollback rate from conflicts will be zero. For PG with multiple clients, it’ll tend to 100% rollbacks if the transactions can conflict at all. You…
Re: I run multiple $10K MRR companies on a $20/month tech stack
#433Re: I run multiple $10K MRR companies on a $20/month tech stack
#434Earlier quoted context omitted.
My understanding is litestream can lose data if a crash occurs before the backup replication to object storage. This makes it an unfair comparison to a Postgres in RDS for example?
your understanding is very wrong. please read the docs or better yet the actual code.
Re: I run multiple $10K MRR companies on a $20/month tech stack
#435Earlier quoted context omitted.
> for inserts only into singe table with Actually, there are no inserts in this example each transaction in 2 updates with a logical transaction that can be rolled back (savepoint). So in raw terms you are talking 200k updates per second and 600k reads per second (as there's a 75%/25% read/write mix in that example). Also worth keeping in mind updates are slower than inserts. > no indexes. The tables have an index on…
Thank you for clarification, I was wrong in my prev comment. > - [1] An interactive transaction is a transaction where you intermingle database queries and application logic (running on the application). could you give specific example why do you think SQlite can do batching and PG not?
beginTx
// query to get some data (network hop)
result = exec(query1)
// application code that needs to run in the application
safeResult = transformAndValidate(result)
// query to write the data (network hop)
exec(query2, safeResult)
endTxHow would you batch this in postgres and get any value? You can nest them all in a single transaction. But, because they are interactive transactions that doesn't reduce your number of network hops.
The only thing you can batch in postgres to avoid network hops is bulk inserts/updates.
But, the minute you have interactive transactions you cannot batch and gain anything when there is a network.
Your best bet is to not have an interactive transaction and port all of that application code to a stored procedure.
Re: I run multiple $10K MRR companies on a $20/month tech stack
#436Re: I run multiple $10K MRR companies on a $20/month tech stack
#437The text feels incoherent to me and lacks some nuance. It starts about cutting costs by the choice of infrastructure and goes further to less resource hungry tools and cheaper services. But never compares the cost of these things. Do I save actually the upgrade to a bigger server by using Go and sqlite over let's say Python and postgres? Or does it not even matter when you have just n many users. Then I do not unders…
It actually starts with a completely unrelated anecdote: "What do you even need funding for?" I agree. The author claims to have multiple $10K MRR websites running on $20 costs. I also don't understand what he needs money for — shouldn't the $x0,000 be able to fund the $20 for the next project? It doesn't make any sense at all. Then the author trails off and tells us how he runs on $20/month. Well, why did you apply…
Building a $10K MRR website is hard. Building multiple (assuming "multiple" here means >= 3) $10K MRR websites is extremely hard.
I don't know which investors they pitched to, but most investors seeing that number will write a 100-200K check to invest in THE PERSON pretty immediately; unless there was strong red flags in their business model (porn, drug, gambling, etc...)
Re: I run multiple $10K MRR companies on a $20/month tech stack
#438If 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"…
I currently work in a small b2c startup with 200 active users (and targeting 5000 by the end of the year) and we're already paying AWS $1000/month on infra and it drives me crazy…
And the deployment process is also over-engineered in a way that makes it hard to change anything (if you want to release without changing things too much that's fine, but changing the deployment process is already a nightmare).
“But best practices”, “but scalability”, “but 99.999% uptime” …
Re: I run multiple $10K MRR companies on a $20/month tech stack
#439Lots of debate about SQLite vs Postgres. One thing to note is you can certainly run Postgres (Kubernetes even if you want) and your app for $20 / month.
Re: I run multiple $10K MRR companies on a $20/month tech stack
#440Earlier quoted context omitted.
It actually starts with a completely unrelated anecdote: "What do you even need funding for?" I agree. The author claims to have multiple $10K MRR websites running on $20 costs. I also don't understand what he needs money for — shouldn't the $x0,000 be able to fund the $20 for the next project? It doesn't make any sense at all. Then the author trails off and tells us how he runs on $20/month. Well, why did you apply…
Just because you start this lean doesn’t mean you should stay that way. Perhaps he’s now spending too much time managing his stack and not enough time on product development, customer service, a/o growth. In other words, what gets you to $10k MRR isn’t the same thing(s) for 2x, 5x, or 10x that.
$20 x 1000 => $20,000 // not more than what they make a month even if "multiple" here means 2