Doctrine 2 vs MyBatis

Overview

Doctrine 2

Stacks284

Followers207

Votes31

MyBatis

Stacks279

Followers178

Votes17

GitHub Stars20.3K

Forks13.0K

Doctrine 2 vs MyBatis: What are the differences?

Developers describe Doctrine 2 as "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. On the other hand, MyBatis is detailed as "SQL Mapper Framework for Java". 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.

Doctrine 2 belongs to "Object Relational Mapper (ORM)" category of the tech stack, while MyBatis can be primarily classified under "Java Tools".

MyBatis is an open source tool with 11.5K GitHub stars and 7.26K GitHub forks. Here's a link to MyBatis's open source repository on GitHub.

Vend, LinkORB, and Cine-Loisirs are some of the popular companies that use Doctrine 2, whereas MyBatis is used by Jobsrepublic, Luxottica Retail, and Consignet. Doctrine 2 has a broader approval, being mentioned in 45 company stacks & 109 developers stacks; compared to MyBatis, which is listed in 6 company stacks and 16 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

Doctrine 2	MyBatis
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.	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.
Statistics
GitHub Stars -	GitHub Stars 20.3K
GitHub Forks -	GitHub Forks 13.0K
Stacks 284	Stacks 279
Followers 207	Followers 178
Votes 31	Votes 17
Pros & Cons
Pros 14 Great abstraction, easy to use, good docs 10 Object-Oriented 7 Easy setup	Pros 6 Easy to use 3 Flexible 3 Extensions 3 Integrated with Spring 2 Data-first support
Integrations
PHP	No integrations available

What are some alternatives to Doctrine 2, MyBatis?

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.

Quarkus

It tailors your application for GraalVM and HotSpot. Amazingly fast boot time, incredibly low RSS memory (not just heap size!) offering near instant scale up and high density memory utilization in container orchestration platforms like Kubernetes. We use a technique we call compile time boot.

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.

Hibernate

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

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.

Entity Framework Core

It is a lightweight, extensible, open source and cross-platform version of the popular Entity Framework data access technology. It can serve as an object-relational mapper (O/RM), enabling .NET developers to work with a database using .NET objects, and eliminating the need for most of the data-access code they usually need to write.

SQLAlchemy

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.

guava

The Guava project contains several of Google's core libraries that we rely on in our Java-based projects: collections, caching, primitives support, concurrency libraries, common annotations, string processing, I/O, and so forth.