Doctrine 2 vs Google Cloud SQL

Overview

Google Cloud SQL

Stacks555

Followers580

Votes46

Doctrine 2

Stacks284

Followers207

Votes31

Doctrine 2 vs Google Cloud SQL: What are the differences?

Doctrine 2: An object-relational mapper (ORM) for PHP 5.3.2+ that provides transparent persistence for PHP objects. Doctrine 2 sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL; Google Cloud SQL: Store and manage data using a fully-managed, relational MySQL database. MySQL databases deployed in the cloud without a fuss. Google Cloud Platform provides you with powerful databases that run fast, don’t run out of space and give your application the redundant, reliable storage it needs.

Doctrine 2 belongs to "Object Relational Mapper (ORM)" category of the tech stack, while Google Cloud SQL can be primarily classified under "SQL Database as a Service".

"Great abstraction, easy to use, good docs" is the top reason why over 9 developers like Doctrine 2, while over 12 developers mention "Fully managed" as the leading cause for choosing Google Cloud SQL.

Implisit, Policygenius, and OTOBANK are some of the popular companies that use Google Cloud SQL, whereas Doctrine 2 is used by orat.io, zombakka, and Vend. Google Cloud SQL has a broader approval, being mentioned in 71 company stacks & 28 developers stacks; compared to Doctrine 2, which is listed in 35 company stacks and 12 developer stacks.

Share your Stack

Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.

View Docs

CLI (Node.js)

Manual

Detailed Comparison

Google Cloud SQL	Doctrine 2
Run the same relational databases you know with their rich extension collections, configuration flags and developer ecosystem, but without the hassle of self management.	Doctrine 2 sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL.
Familiar Infrastructure;Flexible Charging;Security, Availability, Durability;Easier Migration; No Lock-in;Fully managed	-
Statistics
Stacks 555	Stacks 284
Followers 580	Followers 207
Votes 46	Votes 31
Pros & Cons
Pros 13 Fully managed 10 Backed by Google 10 SQL 4 Flexible 3 Encryption at rest and transit	Pros 14 Great abstraction, easy to use, good docs 10 Object-Oriented 7 Easy setup
Integrations
No integrations available	PHP

What are some alternatives to Google Cloud SQL, Doctrine 2?

Amazon RDS

Amazon RDS gives you access to the capabilities of a familiar MySQL, Oracle or Microsoft SQL Server database engine. This means that the code, applications, and tools you already use today with your existing databases can be used with Amazon RDS. Amazon RDS automatically patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery. You benefit from the flexibility of being able to scale the compute resources or storage capacity associated with your Database Instance (DB Instance) via a single API call.

Sequelize

Sequelize is a promise-based ORM for Node.js and io.js. It supports the dialects PostgreSQL, MySQL, MariaDB, SQLite and MSSQL and features solid transaction support, relations, read replication and more.

Prisma

Prisma is an open-source database toolkit. It replaces traditional ORMs and makes database access easy with an auto-generated query builder for TypeScript & Node.js.

Amazon Aurora

Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora provides up to five times better performance than MySQL at a price point one tenth that of a commercial database while delivering similar performance and availability.

Hibernate

Hibernate is a suite of open source projects around domain models. The flagship project is Hibernate ORM, the Object Relational Mapper.

ClearDB

ClearDB uses a combination of advanced replication techniques, advanced cluster technology, and layered web services to provide you with a MySQL database that is "smarter" than usual.

MikroORM

TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.

Entity Framework

It is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write.

peewee

A small, expressive orm, written in python (2.6+, 3.2+), with built-in support for sqlite, mysql and postgresql and special extensions like hstore.

MyBatis

It is a first class persistence framework with support for custom SQL, stored procedures and advanced mappings. It eliminates almost all of the JDBC code and manual setting of parameters and retrieval of results. It can use simple XML or Annotations for configuration and map primitives, Map interfaces and Java POJOs (Plain Old Java Objects) to database records.