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 Silent Truncator: Debugging Django's Vague `DataError`

The Silent Truncator: Debugging Django's Vague `DataError`

Comments
2 min read
Email Management System - Development Guide

Email Management System - Development Guide

Comments
5 min read
How to Change a Column Datatype Without Affecting Existing Users Postgresql

How to Change a Column Datatype Without Affecting Existing Users Postgresql

Comments
3 min read
Stop hand-writing INSERTs: JSON SQL with dialect-aware output(Postgres/MySQL/SQLite)

Stop hand-writing INSERTs: JSON SQL with dialect-aware output(Postgres/MySQL/SQLite)

Comments
4 min read
Building Git-like Version Control for a Headless CMS (Next.js + Supabase)

Building Git-like Version Control for a Headless CMS (Next.js + Supabase)

Comments
1 min read
CloudNativePG (CNPG) - install (2.18) and first test: simulate transient failure

CloudNativePG (CNPG) - install (2.18) and first test: simulate transient failure

1
Comments
10 min read
Serverless PostgreSQL 2025: The Truth About Supabase, Neon, and PlanetScale

Serverless PostgreSQL 2025: The Truth About Supabase, Neon, and PlanetScale

Comments
12 min read
Saga Engine Go: Type-Safe Distributed Transactions with Zero Infrastructure

Saga Engine Go: Type-Safe Distributed Transactions with Zero Infrastructure

Comments
4 min read
Solving Latency and Pagination in Image and Keyword Based Property Search

Solving Latency and Pagination in Image and Keyword Based Property Search

2
Comments
3 min read
File handling in PostgreSQL: barriers and ways around them

File handling in PostgreSQL: barriers and ways around them

Comments
8 min read
Making Redis Optional: Why I’m pivoting to a 'Postgres-First' Architecture and why chose Valkey as alternative

Making Redis Optional: Why I’m pivoting to a 'Postgres-First' Architecture and why chose Valkey as alternative

19
Comments 4
5 min read
Why PostgreSQL RLS Is Hard in Spring Boot and How I Simplified It

Why PostgreSQL RLS Is Hard in Spring Boot and How I Simplified It

3
Comments
2 min read
SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird

SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird

31
Comments
3 min read
Upgrading PostgreSQL 13 to 17 on AWS RDS with Minimal Downtime

Upgrading PostgreSQL 13 to 17 on AWS RDS with Minimal Downtime

7
Comments 1
7 min read
ScholarBridge

ScholarBridge

1
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.