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.
Graph RAG on the database you already run: meet Drivine

Graph RAG on the database you already run: meet Drivine

1
Comments
3 min read
Foreign Key Cascade Deletes: Un-Indexed FKs, Slow Cascades, and Lock Contention in PostgreSQL

Foreign Key Cascade Deletes: Un-Indexed FKs, Slow Cascades, and Lock Contention in PostgreSQL

1
Comments
6 min read
MySQL to PostgreSQL Schema Conversion: What Each Column Type Should Become, and What Silently Changes

MySQL to PostgreSQL Schema Conversion: What Each Column Type Should Become, and What Silently Changes

1
Comments
12 min read
Postgres NOTIFY Is a Doorbell, Not a Queue: Build a Worker That Survives kill -9

Postgres NOTIFY Is a Doorbell, Not a Queue: Build a Worker That Survives kill -9

3
Comments 3
9 min read
A tamper-evident audit log in PostgreSQL with hash chains and HMAC

A tamper-evident audit log in PostgreSQL with hash chains and HMAC

1
Comments 1
6 min read
A Free-Trial Rule Written Wrong in the Software: What to Check Before It Costs You Customers

A Free-Trial Rule Written Wrong in the Software: What to Check Before It Costs You Customers

1
Comments 1
6 min read
I Let My AI Agent Create Its Own Databases. Here's How the Passwords Stay Locked Up.

I Let My AI Agent Create Its Own Databases. Here's How the Passwords Stay Locked Up.

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

Counting visitors without cookies or storing IP addresses

Comments
7 min read
I Added an Index and Postgres Still Does a Seq Scan (Here's Why)

I Added an Index and Postgres Still Does a Seq Scan (Here's Why)

3
Comments 2
5 min read
Your primary contact is just first in the alphabet

Your primary contact is just first in the alphabet

Comments
7 min read
Building a Production RAG API in Go with pgvector and Gemini

Building a Production RAG API in Go with pgvector and Gemini

Comments
6 min read
Seven things I check before running Postgres on a server I own

Seven things I check before running Postgres on a server I own

Comments
3 min read
Catch risky SQL migrations in pull requests before they lock production

Catch risky SQL migrations in pull requests before they lock production

1
Comments
2 min read
CRM'de özel alan (custom field) tasarlamak: EAV mı JSONB mi, alan tanım kayıt defteri, doğrulama ve indeksleme

CRM'de özel alan (custom field) tasarlamak: EAV mı JSONB mi, alan tanım kayıt defteri, doğrulama ve indeksleme

Comments
10 min read
Use INSERT WITH CHECK and UPDATE USING to allow owner-on-create but block owner transfers

Use INSERT WITH CHECK and UPDATE USING to allow owner-on-create but block owner transfers

Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.