ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #postgresql
Partitioning large tables in PostgreSQL lets you split data into manageable pieces, prune queries, and simplify maintenance. This guide walks through the declarative syntax, shows a practical configuration, and highlights limits and mistakes to avoid.
Build a fault‑tolerant microservice database on DigitalOcean Managed PostgreSQL. This guide covers the smallest viable architecture, private networking, daily backups, automatic failover, and operational checks to keep the service online.
Learn how to use PostgreSQL partial indexes to reduce storage and write overhead by indexing only a specific subset of rows using a WHERE predicate.
Stop relying on application-level filtering to protect data. Learn how to use Supabase Row Level Security (RLS) to move authorization into the database and prevent leaks.
Learn how to diagnose and resolve 'Timeout acquiring a connection' errors in Knex.js by identifying connection leaks and optimizing pool configurations.
When a Droplet can’t connect to a Managed PostgreSQL database, the issue is often a firewall rule, missing trusted source, SSL mismatch, or network hiccup. This guide walks through a step‑by‑step diagnostic flow and offers concrete fixes.
Stop using 'skip' for large datasets in Prisma. Learn why offset pagination slows down your app and how to implement constant-time cursor-based pagination for scalable feeds.
Move beyond static passwords by using Vault's database secrets engine to generate unique, short-lived credentials that expire automatically.
Learn how to secure your Supabase tables with Row‑Level Security: enable RLS, create per‑user policies, test with the JS client, and verify policies in PostgreSQL. A step‑by‑step guide with code snippets and recovery tips.
digitalocean
supabase
knexjs
mysql
prisma
vault