How to choose the right database for application scalability

Critter Junction is looking for the right type of databases that allows their app to vertically and horizontally scale with ease, but which database will best serve their needs? In this episode of Season of Scale, we help Critter Junction choose the best database option for their mobile mini game - explaining the pros and cons of Cloud SQL, Cloud Spanner, and Cloud Firestore. Watch to learn how to decide on a database suited for data type, scaling needs, and developer flexibility!

Chapters:
0:00 - Intro
1:06 - Horizontal vs. vertical scaling
1:18 - Cloud SQL
2:32 - Cloud Spanner
3:09 - Cloud Firestore
4:30 - Conclusion

#SeasonofScale

Product: Cloud SQL, Cloud Firestore, Cloud Spanner; fullname: Jenny Brown;

[davidfreeman]

My only concern with these options is how long they will be available. I started with db.model, and then ndb.model both of which are unavailable in Python 3+. If update systems to one of the new models, how long before I have to update again?

[guillaumeblaquiere]

The query capability of Firestore can't be compared to SQL or Spanner. There a huge tradeoff in querying side when you choose Firestore!!

[codewithluq]

I need to learn about spanner...How it handling those videos of Youtube and GMail...Ghosh

[sasg]

This video has nothing to do with the term (choosing scalable database) it's just a ad for google products 😉

[AyushMandloi]

Hi Google is firestore a good choice to handle transaction..?support acid?

[ariellephan]

With Spanner offering smaller scale instance, this video probably needs an update

[tirancm]

If she was my architect 🙂 she knows everything