Top 23 Python Postgresql Projects

• Redash

  38 25,057 9.5 Python

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

  

Project mention: Redash: Connect to data source, easily visualize, dashboard and share your data | news.ycombinator.com | 2024-03-20

• airbyte

  140 14,217 10.0 Python

  The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.

  

Project mention: How to Build a Chat App with Your Postgres Data using Agent Cloud | dev.to | 2024-05-13

AgentCloud uses Airbyte to build data pipelines, which allow us to split, chunk, and embed data from over 300 data sources, including Postgres.

• InfluxDB

  www.influxdata.com featured

  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.

  

• pgcli

  9 11,746 7.1 Python

  Postgres CLI with autocompletion and syntax highlighting

  

• asyncpg

  15 6,645 6.8 Python

  A fast PostgreSQL Database Client Library for Python/asyncio.

  

Project mention: Ask HN: Is Python async/await some kind of joke? | news.ycombinator.com | 2024-01-27

- SqlAlchemy/asyncpg => you can’t use it if you’re using PgBouncer (necessary most of the time with Postgres) in transaction mode? What?? https://github.com/MagicStack/asyncpg/issues/1058

• patroni

  20 6,272 9.1 Python

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

  

Project mention: Ask HN: Are there any open source forks of nomad smd consul? | news.ycombinator.com | 2024-05-02

> I think etcd is basically a k8s only project now

I hate etcd with the best of them, but etcd is used in a lot more places than just kubernetes:

https://github.com/apache/apisix/blob/master/docs/en/latest/...

https://github.com/traefik/traefik#:~:text=Etcd,

https://github.com/zalando/patroni#patroni-a-template-for-po...

https://github.com/purpleidea/mgmt/tree/0.0.26/etcd (this one shows up on HN quite a bit)

https://github.com/sorintlab/stolon#features

It's actually one of the major reasons I wouldn't touch those projects

• dev-setup

  3 6,032 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.

• tortoise-orm

  9 4,268 7.8 Python

  Familiar asyncio ORM for python, built with relations in mind

  

Project mention: Building a full Django project, starting with a single file | news.ycombinator.com | 2024-04-23

• SaaSHub

  www.saashub.com featured

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

  

• ibis

  23 4,271 10.0 Python

  the portable Python dataframe library

  

Project mention: Show HN: Hashquery, a Python library for defining reusable analysis | news.ycombinator.com | 2024-04-23

I really don't understand the appeal of dbt vs a proper programming language. The templating approach leads to massive spaghetti. I look forward to trying out something like Ibis [0]

0: https://ibis-project.org/

• PonyORM

  2 3,533 5.0 Python

  Pony Object Relational Mapper

  

• wal-e

  7 3,427 3.0 Python

  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.

• migra

  25 2,869 0.0 Python

  Like diff but for PostgreSQL schemas

Project mention: Pgroll: zero-downtime, undoable, schema migrations for Postgres | news.ycombinator.com | 2023-10-03

Forr postgres, how does the schema diffing aspect compare to migra?

https://github.com/djrobstep/migra

I'm asking because, although migra is excellent and there are multiple migrations tools based on it (at least https://github.com/bikeshedder/tusker and https://github.com/blainehansen/postgres_migrator), issues are piling up but development seem to be slowing down

• data-diff

  20 2,865 9.4 Python

  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.

• Gopherus

  1 2,644 0.0 Python

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

• pg_activity

  5 2,404 7.7 Python

  pg_activity is a top like application for PostgreSQL server activity monitoring.

  

Project mention: FLaNK AI for 11 March 2024 | dev.to | 2024-03-11

• ingestr

  4 2,341 9.0 Python

  ingestr is a CLI tool to copy data between any databases with a single command seamlessly.

  

Project mention: FLaNK 04 March 2024 | dev.to | 2024-03-04

• mathesar

  53 2,223 9.9 Python

  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

  44 2,167 9.7 Python

  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:

• baserow

  14 2,082 9.8 Python

  The official repository is hosted on https://gitlab.com/bramw/baserow. Baserow is an open source no-code database tool and Airtable alternative.

Project mention: Baserow – Self Hosted Airtable Alternative Launches No-Code Application Builder | news.ycombinator.com | 2024-03-13

Hey, I'm one of the founders of Baserow. We launched the beta of our application builder last week. It allows you to build database-driven websites, web applications, and portals. It's in the same product as our database module, and will work seamlessly together with it. More information can be found in the release blog post linked to this post, and in this video https://www.youtube.com/watch?v=yjE7gxkPlDs. Even though it's in an early state, it's already possible to try it out on https://baserow.io or by self-hosting the latest version. Happy to answer all the questions you might have.

• mara-pipelines

  3 2,053 6.0 Python

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

  

• Barman

  1 1,871 8.5 Python

  Barman - Backup and Recovery Manager for PostgreSQL

  

• borgmatic

  61 1,652 9.4 Python

  Simple, configuration-driven backup software for servers and workstations

  

Project mention: Rclone syncs your files to cloud storage | news.ycombinator.com | 2024-01-26

- for important files, a separate box where I have borgmatic [1] in deduplication mode installed; this is updated once in a while

Just curious: Do you have any reason to believe that such a data corruption bug is likely in ZFS? It seems like saying that ext4 could have a bug and you should also store stuff on NTFS, just in case (which I think does not make sense..).

[1]: https://github.com/borgmatic-collective/borgmatic

• prisma-client-py

  11 1,624 9.0 Python

  Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of use

• fapro

  5 1,497 0.0 Python

  Fake Protocol Server

  

• SaaSHub

  www.saashub.com featured

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

  

Python Postgresql related posts

• Show HN: An SQS Alternative on Postgres

  10 projects | news.ycombinator.com | 9 May 2024

• Monitor Postgres replication slot growth via Slack

  1 project | news.ycombinator.com | 1 May 2024

• Minha jornada de otimização de uma aplicação django

  5 projects | dev.to | 13 Mar 2024

• FLaNK Stack 26 February 2024

  50 projects | dev.to | 26 Feb 2024

• Show HN: pg-bulk-ingest – now with multi-table support

  2 projects | news.ycombinator.com | 10 Feb 2024

• Monitoring Postgres Logical Replication Slots

  1 project | news.ycombinator.com | 15 Jan 2024

• Vanna.ai: Chat with your SQL database

  13 projects | news.ycombinator.com | 14 Jan 2024
• A note from our sponsor - InfluxDB
  www.influxdata.com | 17 May 2024

  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. Learn more →

Index

Sponsored

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com

Do not miss the trending Python projects with our weekly report!