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.
One Read Core, and the Code That Proves It

One Read Core, and the Code That Proves It

Comments
16 min read
Building a Choose-Your-Own-Adventure API with NestJS — Part 2: Persistence

Building a Choose-Your-Own-Adventure API with NestJS — Part 2: Persistence

Comments
4 min read
Read your SQL back as one sentence before you run it

Read your SQL back as one sentence before you run it

Comments
6 min read
information_schema vs pg_catalog: Which Should You Query?

information_schema vs pg_catalog: Which Should You Query?

Comments
3 min read
What is a Neki router?

What is a Neki router?

Comments
5 min read
Every new replica took twenty more database connections

Every new replica took twenty more database connections

Comments
2 min read
Collecting knowledge fails because of people. So we built an AI colleague.

Collecting knowledge fails because of people. So we built an AI colleague.

1
Comments
8 min read
What a Large-Vehicle Router Cannot Know

What a Large-Vehicle Router Cannot Know

Comments
3 min read
I built a fake 30-year company for a more realistic Postgres sample database

I built a fake 30-year company for a more realistic Postgres sample database

Comments
3 min read
Q&D: PostgreSQL 18 on OpenBSD

Q&D: PostgreSQL 18 on OpenBSD

Comments
3 min read
One CAST made a view 13x slower in PostgreSQL. So I benchmarked MySQL 8.4 against PostgreSQL 17

One CAST made a view 13x slower in PostgreSQL. So I benchmarked MySQL 8.4 against PostgreSQL 17

Comments 1
6 min read
Designing a Privacy-First Architecture for Sensitive Data: Zero-IP Logging, Postgres RLS, and AI Safety

Designing a Privacy-First Architecture for Sensitive Data: Zero-IP Logging, Postgres RLS, and AI Safety

Comments
2 min read
How I Cleaned Messy HR Dataset Using PostgreSQL: A Step-by-Step Guide

How I Cleaned Messy HR Dataset Using PostgreSQL: A Step-by-Step Guide

Comments
9 min read
High-Throughput Database Optimization: Compound Indexing, Caching Patterns, and Query Tuning

High-Throughput Database Optimization: Compound Indexing, Caching Patterns, and Query Tuning

1
Comments
9 min read
We attacked our own AI-agent governance 69 times. Here are the 5 times it gave way.

We attacked our own AI-agent governance 69 times. Here are the 5 times it gave way.

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