SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Python Postgre Projects
-
-
CodeRabbit
CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
-
📂 GitHub Repository 🌐 Website
-
This could be a nice option to add sqlglot here. As an advanced sql parsing library.
-
AwaitableModel is a model base class in UtilMeta to provide fully async query in Django using encode/databases, which will unleash the async performance for Django ORM
-
For me, it's case-by-case. I don't back up the VMs directly, just the date of the stateful applications running on the VMs (or bare metal servers, I do identical stuff for them).
For postgres, I used to just have a systemd timer that would `pg_dumpall` and throw it in s3.
Now I use https://github.com/wal-e/wal-e to backup my postgresql databases.
For other local files, I use borg backup for personal files and services I just run for myself, and I use restic to backup server files to s3.
The operating system's configuration is all stored in git via the magic of NixOS, so I don't have to worry about files in /etc, they all are 100% reproducible from my NixOS configuration.
-
pgadmin4
pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
Project mention: Set Up An E-Commerce Backend With Medusa In Just A Few Minutes | dev.to | 2025-03-12This will create a new PostgreSQL database. You may also create a new database via a GUI tool such as pgAdmin.
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
-
fastapi-react
🚀 Cookiecutter Template for FastAPI + React Projects. Using PostgreSQL, SQLAlchemy, and Docker
-
supabase-py
Python Client for Supabase. Query Postgres from Flask, Django, FastAPI. Python user authentication, security policies, edge functions, file storage, and realtime data streaming. Good first issue.
supabase-py was originally started by maintainer lqmanh in September of 2020, and was shortly after joined by fedden and J0 (who went on to become a full time member of the Supabase Team). In recent years development has been driven by silentworks and juancarlospaco who have both been instrumental in the push to reaching feature parity with supabase-js.
-
Project mention: I Ditched the Algorithm for RSS–and You Should Too | news.ycombinator.com | 2025-01-16
Same! I'm creating telegram channels for topics using https://github.com/Rongronggg9/RSS-to-Telegram-Bot
That's how I found out about this post https://t.me/best_hn/99
-
Udacity-Data-Engineering-Projects
Few projects related to Data Engineering including Data Modeling, Infrastructure setup on cloud, Data Warehousing and Data Lake development.
-
-
raglite
🥤 RAGLite is a Python toolkit for Retrieval-Augmented Generation (RAG) with PostgreSQL or SQLite
Project mention: Show HN: RAGLite – A Python package for the unhobbling of RAG | news.ycombinator.com | 2024-12-19 -
FastAPI-boilerplate
An extendable async API using FastAPI, Pydantic V2, SQLAlchemy 2.0, PostgreSQL and Redis. (by igorbenav)
-
-
-
astro-sdk
Astro SDK allows rapid and clean development of {Extract, Load, Transform} workflows using Python and SQL, powered by Apache Airflow.
-
Project mention: Ask HN: Is there any software you only made for your own use but nobody else? | news.ycombinator.com | 2024-07-04
- Markup to generate HTML I used in courses that I taught. The markup generated links according to an outline (next/prev page, next/prev section) and a few other navigation related things.
- Python-based pipe-objects-not-strings shell with cluster and database support deeply integrated. Twenty years later, it has turned into Marcel (https://marceltheshell.org), and I’m still the only one using it AFAIK.
-
rag-postgres-openai-python
A RAG app to ask questions about rows in a database table. Deployable on Azure Container Apps with PostgreSQL Flexible Server.
Project mention: Better RAG Results with Reciprocal Rank Fusion and Hybrid Search | news.ycombinator.com | 2024-05-30https://github.com/Azure-Samples/rag-postgres-openai-python/...
That's largely based off a sample from the pgvector repo, with a few tweaks.
Agreed that Hybrid is the way to go, it's what the Azure AI Search team also recommends, based off their research:
https://techcommunity.microsoft.com/t5/ai-azure-ai-services-...
-
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
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).
Python Postgres discussion
Python Postgres related posts
-
Building a Realworld blog backend in 600 lines of Python
-
You Probably Don't Need Query Builders
-
Setting Up CloudNativePG on KIND with pgAdmin
-
Postgres for Everything (E/Postgres)
-
dbhub.io alternatives - csvbase and sgr
3 projects | 21 Aug 2024 -
SQL e Ruby: Explorando Banco de Dados Além do Rails ActiveRecord
-
Do you need Redis? PostgreSQL does queuing, locking, and pub/sub
-
A note from our sponsor - SaaSHub
www.saashub.com | 26 Mar 2025
Index
What are some of the best open-source Postgre projects in Python? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | pgcli | 12,330 |
| 2 | frappe | 8,156 |
| 3 | sqlglot | 7,359 |
| 4 | databases | 3,889 |
| 5 | wal-e | 3,464 |
| 6 | pgadmin4 | 2,817 |
| 7 | Alerta | 2,421 |
| 8 | Barman | 2,276 |
| 9 | fastapi-react | 2,272 |
| 10 | supabase-py | 1,914 |
| 11 | RSS-to-Telegram-Bot | 1,688 |
| 12 | Udacity-Data-Engineering-Projects | 1,566 |
| 13 | docker-django-example | 1,266 |
| 14 | raglite | 869 |
| 15 | FastAPI-boilerplate | 867 |
| 16 | jupysql | 755 |
| 17 | docker-flask-example | 677 |
| 18 | astro-sdk | 367 |
| 19 | marcel | 341 |
| 20 | rag-postgres-openai-python | 329 |
| 21 | sgr | 322 |
| 22 | condenser | 322 |
| 23 | FastAPIQuickCRUD | 256 |
Sponsored
CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai