Cloud Firestore vs Google Cloud SQL
Cloud Firestore
firebase.google.comGoogle Cloud SQL
cloud.google.comSide by side
| Figure | Cloud Firestore | Google Cloud SQL |
|---|---|---|
| Price from | Free | $0.04/mo |
| Free plan | Yes | — |
| Free trial | — | Yes |
| Open source | — | — |
| Web | Yes | Yes |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| iOS | Yes | — |
| Android | Yes | — |
| API | Yes | Yes |
| Plans published | 2 | 6 |
| Spec score · Cloud Database Services | 7.7 (#14) | 9.3 (#1) |
| Security | Mobile/web access can use Firebase Authentication and Security Rules; server-side access can use IAM. | Cloud SQL automatically encrypts data in transit on Google's internal networks and at rest in database tables, temporary files, and backups, and supports private VPC connectivity and network firewalls. |
Plans
Google Cloud SQL
- Cloud SQL Enterprise$0.04 a month
- Cloud SQL Enterprise Plus$0.05 a month
- Cloud SQL free trialFree
- Cloud SQL EnterprisePriced on request
- Cloud SQL Enterprise PlusPriced on request
- Cloud SQL pay-as-you-goPrice not published
In their own words
Cloud Firestore
Cloud Firestore has no write-up on Specifiction yet; its figures are above.
Google Cloud SQL
Google Cloud SQL is a managed cloud service for relational databases, supporting MySQL, PostgreSQL, and SQL Server. It provides automated backups, high availability, read replicas, scaling, and point-in-time restoration; retention can extend to 35 days. Database Migration Service can move databases from on-premises systems, Compute Engine, or other clouds, and lift-and-shift migrations to Cloud SQL are available at no additional charge. The service connects with Google Cloud products including Compute Engine, Cloud Run, Google Kubernetes Engine, Cloud IAM, BigQuery, and Datastream, as well as tools such as Looker and Terraform. It encrypts data in transit on Google’s internal networks and at rest, and supports private VPC connectivity and network firewalls. The dedicated trial provides PostgreSQL and MySQL Enterprise Plus instances for 30 days, with no automatic charge, followed by a 90-day stopped state. Cloud SQL is paid, from $0.04; there is no free plan. MySQL use is limited to the InnoDB storage engine.