3 ms·

I have an issue about performance I have often wondered. Discussions like these encourage me to put more work into the DB layer however only recently have SQL

I have an issue about performance I have often wondered. Discussions like these encourage me to put more work into the DB layer however only recently have SQL databases like PostgreSQL become horizontally scalable (I know read replicas are a thing and maybe they are the answer). So why would I put more work and effort into the less scalable data storage over the horizontally scalable, stateless app layer?

dalyons 5y ago
You wouldn’t. If you’re planning on doing anything with a large user count(millions+), putting it all in the db is guaranteed terrible pain later on. Replicas are not the answer. But if you’re doing a LoB app for hundred of users you get away with it. (I still wouldn’t)