Software Alternatives & Reviews

SQLAlchemy VS TypeORM

Compare SQLAlchemy VS TypeORM and see what are their differences

SQLAlchemy logo SQLAlchemy

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

TypeORM logo TypeORM

Node.js ORM written in TypeScript
  • SQLAlchemy Landing page
    Landing page //
    2023-08-01
  • TypeORM Landing page
    Landing page //
    2023-10-17

SQLAlchemy videos

SQLAlchemy ORM for Beginners

More videos:

  • Review - SQLAlchemy: Connecting to a database
  • Review - Mike Bayer: Introduction to SQLAlchemy - PyCon 2014

TypeORM videos

Should you use Sequelize, TypeORM, or Prisma 1?

More videos:

  • Review - Typeorm Migrations
  • Review - Many to Many Entities in Typeorm

Category Popularity

0-100% (relative to SQLAlchemy and TypeORM)
Web Frameworks
61 61%
39% 39
Databases
100 100%
0% 0
Developer Tools
0 0%
100% 100
Development
52 52%
48% 48

User comments

Share your experience with using SQLAlchemy and TypeORM. For example, how are they different and which one is better?
Log in or Post with

Social recommendations and mentions

Based on our record, TypeORM should be more popular than SQLAlchemy. It has been mentiond 13 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.

SQLAlchemy mentions (2)

  • Speak Your Queries: How Langchain Lets You Chat with Your Database
    Under the hood, LangChain works with SQLAlchemy to connect to various types of databases. This means it can work with many popular databases, like MS SQL, MySQL, MariaDB, PostgreSQL, Oracle SQL, and SQLite. To learn more about connecting LangChain to your specific database, you can check the SQLAlchemy documentation for helpful information and requirements. - Source: dev.to / about 1 year ago
  • My favorite Python packages!
    SQLModel is a library for interacting with SQL databases from Python code, using Python objects. It is designed to be intuitive, easy-to-use, highly compatible, and robust. It is powered by Pydantic and SQLAlchemy and relies on Python type annotations for maximum simplicity. The key features are: it's intuitive to write and use, highly compatible, extensible, and minimizes code duplication. The library does a lot... - Source: dev.to / over 1 year ago

TypeORM mentions (13)

  • TypeORM - remove children with orphanedRowAction
    TypeORM is a very convenient ORM for JS apps. We use it with NestJS and running it on NodeJS. - Source: dev.to / 6 months ago
  • Which local db to use?
    React-native-quick-sqlite if you know what you're doing and Know SQL it gives you more control over the database like executing custom SQL queries, or some advance things, you can use it with an orm like Typeorm. Source: over 1 year ago
  • How does TypeORM compare to Prisma?
    TypeORM is actively maintained and issues are being fixed. https://github.com/typeorm/typeorm. Source: over 1 year ago
  • ORMs in JavaScript
    TypeORM is an ORM that can run in NodeJS, Browser, Cordova, PhoneGap, Ionic, React Native, NativeScript, Expo, and Electron platforms and can be used with TypeScript and JavaScript (ES5, ES6, ES7, ES8). -- source. - Source: dev.to / almost 2 years ago
  • TypeORM: Object-relational mapping with Node.js
    TypeORM is an open source tool with over 28K GitHub stars and more than 1 million weekly downloads on npm at the time of writing. Launched on Feb 21, 2016, TypeORM has grown to become one of the most popular JavaScript ORMs and one of the most popular ORM libraries built for TypeScript projects. - Source: dev.to / almost 2 years ago
View more

What are some alternatives?

When comparing SQLAlchemy and TypeORM, you can also consider the following products

Hibernate - Hibernate an open source Java persistence framework project.

Prisma - Art filters using artificial intelligence to transform your photos into classic artwork.

Sequelize - Provides access to a MySQL database by mapping database entries to objects and vice-versa.

Entity Framework - See Comparison of Entity Framework vs NHibernate.

GraphQL - GraphQL is a data query language and runtime to request and deliver data to mobile and web apps.

ExpressJS - Sinatra inspired web development framework for node.js -- insanely fast, flexible, and simple