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.
dbdiagram.io vs dbdiagramr vs DrawSQL: Honest Comparison

dbdiagram.io vs dbdiagramr vs DrawSQL: Honest Comparison

Comments
3 min read
Multi-Tenancy in SaaS: The Architecture Decision You Can't Undo Later

Multi-Tenancy in SaaS: The Architecture Decision You Can't Undo Later

Comments
5 min read
Fuzzy search in Postgres with pg_trgm and Supabase (multilingual, typo-tolerant)

Fuzzy search in Postgres with pg_trgm and Supabase (multilingual, typo-tolerant)

Comments
6 min read
Polymorphic Associations in PostgreSQL: One commentable_id Column or a Foreign Key per Table?

Polymorphic Associations in PostgreSQL: One commentable_id Column or a Foreign Key per Table?

Comments
7 min read
What a NocoBase upgrade actually changes

What a NocoBase upgrade actually changes

1
Comments
7 min read
Postgres Logical Replication for Reporting Replicas: The Gotchas Nobody Puts in the Tutorial

Postgres Logical Replication for Reporting Replicas: The Gotchas Nobody Puts in the Tutorial

Comments
5 min read
Postgres Logical Replication for Reporting Replicas: The Gotchas the Tutorials Skip

Postgres Logical Replication for Reporting Replicas: The Gotchas the Tutorials Skip

Comments
5 min read
DocumentDB 0.113: $group covering index

DocumentDB 0.113: $group covering index

Comments
6 min read
Postgres Won't Let Me Double-Book a Parking Slot: Exclusion Constraints in Practice

Postgres Won't Let Me Double-Book a Parking Slot: Exclusion Constraints in Practice

Comments 2
5 min read
Deploy a Complete AI Incident Backend on One Neon Branch

Deploy a Complete AI Incident Backend on One Neon Branch

10
Comments
9 min read
pg_i18n: translatable columns in PostgreSQL without rewriting your app

pg_i18n: translatable columns in PostgreSQL without rewriting your app

Comments
4 min read
Supabase Connection String: IPv6, ENOTFOUND, and the Transaction Pooler Fix

Supabase Connection String: IPv6, ENOTFOUND, and the Transaction Pooler Fix

Comments
3 min read
DocumentDB 0.116: $group distinct scan

DocumentDB 0.116: $group distinct scan

1
Comments
9 min read
58 of 154 public Supabase apps had a working service_role key in git

58 of 154 public Supabase apps had a working service_role key in git

Comments
3 min read
Postgres RLS in Symfony: a setup check for a missing FORCE, and two ways it says "nothing to report" without looking

Postgres RLS in Symfony: a setup check for a missing FORCE, and two ways it says "nothing to report" without looking

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