Migrating to SQLAlchemy 2.0

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Scout Monitoring - Free Django app performance insights with Scout Monitoring
Get Scout setup in minutes, and let us sweat the small stuff. A couple lines in settings.py is all you need to start monitoring your apps. Sign up for our free tier today.
www.scoutapm.com
featured
InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
  • asyncpg

    A fast PostgreSQL Database Client Library for Python/asyncio.

    Agreed. I will never recommend an ORM, things simply spiraled out of control for medium to large-ish projects that had more than 2 developers. Even with "best practices", code ended up having a mix of raw SQL and ORM-style queries, and it was hard to reason about the code.

    Since switching to asyncpg [0] these problems have vanished. It commands a deeper knowledge of actual SQL, but I would argue this knowledge is absolutely necessary and one of the disadvantages of an ORM is that it makes the SQL that is eventually run opaque.

    Not sure if there are equivalents to asyncpg for other RDBMS's.

    [0]: https://github.com/MagicStack/asyncpg

  • Scout Monitoring

    Free Django app performance insights with Scout Monitoring. Get Scout setup in minutes, and let us sweat the small stuff. A couple lines in settings.py is all you need to start monitoring your apps. Sign up for our free tier today.

    Scout Monitoring logo
  • PyPika

    PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.

    There is a middle-ground between writing SQL statement strings in your code, and a full-blown ORM: query builders. At least in my experience with small to medium projects, these have far fewer footguns while keeping the code composable and readable. Here's one for Python: https://github.com/kayak/pypika

  • django-compositepk-model

    Extended Django Model class with composite-primary-key support

    The beauty of the Django ecosystem, is that you have packages for everything: djangopackages.org

    E.G: https://github.com/Arisophy/django-compositepk-model

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • PyPy has been working for me for several years now

    4 projects | news.ycombinator.com | 30 May 2024
  • Can I learn Python while practicing writing queries for SQL simultaneously? I've recently completed learning SQL and trying to get better at it.

    1 project | /r/SQL | 10 May 2023
  • Installing psycopg2==2.8.6 throws an error

    1 project | /r/django | 18 Feb 2023
  • Uploading CSVs to a SQL table using Python

    1 project | /r/pythontips | 15 Jan 2023
  • Integrate PostgreSQL Database In Python - A Hands-On Guide

    1 project | /r/Python | 30 Dec 2022