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.
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
Supabase vs Firebase in 2026: The Migration Questions Nobody Answers
libme profile

Supabase vs Firebase in 2026: The Migration Questions Nobody Answers

#database #postgres #backend #saas
Comments
5 min read
A failed read must throw, not return 0 — how Next.js ISR bakes your fallback into the cache
kynth profile
Kynth

A failed read must throw, not return 0 — how Next.js ISR bakes your fallback into the cache

#nextjs #webdev #postgres #caching
Comments
3 min read
Your Supabase notifications table has RLS on. Anyone signed in can still write into someone else's inbox.
vollos profile
Pon

Your Supabase notifications table has RLS on. Anyone signed in can still write into someone else's inbox.

#supabase #postgres #security #webdev
Comments
3 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
Building a tamper-evident audit log in NestJS with hash chains
elwin_ernst profile

Building a tamper-evident audit log in NestJS with hash chains

#nestjs #security #typescript #postgres
Comments 2
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
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
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
Credit Billing Without Transactions: 4 Race Conditions I Hit on Serverless Postgres
xiaojun_mao_c154743594bc9 profile

Credit Billing Without Transactions: 4 Race Conditions I Hit on Serverless Postgres

#postgres #webdev #saas #database
Comments 2
6 min read
Building a Secure Employee Management System Using Ballerina, PostgreSQL, Docker, and React
shenali_chath_a97b8d9 profile

Building a Secure Employee Management System Using Ballerina, PostgreSQL, Docker, and React

#ballerina #backend #docker #postgres
Comments
4 min read
PostgreSQL ve Redis Neden Birlikte Kullanılır?
feyzadandal profile

PostgreSQL ve Redis Neden Birlikte Kullanılır?

#backend #database #postgres #redis
Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.