SQLAlchemy vs NHibernate

Overview

SQLAlchemy

Stacks1.6K

Followers511

Votes7

GitHub Stars3.5K

Forks878

NHibernate

Stacks116

Followers92

Votes5

GitHub Stars2.2K

Forks930

NHibernate vs SQLAlchemy: What are the differences?

NHibernate: The object-relational mapper for .NET. It is a mature, open source object-relational mapper for the .NET framework. It's actively developed, fully featured and used in thousands of successful projects; SQLAlchemy: The Python SQL Toolkit and Object Relational Mapper. SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.

NHibernate and SQLAlchemy can be categorized as "Object Relational Mapper (ORM)" tools.

NHibernate and SQLAlchemy are both open source tools. SQLAlchemy with 3.36K GitHub stars and 888 forks on GitHub appears to be more popular than NHibernate with 1.64K GitHub stars and 825 GitHub forks.

MonkeyLearn, WakaTime, and YOU-app are some of the popular companies that use SQLAlchemy, whereas NHibernate is used by Pinnacle Sports, ProProcure, and CRM Solutions. SQLAlchemy has a broader approval, being mentioned in 46 company stacks & 122 developers stacks; compared to NHibernate, which is listed in 6 company stacks and 5 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)

or

Manual

Detailed Comparison

SQLAlchemy	NHibernate
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.	It is a mature, open source object-relational mapper for the .NET framework. It's actively developed, fully featured and used in thousands of successful projects.
Statistics
GitHub Stars 3.5K	GitHub Stars 2.2K
GitHub Forks 878	GitHub Forks 930
Stacks 1.6K	Stacks 116
Followers 511	Followers 92
Votes 7	Votes 5
Pros & Cons
Pros 7 Open Source Cons 2 Documentation	Pros 5 DDD friendly
Integrations
Python	.NET Visual Studio C#

What are some alternatives to SQLAlchemy, NHibernate?

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.

Hibernate

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

Doctrine 2

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.

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.

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.

Dapper

It is an object-relational mapping product for the Microsoft.NET platform: it provides a framework for mapping an object-oriented domain model to a traditional relational database.