Python Postgresql

Open-source Python projects categorized as Postgresql | Edit details

Top 23 Python Postgresql Projects

  • GitHub repo Redash

    Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.

    Project mention: How often do you use SQL query tool or service in your daily work? | | 2021-11-21

    Regarding the subqueries: try or, they materialize queried data so you can do a subquery multiple times.

  • GitHub repo pgcli

    Postgres CLI with autocompletion and syntax highlighting

    Project mention: Commandline Database Clients with Autocompletion and Syntax Highlighting | | 2021-02-18

    In what way did it blow up? You must have hit a bug, using .pg_service should work. Would you care to open an issue on or just dump the error message here so we can investigate?

  • Scout APM

    Scout APM: A developer's best friend. Try free for 14-days. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.

  • GitHub repo full-stack-fastapi-postgresql

    Full stack, modern web application generator. Using FastAPI, PostgreSQL as database, Docker, automatic HTTPS and more.

    Project mention: FastAPI + SQLModel + FastAPI-crudrouter + testcontainers setup | | 2021-11-21

    I would say that after spending some time with the docs, and looking at demo repos such as this one you will start to see that most projects follow a familiar structure and from there things will just click and you'll be able to turn your ideas into code without thinking much about it. Good luck!

  • GitHub repo dev-setup

    macOS development environment setup: Easy-to-understand instructions with automated setup scripts for developer tools like Vim, Sublime Text, Bash, iTerm, Python data analysis, Spark, Hadoop MapReduce, AWS, Heroku, JavaScript web development, Android development, common data stores, and dev-based OS X defaults.

    Project mention: MacOS Development workspace 2021 | | 2021-03-08

    donnemartin - dev setup

  • GitHub repo asyncpg

    A fast PostgreSQL Database Client Library for Python/asyncio.

    Project mention: Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service | | 2021-11-13

    Simple query runs long when DB schema contains thousands of tables #186

  • GitHub repo patroni

    A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes

    Project mention: PostgreSql High Availability | | 2021-10-24
  • GitHub repo wal-e

    Continuous Archiving for Postgres

    Project mention: Change Data Capture with Debezium | | 2021-11-01

    These read-replicas leveraged WAL segments created by the primary database; however, we didn’t want to bog down the primary database with each replica by reading directly from production. To circumvent this issue, we leverage wal-e, a tool that performs continuous archiving of PostgreSQL WAL files and base backups, and read replicas restored from s3 or gcs versus reading directly from the primary database.

  • Nanos

    Run Linux Software Faster and Safer than Linux with Unikernels.

  • GitHub repo PonyORM

    Pony Object Relational Mapper

  • GitHub repo tortoise-orm

    Familiar asyncio ORM for python, built with relations in mind

    Project mention: Tortoise-ORM: Familiar asyncio ORM for Python, built with relations in mind | | 2021-04-28
  • GitHub repo migra

    Like diff but for PostgreSQL schemas

    Project mention: Deploying/Managing DDL | | 2021-07-29

    We use migra to generate migration DDL, manually modify it as needed (it tends to be overeager to drop and create tables), use migra again to ensure old DDL + migration DDL == new DDL, attach the migration DDL to the PR, and manually run it after the PR's been reviewed and merged. I wouldn't say I love our process, but I like the simplicity and it hasn't been a pain point.

  • GitHub repo mara-pipelines

    A lightweight opinionated ETL framework, halfway between plain scripts and Apache Airflow

    Project mention: How to keep track of the different Transformations done in an ETL pipeline? | | 2021-08-22

    The closest I've found is Mara but not what I'm after.

  • GitHub repo Gopherus

    This tool generates gopher link for exploiting SSRF and gaining RCE in various servers

    Project mention: Is the Web Application Hacker's Handbook still relevant? | | 2021-05-06
  • GitHub repo Barman

    Barman - Backup and Recovery Manager for PostgreSQL

    Project mention: Oracle RMAN equivalent backup tool for PostgreSQL | | 2021-04-11

    Why chose it over Barman?

  • GitHub repo pghoard

    PostgreSQL backup and restore service

    Project mention: Backup PostgreSQL | | 2021-11-22
  • GitHub repo spilo

    Highly available elephant herd: HA PostgreSQL cluster using Docker

    Project mention: Backup Postgresql Docker | | 2021-04-16
  • GitHub repo piccolo

    A fast, user friendly ORM and query builder which supports asyncio.

    Project mention: GitHub - piccolo-orm/piccolo: A fast, user friendly ORM and query builder which supports asyncio. | | 2021-08-09
  • GitHub repo FeedHQ

    FeedHQ is a web-based feed reader

  • GitHub repo aerich

    A database migrations tool for TortoiseORM, ready to production.

    Project mention: FastAPI + Ormar + Alembic setup | | 2021-08-14

    We have successfully setup out FastAPI + ormar + alembic project. With pydantic support, ormar can generate pydantic models from ormar models. The generated pydantic models can be used by FastAPI during request/response data validation. ormar + alembic is a great duo to writing database code. Another great combination is tortoise ORM + aerich, which I'm planning to write soon.

  • GitHub repo django-migration-linter

    :rocket: Detect backward incompatible migrations for your django project

    Project mention: Does anyone use ci/cd for deploying database changes? | | 2021-08-18

    There's actually a Django package called django-migration-linter that can help with this by spotting migrations that could break under that condition:

  • GitHub repo postgrest-docs

    Documentation for PostgREST

    Project mention: How to CRUD with Node.js and MongoDB | | 2021-06-08
  • GitHub repo queries

    PostgreSQL database access simplified

  • GitHub repo choochoo

    Training Diary

    Project mention: Any tools for monitoring fitness without a power meter, besides Strava? | | 2021-01-21

    if not, and you're competent with docker, you may be able to get choochoo running -

  • GitHub repo usaspending-api

    Server application to serve U.S. federal spending data via a RESTful API

    Project mention: U.S. Treasury Data Lab | | 2021-09-14

    I've never tried their APIs, but I believe their API would be the only way to get more granular information you are looking for:



    * For geography based spending -

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2021-11-22.

Python Postgresql related posts


What are some of the best open-source Postgresql projects in Python? This list will help you:

Project Stars
1 Redash 19,987
2 pgcli 9,927
3 full-stack-fastapi-postgresql 7,391
4 dev-setup 5,566
5 asyncpg 5,183
6 patroni 4,386
7 wal-e 3,308
8 PonyORM 2,742
9 tortoise-orm 2,518
10 migra 2,072
11 mara-pipelines 1,829
12 Gopherus 1,674
13 Barman 1,201
14 pghoard 1,070
15 spilo 905
16 piccolo 593
17 FeedHQ 529
18 aerich 420
19 django-migration-linter 324
20 postgrest-docs 245
21 queries 236
22 choochoo 201
23 usaspending-api 191
Find remote Postgresql jobs at our new job board There are 3 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives