ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #postgresql
Shows how to set up declarative partitioning for time‑series data, define trust boundaries, run operational checks, and recognize when the design must evolve.
Advisory locks let you coordinate application logic without tables. Learn how to use pg_advisory_lock, transaction vs session scopes, and common patterns like leader election and migration guards.
Learn how Quarkus Dev Services automatically provisions a PostgreSQL container for dev and test, how to enable it, verify it works, and avoid common pitfalls.
Architecture note for DigitalOcean Managed PostgreSQL high availability: primary-standby design, trust boundaries, monitoring checks, failure modes, and redesign triggers.
Quarkus Dev Services starts PostgreSQL automatically for local development, but it requires Docker. Learn to configure it and disable it when containers are unavailable.
Learn how to configure a PostgreSQL data source in IntelliJ IDEA, run queries, edit data directly, and understand the trade‑offs of driver management and performance.
Design Weblate around component boundaries, Celery worker health, and Git-to-database verification to prevent translation drift.
Keep DataGrip’s page‑size limit enabled to avoid loading millions of rows into memory, and tune the JDBC fetch size per driver for smooth paging.
Split web and background work on Scalingo using a Procfile, Redis queue, and PostgreSQL add-on, with independent scaling and trust boundaries.
java
quarkus
digitalocean
docker
jetbrains
git
weblate
datagrip
mysql
scalingo