SQLAlchemy logo

SQLAlchemy

The Python SQL Toolkit and Object Relational Mapper
486
402
+ 1
5

What is SQLAlchemy?

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.
SQLAlchemy is a tool in the Object Relational Mapper (ORM) category of a tech stack.
SQLAlchemy is an open source tool with 3.4K GitHub stars and 885 GitHub forks. Here’s a link to SQLAlchemy's open source repository on GitHub

Who uses SQLAlchemy?

Companies
89 companies reportedly use SQLAlchemy in their tech stacks, including Hivestack, Gorgias, and Buzzvil.

Developers
355 developers on StackShare have stated that they use SQLAlchemy.

SQLAlchemy Integrations

Python, TimescaleDB, Nameko, Faust, and GreenDAO are some of the popular tools that integrate with SQLAlchemy. Here's a list of all 6 tools that integrate with SQLAlchemy.
Pros of SQLAlchemy
5
Open Source
Decisions about SQLAlchemy

Here are some stack decisions, common use cases and reviews by companies and developers who chose SQLAlchemy in their tech stack.

Nikola Tokic

I'm considering moving from Flask to Quart, does anyone have some experience with this migration?

I expect possible problems with connexion which we use as OpenAPI specification.

Would be good if someone can point downsides of moving to the Quart framework so I can double-check if my plan is worth doing.

Other libs and tools used in the project: SQLAlchemy, alembic, PostgreSQL, Datadog

cons for now:

  • Refactoring uncertainty (not sure how big of a task is it)
  • Connexion might not work with Quart (moving to another library)
  • ...
See more

SQLAlchemy Alternatives & Comparisons

What are some alternatives to SQLAlchemy?
Django
Django is a high-level Python Web framework that encourages rapid development and clean, pragmatic design.
Pandas
Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more.
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.
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
See all alternatives

SQLAlchemy's Followers
402 developers follow SQLAlchemy to keep up with related blogs and decisions.