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: How often do you use SQL query tool or service in your daily work? | reddit.com/r/SQL | 2021-11-21Regarding the subqueries: try https://tablum.io or https://redash.io, they materialize queried data so you can do a subquery multiple times.
-
Project 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
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-fastapi-postgresql
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-21I 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!
-
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.
donnemartin - dev setup
-
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
-
-
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.
-
-
-
Project mention: Tortoise-ORM: Familiar asyncio ORM for Python, built with relations in mind | news.ycombinator.com | 2021-04-28
-
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.
-
mara-pipelines
A lightweight opinionated ETL framework, halfway between plain scripts and Apache Airflow
Project mention: How to keep track of the different Transformations done in an ETL pipeline? | reddit.com/r/dataengineering | 2021-08-22The closest I've found is Mara but not what I'm after.
-
Project mention: Is the Web Application Hacker's Handbook still relevant? | reddit.com/r/Pentesting | 2021-05-06
-
Project mention: Oracle RMAN equivalent backup tool for PostgreSQL | reddit.com/r/PostgreSQL | 2021-04-11
Why chose it over Barman?
-
-
-
Project mention: GitHub - piccolo-orm/piccolo: A fast, user friendly ORM and query builder which supports asyncio. | reddit.com/r/Python | 2021-08-09
-
-
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.
-
Project 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
-
-
-
Project 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
-
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:
* https://github.com/fedspendingtransparency/usaspending-api
* https://api.usaspending.gov/docs/endpoints
* For geography based spending - https://github.com/fedspendingtransparency/usaspending-api/b...
Python Postgresql related posts
- Backup PostgreSQL
- GitHub - RobertCraigie/prisma-client-py: Prisma Client Python is an auto-generated and fully type-safe database client
- Type safe database access for Python – Prisma Client Python
- Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service
- I Built a Craft Beer Search Engine for Free
- I Built a Craft Beer Search Engine for Free
- Type safe ORM for Python – Prisma Client
Index
What are some of the best open-source Postgresql projects in Python? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Redash | 19,987 |
| 2 | pgcli | 9,927 |
| 3 | full-stack-fastapi-postgresql | 7,391 |
| 4 | dev-setup | 5,566 |
| 5 | asyncpg | 5,183 |
| 6 | patroni | 4,386 |
| 7 | wal-e | 3,308 |
| 8 | PonyORM | 2,742 |
| 9 | tortoise-orm | 2,518 |
| 10 | migra | 2,072 |
| 11 | mara-pipelines | 1,829 |
| 12 | Gopherus | 1,674 |
| 13 | Barman | 1,201 |
| 14 | pghoard | 1,070 |
| 15 | spilo | 905 |
| 16 | piccolo | 593 |
| 17 | FeedHQ | 529 |
| 18 | aerich | 420 |
| 19 | django-migration-linter | 324 |
| 20 | postgrest-docs | 245 |
| 21 | queries | 236 |
| 22 | choochoo | 201 |
| 23 | usaspending-api | 191 |
Are you hiring? Post a new remote job listing for free.
