News for hackers. Stuff that matters.
Re:Google Cloud Firestore NoSQL database is in GA by jimbokun on Thursday January 31, 2019 @02:40PM (#19048007)
Because relational databases are much harder to scale. There are many people working on solving this problem.
Re:Google Cloud Firestore NoSQL database is in GA by _hardwaregeek on Thursday January 31, 2019 @03:05PM (#19048260)
At what level? Because I know StackExchange runs off of relational databases and they get a solid amount of traffic (with some Redis, but the foundation is relational). Even if relational doesn't scale for Facebook or whatever, if I'm making a piddly little chrome extension or a small website, a simple relational database will scale just fine.
Re:Google Cloud Firestore NoSQL database is in GA by jimbokun on Thursday January 31, 2019 @03:23PM (#19048432)
Firebase is designed around syncing, and I imagine that has something to do with it.

If you want a relational database for just one user's data, you could read a SQLite data file over the network when your user opens the app, perform SQL queries over the data in memory, then write the entire database file back across the network when the user hits a "save" button.

But you probably don't want a "save" button, you just want the user's state to be constantly updating back to the server.

And you probably don't want to write back the entire data file every time you save, just the parts that have changed.

So Firebase is optimized to solve these problems, and I bet the data structures they use are not also optimized for supporting all kinds of relational queries.

Re:Google Cloud Firestore NoSQL database is in GA by joatmon-snoo on Thursday January 31, 2019 @11:17PM (#19051532)
It's important to note that StackExchange is one of very few examples of successful vertical scaling, at least in the post-mainframe world.

If you want a relational DB as a cloud service, it sounds like you want Cloud SQL (as far as GCP is concerned).

(Disclaimer: I work on GCP.)

Re:Google Cloud Firestore NoSQL database is in GA by wsh91 on Friday February 01, 2019 @02:34AM (#19052345)
Cloud Spanner is also relational. :)

(Fellow GCPer.)

Re:Google Cloud Firestore NoSQL database is in GA by pier25 on Thursday January 31, 2019 @06:28PM (#19050103)
I only know of FaunaDB which is not really relational.

Do you have any other suggestions?

Re:Google Cloud Firestore NoSQL database is in GA by itcmcgrath on Thursday January 31, 2019 @07:18PM (#19050465)
If you want a scalable relational database, that's Cloud Spanner.
Re:Google Cloud Firestore NoSQL database is in GA by pier25 on Friday February 01, 2019 @10:25AM (#19054814)
Well, I'm actually more interested in serverless databases.