DEV Community

#postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Directus + Coolify: Should You Decouple Postgres & Redis?
wadethomastt profile

Directus + Coolify: Should You Decouple Postgres & Redis?

#docker #coolify #postgres #redis
Comments
5 min read
Stop adding Redis just for simple job queues: I built catqueue, a PostgreSQL-native job queue for Node & TypeScript
karan_rajsurya_1a4f4647a profile

Stop adding Redis just for simple job queues: I built catqueue, a PostgreSQL-native job queue for Node & TypeScript

#webdev #typescript #postgres #backenddevelopment
1
Comments
1 min read
Find Your Worst Postgres Query in 15 Minutes with pg_stat_statements
mukesh_13 profile
Mukesh

Find Your Worst Postgres Query in 15 Minutes with pg_stat_statements

#postgres #performance #database #sql
Comments
4 min read
Cutting Latency by 30% on a High-Traffic E-Commerce Platform: A Profiling-First Approach
marvinoka4 profile

Cutting Latency by 30% on a High-Traffic E-Commerce Platform: A Profiling-First Approach

#performance #postgres #aws
Comments
3 min read
Automated Student Report Delivery in Rust | Bulk Email PDF Reports
manjushaps profile

Automated Student Report Delivery in Rust | Bulk Email PDF Reports

#rust #postgres #egui #beginners
Comments
1 min read
Why We Test Row-Level Security Against a Real Postgres Database, Not Mocks
marvinoka4 profile

Why We Test Row-Level Security Against a Real Postgres Database, Not Mocks

#postgres #security #testing
5
Comments
4 min read
Vector Search in Postgres: What pgvector's Indexes Actually Cost You
jatinjainsaraf profile

Vector Search in Postgres: What pgvector's Indexes Actually Cost You

#postgres #database #ai #backend
Comments
8 min read
The UPDATE That Never Finishes and What to Run Instead
nicolas_vbgh profile

The UPDATE That Never Finishes and What to Run Instead

#postgres #database #systemdesign #python
1
Comments 2
12 min read
Xero API Integration Guide (2026): OAuth, Tenants, and Your First Query
ilshadyx profile

Xero API Integration Guide (2026): OAuth, Tenants, and Your First Query

#postgres #api #database #xero
Comments
14 min read
Provenance Belongs in the Image Table
romiteld profile

Provenance Belongs in the Image Table

#postgres #databasedesign #generativeai #provenance
Comments
5 min read
Understanding Two-Phase Commit (2PC) by Building One in Go
ankitmalikg profile

Understanding Two-Phase Commit (2PC) by Building One in Go

#go #mysql #postgres #distributedsystems
Comments
11 min read
Multi-Tenant Content Isolation in Strapi: Scoping Every Query by Tenant Without Duplicating Content-Types
mukesh_13 profile
Mukesh

Multi-Tenant Content Isolation in Strapi: Scoping Every Query by Tenant Without Duplicating Content-Types

#strapi #multitenancy #postgres #rowlevelsecurity
Comments
5 min read
Monitoring Airbyte's Postgres CDC Replication Slots Before They Take Down Your Source Database
mukesh_13 profile
Mukesh

Monitoring Airbyte's Postgres CDC Replication Slots Before They Take Down Your Source Database

#airbyte #postgres #cdc #dataengineering
Comments
5 min read
Postgres Advisory Locks for Distributed Cron: Killing Duplicate Job Runs Without a Redis Dependency
mukesh_13 profile
Mukesh

Postgres Advisory Locks for Distributed Cron: Killing Duplicate Job Runs Without a Redis Dependency

#postgres #distributedsystems #backend #devops
Comments
5 min read
Zero-Downtime Postgres Failover on Vultr: A Patroni + HAProxy Runbook for Solo Developers
mukesh_13 profile
Mukesh

Zero-Downtime Postgres Failover on Vultr: A Patroni + HAProxy Runbook for Solo Developers

#postgres #vultr #infrastructure #highavailability
Comments
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.