SQLAlchemy

The Database Toolkit for Python (by sqlalchemy)

SQLAlchemy Alternatives

Similar projects and alternatives to SQLAlchemy

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better SQLAlchemy alternative or higher similarity.

SQLAlchemy reviews and mentions

Posts with mentions or reviews of SQLAlchemy. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-04-14.
  • 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
    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 →

Stats

Basic SQLAlchemy repo stats
113
7,317
9.8
1 day ago

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.

SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com