aiopg vs asyncpg vs psycopg3

This page summarizes the projects mentioned and recommended in the original post on /r/learnpython
Postgresql Python Database Drivers Database Development

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

  • aiopg

    aiopg is a library for accessing a PostgreSQL database from the asyncio

    • aiopg: 1.3k starts, last commit 1 nov 2021, recent bug in newer SQLAlchemy version, few open PRs, most recent PRs did not get a contributor response.

  • asyncpg

    A fast PostgreSQL Database Client Library for Python/asyncio.

    • asyncpg: 5.5k starts, last commit recently, ~150 issues, some incompatibility, few open PRs, extensive README. Includes benchmark showing it's supposedly 3x faster than aiopg and psycopg2, psycopg3 is not mentioned in the benchmark.

  • 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

  • psycopg

    New generation PostgreSQL database adapter for the Python programming language

    • psycopg3: 707 stars (que?), last commit recently, 20 issues, some incompatibility , 3 open PRs. First page of merged PRs were this year (2022). Extensive docs, docs on async topic include useful examples.In one of the PRs, a main contributor shared a blogpost (May 2020) they wrote. The topic was optimization and tagged with psycopg and development. asyncpg is faster, but psycopg aims to be more user-friendly

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