Medium
medium.com › @saveriomazza › prisma-vs-sqlalchemy-a-comparative-guide-268cabb77d7d
Prisma vs SQLAlchemy: A Comparative Guide | Medium
November 4, 2023 - Choosing the right Object-Relational Mapping (ORM) tool can significantly affect the efficiency and quality of your database interactions. This article delves into a comparative analysis of Prisma and SQLAlchemy, two leading ORMs in the development world, outlining their main components, advantages, disadvantages, and suitable use cases.
Reddit
reddit.com › r/fastapi › prisma vs alembic for managing database schema and migrations
r/FastAPI on Reddit: Prisma vs Alembic for managing database schema and migrations
April 25, 2023 -
I’ve been experimenting with building a large fastapi project for a client and recently started using prisma cli for managing my database migrations.
Prisma python has bindings to the rust based cli by prisma.io and the cli has been growing rapidly in the typescript community.
Do you think this is an easier solution to adopting sqlAlchemy and alembic for managing db and migrations with fastapi?
If you need more context someone has already produced a short tutorial on prisma python.
https://lewoudar.medium.com/alternatives-to-sqlalchemy-for-your-project-prisma-case-9df8ce037578
Note: Prisma python client is a small project supported by prisma.io but Prisma cli has been around for quite a while and loved by the typescript community.
Top answer 1 of 2
4
Prisma is great for sure! My two cents are simple. It depends of which ORM you are using. If you are with SQLALCHEMY, no brainer for alembic and that is because it's mature, widely adopted, massive community and more importantly, built by the same author of SQLAlchemy and that is guaranteed support. Prisma on the other hand, like you said, it's still recent and I'm not 100% confident how would work with SQLAlchemy here. If you are into other ORMs, then why not? :) I built one based on SQLAlchemy core and brings native migrations as well and that is on the top of alembic. https://saffier.tarsild.io - it's framework agnostic and works really well with FastAPI In the end it comes down to which one you feel more confident and comfortable.
2 of 2
1
I don't see how this is better than sqlalchemy: u have no hints, no auto completion, defining models requires a foreign language... I don't see it easier to work with. Sqlalchemy changed greatly in its v2, and yes, despite its api not being the most comfy one, so far I can say it really is the most powerful one. And yes, I also love django's orm :P
How do you manage multiple database environments with SQLAlchemy & Alembic? Jan 14, 2025
r/learnpython last yr.
GitHub
github.com › RobertCraigie › prisma-client-py › issues › 69
Generate sqlalchemy models · Issue #69 · RobertCraigie/prisma-client-py
September 21, 2021 - You've been busy here - very cool. I'm afraid that many people would be very careful about moving to a new ORM in python - have you considered generate from prisma to sqlalchemy models inst...
Author RobertCraigie
Medium
medium.com › @connect.hashblock › typeorm-vs-prisma-vs-sqlalchemy-pick-by-maintainability-23a0b57fc97c
TypeORM vs Prisma vs SQLAlchemy: Pick by Maintainability | by Hash Block | Medium
October 24, 2025 - Prisma (Node/TS): Schema-first with a compiler that generates a type-safe client; opinionated migrations; fantastic DX. SQLAlchemy (Python): Mature ecosystem; Core (SQL) and ORM; powerful expression language; strong alembic migrations.
DEV Community
dev.to › sajjadali › why-you-should-use-prisma-orm-in-your-next-project-oah
Why You Should Use Prisma ORM in Your Next Project 🚀 - DEV Community
February 27, 2025 - In my search for the best ORM, I came across Prisma, and I must say—it’s one of the best! Before choosing Prisma, I explored SQLAlchemy and a few others, but they weren’t as flexible. One major downside of SQLAlchemy is that you need to define data models and data classes manually.
Medium
lewoudar.medium.com › alternatives-to-sqlalchemy-for-your-project-prisma-case-9df8ce037578
Alternatives to SQLAlchemy for your project — Prisma case | by Kevin Tewouda | Medium
December 27, 2022 - For data engineers/data scientists ... data from databases. Prisma is a recent TypeScript ORM taking a different approach from its predecessors and focusing on type safety thanks to TypeScript....
DEV Community
dev.to › le_woudar › alternatives-to-sqlalchemy-for-your-project-prisma-case-484k
Alternatives to SQLAlchemy for your project - Prisma case - DEV Community
December 27, 2022 - In Prima, it all starts with a schema.prisma file where you define your business models and relations between them. After that you will invoke a prisma CLI command to generate the client. This is different from ORMs like Django ORM and SQLAlchemy which use the Active Record pattern where we define model classes with data and methods to interact with the database.
Stateofdb
stateofdb.com › vs › prisma-vs-sqlalchemy
Prisma vs SQLAlchemy - State of Databases 2023
The State of Databases survey takes the pulse of the databases that teams, individuals, startups, enterprises and hobbyists are using, as well as track the pay and demographic data of developers who are working with each stack.
Pip Trends
piptrends.com › compare › alembic-vs-sqlalchemy-vs-prisma
alembic vs sqlalchemy vs prisma
Compare alembic, sqlalchemy, prisma
StackShare
stackshare.io › stackups › prisma-vs-sqlalchemy
SQLAlchemy vs Prisma | What are the differences? | StackShare
SQLAlchemy - SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. Prisma - Prisma is an open-source database toolkit. It replaces traditional ORMs and makes ...
DEV Community
dev.to › vikyw89 › embracing-type-safety-and-database-pulling-with-prisma-client-python-gjj
Embracing Type Safety and Database Pulling with Prisma Client Python - DEV Community
August 4, 2024 - Database pulling allows you to introspect your database schema and generate the corresponding Prisma client automatically. This feature is particularly valuable for scenarios where your database schema evolves over time or when you are working with an existing database. In contrast, SQLAlchemy operates more on the premise of defining models that map to your database tables in code, requiring additional steps to synchronize changes with the actual database.
Hacker News
news.ycombinator.com › item
I LOVE Prisma. I’ve used Django, SQLAlchemy, Sequelize, Knex, and TypeORM in the... | Hacker News
April 22, 2021 - Prisma is different. It’s absolutely got rough edges, but the extremely strong type safety makes Sequelize look like a joke. The query engine itself, written in rust, combines and optimizes queries inside every tick of the event loop so GraphQL N+1 issues are a thing of the past · Also, ...
Hacker News
news.ycombinator.com › item
Ask HN: Is SQLAlchemy the industry standard Python ORM in 2023? | Hacker News
June 18, 2023 - Note that there are several types of technologies that can help connect an application to an SQL database: · An interesting discussion can be found here: https://www.youtube.com/watch?v=x1fCJ7sUXCM
Prisma
prisma.io › orm › overview › introduction
Why Prisma ORM? Comparison with SQL query builders & ORMs | Prisma Documentation
On this page, you'll learn about the motivation for Prisma ORM and how it compares to other database tools like traditional ORMs and SQL query builders.
CSDN
devpress.csdn.net › python › 62f4dc8dc6770329307fa62c.html
Alternatives to SQLAlchemy for your project - Prisma case_python_Mangs-Python
In Prima, it all starts with a schema.prisma file where you define your business models and relations between them. After that you will invoke a prisma CLI command to generate the client. This is different from ORMs like Django ORM and SQLAlchemy which use the Active Record pattern where we define model classes with data and methods to interact with the database.
Python Central
pythoncentral.io › benefits-of-object-relational-mapping-with-prisma
Benefits of Object Relational Mapping with Prisma
December 5, 2022 - The Prisma open-source ORM provides many benefits above other ORMs in the industry and is therefore one of the leading options in the industry. Home · Python Tips and Tricks · Python Library Tutorials · Python Tools · Python Recipes · Python How To's · Python Tutorials · Python API References · Python Data Structures Tutorial · Python SQLAlchemy Tutorial ·
Medium
eash98.medium.com › why-sqlalchemy-should-no-longer-be-your-orm-of-choice-for-python-projects-b823179fd2fb
Why SQLAlchemy should no longer be your ORM of choice for Python projects | by Eshwaran Venkat | Medium
January 20, 2023 - You can now query the tables using the Prisma ORM which is similar to the query generators on SQLAlchemy or SQLModel.
Libhunt
python.libhunt.com › compare-prisma-client-py-vs-sqlalchemy
Prisma Client Python vs SQLAlchemy | LibHunt
Compare Prisma Client Python and SQLAlchemy's popularity and activity. Categories: ORM and Relational Databases. Prisma Client Python is less popular than SQLAlchemy.
LibHunt
libhunt.com › compare-sqlalchemy-vs-prisma-client-py
SQLAlchemy vs prisma-client-py - compare differences and reviews? | LibHunt
SQLAlchemy [0] is still arguably the most featureful and robust ORM in Python (although it is much more than an ORM). It is likely the best default choice unless you're already working within a framework that offers its own ORM. ... Posts with mentions or reviews of prisma-client-py.
LibHunt
libhunt.com › compare-prisma-client-py-vs-sqlalchemy
prisma-client-py vs SQLAlchemy - compare differences and reviews? | LibHunt
Prisma Client Python is an easy to use, fully typed ORM that supports SQLite, PostgreSQL, MongoDB, MySQL and SQL Server! Posts with mentions or reviews of SQLAlchemy. We have used some of these posts to build our list of alternatives and similar ...