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.
Hono on Prisma Postgres and Compute, What Worked and What Broke

AI-generated code uncovers a nasty connection bug

Hono on Prisma Postgres and Compute, What Worked and What Broke

33
Comments 12
11 min read
dbdiagram.io vs dbdiagramr vs DrawSQL: Honest Comparison

dbdiagram.io vs dbdiagramr vs DrawSQL: Honest Comparison

Comments
3 min read
Counting visitors without cookies or storing IP addresses

Counting visitors without cookies or storing IP addresses

Comments
7 min read
Idempotent Webhooks in Node.js and Postgres: No Double Processing

Idempotent Webhooks in Node.js and Postgres: No Double Processing

Comments 1
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
One text column holds YouTube IDs, Instagram handles and place IDs, and the absence of a colon is the type tag

One text column holds YouTube IDs, Instagram handles and place IDs, and the absence of a colon is the type tag

1
Comments 1
5 min read
What a NocoBase upgrade actually changes

What a NocoBase upgrade actually changes

1
Comments
7 min read
When AI Reviewers Find More Bugs Than Teams Can Fix

When AI Reviewers Find More Bugs Than Teams Can Fix

Comments
4 min read
When AI Reviewers Find More Bugs Than Maintainers Can Fix

When AI Reviewers Find More Bugs Than Maintainers Can Fix

Comments
4 min read
The migration I would do differently next time

The migration I would do differently next time

1
Comments 2
1 min read
What SKIP LOCKED Solves, and What It Leaves to You

What SKIP LOCKED Solves, and What It Leaves to You

10
Comments 4
8 min read
Two requests, one rule, two rows: fixing the INSERT ... WHERE NOT EXISTS race in PostgreSQL

Two requests, one rule, two rows: fixing the INSERT ... WHERE NOT EXISTS race in PostgreSQL

1
Comments 2
6 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
Wait, How Did Hackers Steal the Encryption Key Too?" 5 Supabase Security Traps I Fixed in Production

Wait, How Did Hackers Steal the Encryption Key Too?" 5 Supabase Security Traps I Fixed in Production

1
Comments 5
8 min read
Keeping Revisions in Commit Order on Postgres

Keeping Revisions in Commit Order on Postgres

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