Python Postgresql

Open-source Python projects categorized as Postgresql

Top 23 Python Postgresql Projects

  • Redash

    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

    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: Launch HN: Bracket (YC W22) – Two-Way Sync Between Salesforce and Postgres | news.ycombinator.com | 2023-12-12

    I'l also give a shout-out to Airbyte (https://airbyte.com/), with which I've had some limited success with integrating Salesforce to a local database. The particular pull for Airbyte is that we can self-host the open source version, rather than pay Fivetran a significant sum to do this for us.

    It's an immature tool, so I don't yet know that I can claim we've spent _less_ than Fivetran on the additional engineering and ops time, but it feels like it has potential to do so once stabilized.

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo
  • pgcli

    Postgres CLI with autocompletion and syntax highlighting

  • asyncpg

    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

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

  • Project mention: Citus is not ACID but Eventually Consistent | dev.to | 2023-08-15

    Citus doesn't provide fault tolerance. Each shard is a monolithic PostgreSQL. To reduce downtime on failures, you can protect each shard with a standby database. As this is a complex configuration, Patroni can help. For this lab I'll use the Citus+Patroni docker-compose-citus.yml from https://github.com/zalando/patroni.git:

  • dev-setup

    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

    Familiar asyncio ORM for python, built with relations in mind

  • Project mention: How to Connect a FastAPI Server to PostgreSQL and Deploy on GCP Cloud Run | dev.to | 2023-05-26

    To do this, we can use the Tortoise-ORM. Begin by installing the package:

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

    the portable Python dataframe library

  • Project mention: This Week In Python | dev.to | 2024-03-17

    ibis – portable Python dataframe library

  • PonyORM

    Pony Object Relational Mapper

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

  • migra

    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

    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

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

  • pg_activity

    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

    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

    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:

  • mara-pipelines

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

  • baserow

    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.

  • Barman

    Barman - Backup and Recovery Manager for PostgreSQL

  • borgmatic

    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

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

  • fapro

    Fake Protocol Server

  • 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). The latest post mention was on 2024-04-17.

Python Postgresql related posts

Index

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

Project Stars
1 Redash 24,917
2 airbyte 13,923
3 pgcli 11,687
4 asyncpg 6,596
5 patroni 6,195
6 dev-setup 6,032
7 tortoise-orm 4,224
8 ibis 4,074
9 PonyORM 3,514
10 wal-e 3,423
11 migra 2,861
12 data-diff 2,830
13 Gopherus 2,644
14 pg_activity 2,393
15 ingestr 2,289
16 mathesar 2,196
17 pgadmin4 2,096
18 mara-pipelines 2,054
19 baserow 2,047
20 Barman 1,836
21 borgmatic 1,636
22 prisma-client-py 1,590
23 fapro 1,497

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