5 ms·
This is exactly how tightly coupled, unmaintainable software is constructed. By picking the tools before understanding the model and building bespoke architect
by ChicagoDave 1mo ago
This is exactly how tightly coupled, unmaintainable software is constructed.
By picking the tools before understanding the model and building bespoke architecture.
You pick the tools that the business model requires. It might be a relational data store. It might not be. You might want an event store. You might want to reduce costs with lambdas and DynamoDB. You may need a pub/sub event broker.
The OP clearly loves Postgres. Cool. They also have limited experience with complex systems architectures because if they had that experience, they would have never written this article.
- ballon_monkey 1mo ago> This is exactly how tightly coupled, unmaintainable software is constructed. No. If you're struggling to build software against a DB and then abstract parts to use Redis or ES or whatever in the future, that's kinda a skill issue you or your team have with building poor software to begin with. Nothing to do with using a DB for multiple things like a Queue/Search etc.
- ChicagoDave 1mo agoThe technical solution isn’t the skill issue I’m pointing towards. It’s the business modeling skill that most developers lack, so they skip it and believe an ERD will magically cover all invariants.
- groundzeros2015 1mo ago> You might want to reduce costs with lambdas and DynamoDB. I don't think that's ever saved money. > because if they had that experience, they would have never written this article. That's not true.
- throwawaythekey 1mo ago> I don't think that's ever saved money. I spent about a year as a consultant in the AWS space, visited about ~15 clients of varying sizes. More often than not there's a single pg aurora instance responsible for 50%+ of the bill. Even worse are the serverless aurora offenders. All the indexes and guarantees of PG don't come cheaply and dynamodb pricing is not cheap but comparatively reasonable. It really is a good product if you know how to use it.
- groundzeros2015 29d ago> All the indexes and guarantees of PG don't come cheaply I’m currently paying digital ocean about 30 dollars a month for 4 commercial websites with fully featured Postgres.
- ChicagoDave 24d agoI would be framing my comments around enterprise architecture. For one off websites, cheaper on digital ocean is always the winner.