Re:Choose Boring Technology (2015)
by reasonabl_human on Tuesday February 23, 2021 @10:49AM
(#26238635)
We use a document based DB to run a massive azure SaaS service offering and it gets the job done quite well, why the hate for non-relational?
Definitely has it's place. I use redis for caching and queues. And elastic search for document search.
But I assume you have a relational database somewhere to manage users and do other relational-type things?
Php 7.2+ is great for a lot of saas products and is super fast now. and mysql 8 is rock solid and battle tested in a lot of production systems.
Starting over, I would consider PostgreSQL because it has some nifty features. But now that mysql has added json support, I am less inclined and I see a lot of complaints about performance and scaling that I don't think is as much of an issue with mysql. There isn't a whole lot more out there for relational databases (that doesn't cost a ton). And not using a relational database for most saas systems is just crazy talk.