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.
From GraphQL types to a PostgreSQL API with Simfinity.js

From GraphQL types to a PostgreSQL API with Simfinity.js

2
Comments
3 min read
pglite vs Tinbase: different tools for different jobs

pglite vs Tinbase: different tools for different jobs

Comments
4 min read
Hybrid Search in Postgres with pgvector: Field Notes on HNSW, tsvector, and Why Pure Vector Search Missed Exact Matches

Hybrid Search in Postgres with pgvector: Field Notes on HNSW, tsvector, and Why Pure Vector Search Missed Exact Matches

1
Comments
7 min read
I built a free database client with a modern UI for Postgres, MySQL, MariaDB and SQLite

I built a free database client with a modern UI for Postgres, MySQL, MariaDB and SQLite

1
Comments
2 min read
When Did This Transaction Happen? PostgreSQL Snapshots, LSNs, Oracle SCNs, and More

When Did This Transaction Happen? PostgreSQL Snapshots, LSNs, Oracle SCNs, and More

1
Comments
33 min read
PostgreSQL 19's data checksums can now be switched on without stopping the server

Benchmark shows minimal write throughput impact

PostgreSQL 19's data checksums can now be switched on without stopping the server

14
Comments 2
7 min read
PostgreSQL Graph Queries with MATCH: 3 Practical Traversal Patterns

PostgreSQL Graph Queries with MATCH: 3 Practical Traversal Patterns

Comments
2 min read
I Built a Supermarket Database in PostgreSQL - Here's What INNER JOIN vs LEFT JOIN Actually Taught Me

I Built a Supermarket Database in PostgreSQL - Here's What INNER JOIN vs LEFT JOIN Actually Taught Me

1
Comments
3 min read
Why a 40-Year-Old Database Is Still Winning in the AI Era

Why a 40-Year-Old Database Is Still Winning in the AI Era

Comments
4 min read
Picodata: a distributed database that speaks PostgreSQL, Redis and Cassandra protocols

Picodata: a distributed database that speaks PostgreSQL, Redis and Cassandra protocols

Comments
3 min read
Your AI Agent Forgot Why It Did That. PacketForge Is the Fix.

Your AI Agent Forgot Why It Did That. PacketForge Is the Fix.

Comments
5 min read
The Supabase RLS mistake that lets any user join any organization

The Supabase RLS mistake that lets any user join any organization

1
Comments
6 min read
NOT IN can be executed as an Anti-Join (NOT EXISTS) in PG19

NOT IN can be executed as an Anti-Join (NOT EXISTS) in PG19

Comments 1
7 min read
The timestamp that broke a fresh evidence chain

The timestamp that broke a fresh evidence chain

Comments
6 min read
How a missing DEFAULT column locked my production DB for 20 minutes (and why your CI won't catch it)

How a missing DEFAULT column locked my production DB for 20 minutes (and why your CI won't catch it)

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