Google Cloud Datastore vs. Google Cloud SQL

If you want a serverless NoSQL database, no matter it is for personal use, or for company use, Google Cloud Datastore should be on top of your list, especially if you are using Google Cloud as your primary cloud platform. It integrates with all services in the Google Cloud platform.

Incentivized

Although Google Cloud SQL has room for improvement by addressing a minor lack of features, its features and services keep it high among other SQL database products. It is very fast compared to others. Since it is cloud-based, maintenance is also easier. Integration capabilities are also more than expected.

Incentivized

• Automatically handles shards and replication.
• Schema-less & NoSQL.
• Fully managed.

Incentivized

• Highly scalable without worrying about sudden transaction explosion during peak hours.
• Highly available with multiple geographical locations and regions for nearly 0 downtime to the users.
• Extremely reliable and responsive for high latency applications due to superb networking at the core.

Incentivized

• It is hosted on GCP, which makes it harder if your company have multi-cloud strategy.
• When you want to migrate to other cloud providers, there can be a caveat.

Incentivized

• Increasing support for more database engines may enable a wider range of application needs to be met.
• Implementing and updating cutting-edge security features on a constant basis.
• Streamlining and enhancing the tools for transferring data to Google Cloud SQL from on-premises databases or other cloud providers.

For the amount of use we're getting from Google Cloud Datastore, switching to any other platform would have more cost with little gain. Not having to manage and maintain Google Cloud Datastore for over 4 years has allowed our teams to work on other things. The price is so low that almost any other option for our needs would be far more expensive in time and money.

Incentivized

It's a great product with ease of use, great scalability and high availability. There's no need to have high effort on administration. Great visibility to what happens on database like CPU, memory, IO. We can also see the performance based on query. Overall good experience and really recommend it to others.

Incentivized

GCP support in general requires a support agreement. For small organizations like us, this is not affordable or reasonable. It would help if Google had a support mechanism for smaller organizations. It was a steep learning curve for us because this was our first entry into the cloud database world. Better documentation also would have helped.

Incentivized

We selected Google Cloud Datastore as one of our candidates for our NoSQL data is because it is provided by Google Cloud, which fits our needs. Most of our infrastructure is on Google Cloud, so when we think about the NoSQL database, the first thing we thought about is Google Cloud Datastore. And it proves itself.

Incentivized

Google SQL was great as a first SQL provision. It quickly enabled the apps to be built and scaled as needed for a while. It was robust and adaptable as needed and easy to export as needed when ready, depending on growth. Cost-wise, it's a good choice and requires little investment to get going.

Incentivized

• Simple billing part of Google Cloud Platform
• No time spent configuring and maintaining Google Cloud Datastore.
• Very good uptime for our applications.

Incentivized

• With managed database system, it has given us near 100% data availability
• It has also improved web layer experience with faster processing and authentication using database fields
• Google Cloud SQL also gels up well with Google Analytics and other analytics systems for us to join up different data points and process them for deeper dives and analysis

Incentivized