Top 23 Python Postgresql Projects

• Redash

  12 20,324 7.5 Python

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

  

  Project mention: Open source DW? | reddit.com/r/dataengineering | 2022-01-03

  Its a bad idea use Redash as ETL and Data warehouse? Im not a data engineer just looking for a low/mid scale solution for experiment.

• pgcli

  2 10,038 5.5 Python

  Postgres CLI with autocompletion and syntax highlighting

  

  Project mention: Commandline Database Clients with Autocompletion and Syntax Highlighting | news.ycombinator.com | 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 https://github.com/dbcli/pgcli/issues or just dump the error message here so we can investigate?

• SonarLint

  www.sonarlint.org

  sponsored

  Deliver Cleaner and Safer Code - Right in Your IDE of Choice!. SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.

  

• full-stack-fastapi-postgresql

  15 7,910 0.0 Python

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

  Project mention: Backend Developer building first big project, need your help | reddit.com/r/vuejs | 2022-01-10

  This full stack application template might be useful to check out. The frontend is Vuejs and seems to be well-structure.

• dev-setup

  1 5,590 0.0 Python

  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 | dev.to | 2021-03-08

  donnemartin - dev setup

• asyncpg

  5 5,251 7.5 Python

  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 | dev.to | 2021-11-13

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

• patroni

  7 4,475 8.3 Python

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

  

  Project mention: GCP Cloud SQL Migration without outage? | reddit.com/r/sre | 2021-12-17

  This is why I always recommend using a postgres proxy so you can point it to different database servers as you stand them up. AWS does this by default but GCP doesn’t yet, so you have to have your own Postgres proxy (e.g https://github.com/CrunchyData/crunchy-proxy) or move to an HA Postgres setup like Patroni that has streaming replication (https://github.com/zalando/patroni).

• MindsDB

  7 4,452 9.9 Python

  In-Database Machine Learning

  

  Project mention: MindsDB: Creating machine learning predictive models using SQL. | dev.to | 2022-01-19

  Want to try it out for yourself? Sign up for a free MindsDB account and join our community! Engage with MindsDB community on Slack or Github to ask questions, share and express ideas and thoughts!

• OPS

  github.com/nanovms

  sponsored

  OPS - Build and Run Open Source Unikernels. Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.

  

• wal-e

  5 3,321 0.4 Python

  Continuous Archiving for Postgres

  

  Project mention: Recovering a PostgreSQL Database After a Hard Drive Failure | news.ycombinator.com | 2021-12-31

  Hope this helps someone out there.

  https://github.com/wal-e/wal-e

• PonyORM

  0 2,789 6.3 Python

  Pony Object Relational Mapper

  

• tortoise-orm

  2 2,623 8.8 Python

  Familiar asyncio ORM for python, built with relations in mind

  

  Project mention: Show HN: Django Async ORM | news.ycombinator.com | 2021-12-01

  Thanks, it's great to see Django adding slowly but surely in all sorts of places.

  By the way, have you looked at tortoise orm, which is a fully async python ORM with very Django-like syntax? [1]

  [1] https://github.com/tortoise/tortoise-orm

• migra

  6 2,105 1.9 Python

  Like diff but for PostgreSQL schemas

  Project mention: Atlas – Terraform but for Database Migrations | news.ycombinator.com | 2022-01-20

  I use migra [https://databaseci.com/docs/migra] for PostgreSQL.

  I only put schema.sql into git, no migration scripts.

  To make changes, I update schema.sql and load it up into temporary db. Then I run migra prod_db temp_db and it spits out the SQL statements that take me from the old schema.sql (which was in production) to the new. I eyeball the statements and if they look good, I apply them to prod_db.

• mara-pipelines

  3 1,850 2.6 Python

  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? | reddit.com/r/dataengineering | 2021-08-22

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

• Gopherus

  1 1,749 0.0 Python

  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? | reddit.com/r/Pentesting | 2021-05-06

• Barman

  1 1,222 9.2 Python

  Barman - Backup and Recovery Manager for PostgreSQL

  

  Project mention: Oracle RMAN equivalent backup tool for PostgreSQL | reddit.com/r/PostgreSQL | 2021-04-11

  Why chose it over Barman?

• pghoard

  2 1,090 8.0 Python

  PostgreSQL backup and restore service

  

  Project mention: Future PostgreSQL: improvement to the replication protocol | dev.to | 2022-01-13

  This story starts with our own PgHoard, a PITR backup tool for PostgreSQL. PgHoard offers several methods to archive the WAL (Write Ahead Log), including pg_receivewal, a small application shipping with PostgreSQL which connects to a PostgreSQL cluster using the physical replication protocol to stream WAL as they are produced, optionally keeping track of the position on the server using a replication slot.

• spilo

  1 924 7.7 Python

  Highly available elephant herd: HA PostgreSQL cluster using Docker

  

  Project mention: Backup Postgresql Docker | reddit.com/r/PostgreSQL | 2021-04-16

• piccolo

  3 644 9.7 Python

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

  

  Project mention: Piccolo - a modern, async query builder / ORM for Postgres | reddit.com/r/PostgreSQL | 2022-01-08

  Hi, I'm a big fan of Postgres, and have been working on Piccolo for the last few years.

• psycopg

  1 579 9.9 Python

  New generation PostgreSQL database adapter for the Python programming language

  

  Project mention: Building a Micro Business: What Services I Pay For | dev.to | 2021-12-30

  dvarrazzo: developer of psycopg

• FeedHQ

  0 530 0.0 Python

  FeedHQ is a web-based feed reader

  

• aerich

  1 450 7.6 Python

  A database migrations tool for TortoiseORM, ready to production.

  

  Project mention: FastAPI + Ormar + Alembic setup | dev.to | 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.

• django-migration-linter

  1 335 7.8 Python

  :rocket: Detect backward incompatible migrations for your django project

  

  Project mention: Does anyone use ci/cd for deploying database changes? | reddit.com/r/Database | 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: https://github.com/3YOURMIND/django-migration-linter

• postgrest-docs

  1 260 8.2 Python

  Documentation for PostgREST

  

  Project mention: How to CRUD with Node.js and MongoDB | reddit.com/r/programming | 2021-06-08

• queries

  0 236 0.0 Python

  PostgreSQL database access simplified

Python Postgresql related posts

• Future PostgreSQL: improvement to the replication protocol
  1 project | dev.to | 13 Jan 2022
• Piccolo - a modern, async query builder / ORM for Postgres
  2 projects | reddit.com/r/PostgreSQL | 8 Jan 2022
• Recovering a PostgreSQL Database After a Hard Drive Failure
  2 projects | news.ycombinator.com | 31 Dec 2021
• GCP Cloud SQL Migration without outage?
  2 projects | reddit.com/r/sre | 17 Dec 2021
• Advice for syncing a Postgres database with a TimescaleDB database
  1 project | reddit.com/r/dataengineering | 3 Dec 2021
• PostgREST v9.0.0
  9 projects | news.ycombinator.com | 29 Nov 2021
• Backup PostgreSQL
  2 projects | reddit.com/r/PostgreSQL | 22 Nov 2021

Index

Sponsored

Less time debugging, more time building

Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

scoutapm.com

Get the trending Python projects
with our weekly report!
» Subscribe «