Sonar helps you commit clean code every time. With over 225 unique rules to find Python bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work. Learn more →
Similar projects and alternatives to SQLAlchemy
Data validation using Python type hints
FastAPI framework, high performance, easy to learn, fast to code, ready for production
Write Clean Python Code. Always.. Sonar helps you commit clean code every time. With over 225 unique rules to find Python bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.
Pony Object Relational Mapper
Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more
Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch
a small, expressive orm -- supports postgresql, mysql and sqlite
Familiar asyncio ORM for python, built with relations in mind
Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.
The Orator ORM provides a simple yet beautiful ActiveRecord implementation.
A pure Python Database Abstraction Layer
The Web framework for perfectionists with deadlines.
GINO Is Not ORM - a Python asyncio ORM on SQLAlchemy core.
The MongoDB Database
Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of use
Visual Studio Code
Visual Studio Code
Web APIs for Django. 🎸
A refreshingly simple data-driven game engine built in Rust
Light, Flexible and Extensible ASGI API framework | Effortlessly Build Performant APIs [Moved to: https://github.com/litestar-org/litestar]
Godot Engine – Multi-platform 2D and 3D game engine
scikit-learn: machine learning in Python
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
SQLAlchemy reviews and mentions
Is there a Python module that can store data between runs?
2 projects | /r/learnpython | 14 Apr 2023
Starlite updates March '22 | 2.0 is coming
14 projects | /r/Python | 26 Mar 2023
This feature is yet to be released, but it will allow you to seamlessly use data modelled with for example Pydantic, SQLAlchemy, msgspec or dataclasses in your route handlers, without the need for an intermediary model; The conversion will be handled by the specific DTO "backend" implementation. This new paradigm also makes it trivial to add support for any such modelling library, by simply implementing an appropriate backend.
Reddit Recap Series: Backend Performance Tuning
4 projects | /r/RedditEng | 13 Mar 2023
The second problem was caused by the pgBouncer setup. pgBouncer is an impostor that owns several dozen of real PostgreSQL connections, but pretends that it has thousands of them available for the backend services. Similar to fractional-reserve banking. So, it needs a way to find out when the real DB connection becomes free and can be used by another service. Our pgBouncer was configured as pool_mode=transaction. I.e., it detected when the current transaction was over, and returned the PostgreSQL connection into the pool, making it available to other users. However, this mode was found to not work well with the code that was using SQLAlchemy: committing the current transaction immediately started a new one. So, the expensive connection between pgBouncer and PostgreSQL remained checked out as long as the connection from service to pgBouncer remained open (forever, or close to that).
Domain model with SQLAlchemy
2 projects | dev.to | 16 Feb 2023
In this blog post, we will explore the power of SQLAlchemy, a popular ORM library in Python, to model our domain objects.
Is Python the right language for database work?
3 projects | /r/learnpython | 13 Feb 2023
How To Generate Test Data for Your Database Project With Python
4 projects | dev.to | 7 Feb 2023
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.
Getting Started with Fast-Api 🏎️ and Docker🐳
11 projects | dev.to | 2 Feb 2023
In the code ,we are using SQLAlchemy as our ORM(Object Relational Mapper) and Databases as our query builder.
How to query pandas DataFrames with SQL
5 projects | dev.to | 1 Feb 2023
There are multiple ways to run SQL queries in a Jupyter notebook, but this tutorial will focus on using SQLAlchemy --- a Python library that provides an API for connecting to and interacting with different relational databases, including SQLite, MySQL, and PostgreSQL.
SQLAlchemy 2.0.0 Released
2 projects | /r/Python | 26 Jan 2023
that said, most "pagination" is done for stateless web applications so you would want a strategy that SELECTs only the rows you want in the first place, a good article on that is at https://use-the-index-luke.com/blog/2013-07/pagination-done-the-postgresql-way ; within SQLAlchemy, we have some (older API style, but still general idea works) wiki examples for both a criteria-based solution as well as one that uses window functions: https://github.com/sqlalchemy/sqlalchemy/wiki/RangeQuery-and-WindowedRangeQuery
What are some good useful libraries I can get the hang of?
3 projects | /r/learnpython | 18 Jan 2023
prisma-client-py if you need an ORM (or SQLModel; both are pydantic based while the later is also sqlalchemy based)
A note from our sponsor - Sonar
www.sonarsource.com | 5 Jun 2023
sqlalchemy/sqlalchemy is an open source project licensed under MIT License which is an OSI approved license.
The primary programming language of SQLAlchemy is Python.