Python Postgres

Open-source Python projects categorized as Postgres
Edit details
Topics: Python Postgresql Docker SQL Django
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

Top 23 Python Postgre Projects

  • MindsDB

    The platform for customizing AI from enterprise data

    • Project mention: What’s the Difference Between Fine-tuning, Retraining, and RAG? | dev.to | 2024-04-08

    Check us out on GitHub.

  • pgcli

    Postgres CLI with autocompletion and syntax highlighting

  • 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.

    InfluxDB logo

  • frappe

    Low code web framework for real world applications, in Python and Javascript

  • sqlglot

    Python SQL Parser and Transpiler

    • Project mention: The Future of MySQL is PostgreSQL: an extension for the MySQL wire protocol | news.ycombinator.com | 2024-04-26

    This is probably referring to "zero changes to your driver code" and not "zero changes to the SQL you send over this driver".

    Translating between SQL dialects is notoriously hard and attempts to translate [1] are working in 95% of cases. But the last 5% would require 5x amount of work. That's because "SQL dialect" also includes weird edge cases of type inference of things like COALESCE(5, FALSE) and emulation of system catalogs (pg_catalog, information_schema).

    [1] https://github.com/tobymao/sqlglot

  • databases

    Async database support for Python. 🗄

  • wal-e

    Continuous Archiving for Postgres

    • Project mention: Run PostgreSQL. The Kubernetes Way | news.ycombinator.com | 2023-09-22

    See the GitHub: https://github.com/wal-e/wal-e

    Unmaintained would’ve made more sense to say, but the maintainer choose the words “obsolete” so I took those. :)

    Seems to be obsolete due to a lack of interest and contributions.

  • data-diff

    Compare tables within or across databases

    • Project mention: How to Check 2 SQL Tables Are the Same | news.ycombinator.com | 2023-07-26

    If the issue happen a lot, there is also: https://github.com/datafold/data-diff

    That is a nice tool to do it cross database as well.

    I think it's based on checksum method.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo

  • Alerta

    Alerta monitoring system

  • mathesar

    Web application providing an intuitive user experience to databases.

    • Project mention: Show HN: Teable – Open-Source No-Code Database Fusion of Postgres and Airtable | news.ycombinator.com | 2024-03-11

    Congratulations on launching, it's nice to see more open source products in this area (I work on https://mathesar.org/). Feel free to reach out if you'd like to talk and compare notes.

  • 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: Using migrations with Golang | dev.to | 2024-04-17

    If we access a client like PgAdmin or Beekeeper, or accessing its container via bash and checking via CLI, we can see that the table was created successfully:

  • fastapi-react

    🚀 Cookiecutter Template for FastAPI + React Projects. Using PostgreSQL, SQLAlchemy, and Docker

  • Barman

    Barman - Backup and Recovery Manager for PostgreSQL

  • Udacity-Data-Engineering-Projects

    Few projects related to Data Engineering including Data Modeling, Infrastructure setup on cloud, Data Warehousing and Data Lake development.

    • Project mention: Pitanje za data engineering? | /r/programiranje | 2023-06-30

  • docker-django-example

    A production ready example Django app that's using Docker and Docker Compose.

    • Project mention: Django 5.0 Is Released | news.ycombinator.com | 2023-12-04

    Congrats on the release to the Django community!

    If anyone is curious, I updated my Django / Docker starter kit app to use Django 5.0 at: https://github.com/nickjj/docker-django-example

    It pulls together gunicorn, Celery, Redis, Postgres, esbuild and Tailwind with Docker Compose. It's set up to run in both development and production.

  • jupysql

    Better SQL in Jupyter. 📊

    • Project mention: Show HN: JupySQL – a SQL client for Jupyter (ipython-SQL successor) | news.ycombinator.com | 2023-12-06

    Hey, HN community!

    We're stoked to launch JupySQL today! JupySQL is an open-source library that brings a modern SQL experience to Jupyter. JupySQL is compatible with all major databases, such as Snowflake, Redshift, PostgreSQL, MySQL, MariaDB, DuckDB, SQL Server, Clickhouse, Trino, and more!

    To get started, check out our tutorial: https://jupysql.ploomber.io/en/latest/quick-start.html

    SQL is the defacto language for data analysis; however, analysis often requires a mix of SQL and Python. JupySQL bridges this gap, allowing users to execute SQL queries seamlessly in Jupyter and continue their analysis in Python. Add %%sql to the top of your cell and start writing SQL.

    Here are some of JupySQL's main features:

    - Syntax highlighting

  • docker-flask-example

    A production ready example Flask app that's using Docker and Docker Compose.

    • Project mention: We Have to Talk About Flask | news.ycombinator.com | 2023-10-19

    I've been maintaining my Build a SAAS App with Flask video course[0] for 8 years. It has gone from pre-1.0 to 2.3 and has been recorded twice with tons of incremental updates added over the years to keep things current.

    In my opinion tutorial creators should pin their versions so that anyone taking the course or going through the tutorial will have a working version that matches the video or written material.

    I'm all for keeping things up to date and do update things every few months but rolling updates don't tend to work well for tutorials because sometimes a minor version requires a code change or covering new concepts. As a tutorial consumer it's frustrating when the content doesn't match the source code unless it's nothing but a version bump.

    I've held off upgrading Flask to 3.0 and Python 3.12 due to these open issues with 3rd party dependencies https://github.com/nickjj/docker-flask-example/issues/17.

    [0]: https://buildasaasappwithflask.com/

  • FastAPI-boilerplate

    An extendable async API using FastAPI, Pydantic V2, SQLAlchemy 2.0, PostgreSQL and Redis. (by igorbenav)

    • Project mention: 🚀FastAPI boilerplate (starter project) | /r/Python | 2023-11-14

    Yet another FastAPI Boilerplate (starter project) to help you productizing Machine Learning or just creating an API 🚀 https://github.com/igorbenav/FastAPI-boilerplate

  • marcel

    A modern shell (by geophile)

    • Project mention: Generating graphs from the marcel command line | news.ycombinator.com | 2024-03-08

    Marcel is one of the pipe-objects-instead-of-strings shells (https://marceltheshell.org).

    Here's a blog post showing how to use marcel to generate graphs directly from the command line.

    https://www.marceltheshell.org/post/generating-graphs-from-t...

  • sgr

    sgr (command line client for Splitgraph) and the splitgraph Python library

    • Project mention: Show HN: Loofi – Our AI-Powered SQL Query Builder | news.ycombinator.com | 2023-05-21

  • astro-sdk

    Astro SDK allows rapid and clean development of {Extract, Load, Transform} workflows using Python and SQL, powered by Apache Airflow.

    • Project mention: Orchestration: Thoughts on Dagster, Airflow and Prefect? | /r/dataengineering | 2023-06-01

    Have you tried the Astro SDK? https://github.com/astronomer/astro-sdk

  • condenser

    Condenser is a database subsetting tool

    • Project mention: Jailer, a unique open-source database tool | news.ycombinator.com | 2023-08-07

    [1]: https://github.com/TonicAI/condenser

  • pgANN

    Fast Approximate Nearest Neighbor (ANN) searches with a PostgreSQL database.

  • FastAPIQuickCRUD

    Generate CRUD methods in FastApi from an SQLAlchemy schema

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
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 related posts

Index

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

Project Stars
1 MindsDB 21,354
2 pgcli 11,729
3 frappe 6,496
4 sqlglot 5,573
5 databases 3,703
6 wal-e 3,424
7 data-diff 2,847
8 Alerta 2,330
9 mathesar 2,217
10 pgadmin4 2,123
11 fastapi-react 2,076
12 Barman 1,851
13 Udacity-Data-Engineering-Projects 1,295
14 docker-django-example 1,100
15 jupysql 610
16 docker-flask-example 551
17 FastAPI-boilerplate 363
18 marcel 332
19 sgr 326
20 astro-sdk 319
21 condenser 300
22 pgANN 290
23 FastAPIQuickCRUD 249

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com