Home
Application and Data
Data Stores
Object Relational Mapper (ORM)

Dapper vs SQLAlchemy

Need advice about which tool to choose?Ask the StackShare community!

Dapper
92
65
+ 1
6
SQLAlchemy
532
453
+ 1
6
Add tool

Dapper vs SQLAlchemy: What are the differences?

Developers describe Dapper as "A simple object mapper for .Net". 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. On the other hand, SQLAlchemy is detailed as "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.

Dapper and SQLAlchemy can be primarily classified as "Object Relational Mapper (ORM)" tools.

SQLAlchemy is an open source tool with 3.42K GitHub stars and 892 GitHub forks. Here's a link to SQLAlchemy's open source repository on GitHub.

Kaidee, Tiqets, and Gorgias are some of the popular companies that use SQLAlchemy, whereas Dapper is used by Credit Clear, Business Logic, and Knowcross Solution Pvt Ltd. SQLAlchemy has a broader approval, being mentioned in 83 company stacks & 241 developers stacks; compared to Dapper, which is listed in 6 company stacks and 17 developer stacks.

Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Dapper
Pros of SQLAlchemy
  • 6
    Fastest ORM
  • 6
    Open Source

Sign up to add or upvote prosMake informed product decisions

Cons of Dapper
Cons of SQLAlchemy
    Be the first to leave a con
    • 1
      Documentation

    Sign up to add or upvote consMake informed product decisions

    - No public GitHub repository available -

    What is 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.

    What is SQLAlchemy?

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

    Need advice about which tool to choose?Ask the StackShare community!

    Jobs that mention Dapper and SQLAlchemy as a desired skillset
    Associate Software Engineer
    CBRE
    United States of America Massachusetts Boston
    View Job Details
    TierScopeEntity Framework+6
    What companies use Dapper?
    What companies use SQLAlchemy?
    See which teams inside your own company are using Dapper or SQLAlchemy.
    Sign up for StackShare EnterpriseLearn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with Dapper?
    What tools integrate with SQLAlchemy?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to Dapper and SQLAlchemy?
    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.
    Hibernate
    Hibernate is a suite of open source projects around domain models. The flagship project is Hibernate ORM, the Object Relational Mapper.
    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.
    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.
    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.
    See all alternatives

    Related Comparisons

    Hibernate vs SQLAlchemy vs SequelizeSQLAlchemy vs Sequelize vs peeweeSQLAlchemy vs peeweeSQLAlchemy vs SequelizeHibernate vs SQLAlchemy

    Trending Comparisons

    Django vs Laravel vs Node.jsBootstrap vs Foundation vs Material-UINode.js vs Spring BootFlyway vs LiquibaseAWS CodeCommit vs Bitbucket vs GitHub

    Top Comparisons

    Bootstrap vs MaterializeHipChat vs Mattermost vs SlackBitbucket vs GitHub vs GitLabPostman vs Swagger UI