Top 23 Python Postgresql Projects
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.
Postgres CLI with autocompletion and syntax highlightingProject 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?
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, 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.
donnemartin - dev setup
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
A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or KubernetesProject 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).
In-Database Machine LearningProject 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 - 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.
Continuous Archiving for Postgres
Pony Object Relational Mapper
Familiar asyncio ORM for python, built with relations in mindProject 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? 
Like diff but for PostgreSQL schemasProject 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.
A lightweight opinionated ETL framework, halfway between plain scripts and Apache AirflowProject 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.
This tool generates gopher link for exploiting SSRF and gaining RCE in various serversProject mention: Is the Web Application Hacker's Handbook still relevant? | reddit.com/r/Pentesting | 2021-05-06
Barman - Backup and Recovery Manager for PostgreSQLProject mention: Oracle RMAN equivalent backup tool for PostgreSQL | reddit.com/r/PostgreSQL | 2021-04-11
Why chose it over Barman?
PostgreSQL backup and restore serviceProject 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.
Highly available elephant herd: HA PostgreSQL cluster using DockerProject mention: Backup Postgresql Docker | reddit.com/r/PostgreSQL | 2021-04-16
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.
New generation PostgreSQL database adapter for the Python programming languageProject mention: Building a Micro Business: What Services I Pay For | dev.to | 2021-12-30
dvarrazzo: developer of psycopg
FeedHQ is a web-based feed reader
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.
:rocket: Detect backward incompatible migrations for your django projectProject 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
Documentation for PostgRESTProject mention: How to CRUD with Node.js and MongoDB | reddit.com/r/programming | 2021-06-08
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
9 projects | news.ycombinator.com | 29 Nov 2021
2 projects | reddit.com/r/PostgreSQL | 22 Nov 2021
What are some of the best open-source Postgresql projects in Python? This list will help you:
Are you hiring? Post a new remote job listing for free.