u/Rif-SQLin r/Database • Recommends
On “NoSQL and SQL Databases”
My default rule is..
1) Go with SQL Database like Postgresql
Unless
1.1) You want something so cheap/free like Google Firestore for a very small application that is not used often.
1.2) You're getting to the level of reading about https://en.wikipedia.org/wiki/CAP\_theorem
1.3) You're going to have billions or trillions of rows
Watch this "Building Financial Systems on Eventually Consistent DBs" by Rahul Pilani [video you should learned by reading about CAP theorem, many NoSQL databases work on Eventually Consistent. Let me know got any questions.