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.5K GitHub stars and 909 GitHub forks. Here’s a link to SQLAlchemy's open source repository on GitHub
Who uses SQLAlchemy?
Companies
93 companies reportedly use SQLAlchemy in their tech stacks, including yogiyo, Hivestack, and Buzzvil.
Developers
410 developers on StackShare have stated that they use SQLAlchemy.
SQLAlchemy Integrations
Python, TimescaleDB, Faust, Nameko, and GreenDAO are some of the popular tools that integrate with SQLAlchemy. Here's a list of all 7 tools that integrate with SQLAlchemy.
Pros of SQLAlchemy
7
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
Software Engineer · | 7 upvotes · 27.8K views
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)
- ...
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.
