Top 23 Python Postgresql Projects
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.Project mention: How often do you use SQL query tool or service in your daily work? | reddit.com/r/SQL | 2021-11-21
Regarding the subqueries: try https://tablum.io or https://redash.io, they materialize queried data so you can do a subquery multiple times.
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?
Scout APM: A developer's best friend. Try free for 14-days. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.
Full stack, modern web application generator. Using FastAPI, PostgreSQL as database, Docker, automatic HTTPS and more.Project mention: FastAPI + SQLModel + FastAPI-crudrouter + testcontainers setup | reddit.com/r/FastAPI | 2021-11-21
I would say that after spending some time with the docs, and looking at demo repos such as this one https://github.com/tiangolo/full-stack-fastapi-postgresql you will start to see that most projects follow a familiar structure and from there things will just click and you'll be able to turn your ideas into code without thinking much about it. Good luck!
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: PostgreSql High Availability | reddit.com/r/sysadmin | 2021-10-24
Continuous Archiving for PostgresProject mention: Change Data Capture with Debezium | reddit.com/r/RedditEng | 2021-11-01
These read-replicas leveraged WAL segments created by the primary database; however, we didn’t want to bog down the primary database with each replica by reading directly from production. To circumvent this issue, we leverage wal-e, a tool that performs continuous archiving of PostgreSQL WAL files and base backups, and read replicas restored from s3 or gcs versus reading directly from the primary database.
Run Linux Software Faster and Safer than Linux with Unikernels.
Pony Object Relational Mapper
Familiar asyncio ORM for python, built with relations in mindProject mention: Tortoise-ORM: Familiar asyncio ORM for Python, built with relations in mind | news.ycombinator.com | 2021-04-28
Like diff but for PostgreSQL schemasProject mention: Deploying/Managing DDL | reddit.com/r/dataengineering | 2021-07-29
We use migra to generate migration DDL, manually modify it as needed (it tends to be overeager to drop and create tables), use migra again to ensure old DDL + migration DDL == new DDL, attach the migration DDL to the PR, and manually run it after the PR's been reviewed and merged. I wouldn't say I love our process, but I like the simplicity and it hasn't been a pain point.
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: Backup PostgreSQL | reddit.com/r/PostgreSQL | 2021-11-22
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: GitHub - piccolo-orm/piccolo: A fast, user friendly ORM and query builder which supports asyncio. | reddit.com/r/Python | 2021-08-09
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
Training DiaryProject mention: Any tools for monitoring fitness without a power meter, besides Strava? | reddit.com/r/Strava | 2021-01-21
if not, and you're competent with docker, you may be able to get choochoo running - https://github.com/andrewcooke/choochoo
Server application to serve U.S. federal spending data via a RESTful APIProject mention: U.S. Treasury Data Lab | news.ycombinator.com | 2021-09-14
I've never tried their APIs, but I believe their API would be the only way to get more granular information you are looking for:
* For geography based spending - https://github.com/fedspendingtransparency/usaspending-api/b...
Python Postgresql related posts
2 projects | reddit.com/r/PostgreSQL | 22 Nov 2021
GitHub - RobertCraigie/prisma-client-py: Prisma Client Python is an auto-generated and fully type-safe database client
1 project | reddit.com/r/Python | 16 Nov 2021
Type safe database access for Python – Prisma Client Python
1 project | news.ycombinator.com | 15 Nov 2021
Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service
7 projects | dev.to | 13 Nov 2021
I Built a Craft Beer Search Engine for Free
1 project | news.ycombinator.com | 4 Nov 2021
I Built a Craft Beer Search Engine for Free
1 project | news.ycombinator.com | 1 Nov 2021
Type safe ORM for Python – Prisma Client
1 project | news.ycombinator.com | 25 Oct 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.