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.
pg_vectorsearch Claims 6 ms at 100M Vectors. Filtered Queries Can Come Back Short

pg_vectorsearch Claims 6 ms at 100M Vectors. Filtered Queries Can Come Back Short

Comments 1
7 min read
How to Self-Host n8n with Docker Compose on Ubuntu 24.04

How to Self-Host n8n with Docker Compose on Ubuntu 24.04

1
Comments
12 min read
Every table in our database is inserted with the word "placeholder" in a NOT NULL column, because the QR code contains the row's own id

Every table in our database is inserted with the word "placeholder" in a NOT NULL column, because the QR code contains the row's own id

Comments
6 min read
Five things restore-testing Supabase dumps turned up

Five things restore-testing Supabase dumps turned up

2
Comments 1
5 min read
Two phones at the same table pressed Join in the same moment, and the loser was told the quiz did not exist

Two phones at the same table pressed Join in the same moment, and the loser was told the quiz did not exist

Comments
6 min read
Postgres 2026: Fresh-Data Search for a Financial Research Dashboard

Postgres 2026: Fresh-Data Search for a Financial Research Dashboard

Comments
6 min read
Idempotency keys done right: exactly-once effects over at-least-once networks

Idempotency keys done right: exactly-once effects over at-least-once networks

Comments
13 min read
Subquery vs CTE in SQL: When and How to Use Each

Subquery vs CTE in SQL: When and How to Use Each

Comments
3 min read
Primary Key vs Foreign Key in SQL: How Tables Connect

Primary Key vs Foreign Key in SQL: How Tables Connect

Comments
3 min read
Building a bulk import pipeline for fixed-asset accounting in Spring Boot

Building a bulk import pipeline for fixed-asset accounting in Spring Boot

Comments
4 min read
Twelve tables, 21 foreign keys, and not one ON DELETE CASCADE, so "delete my history" is four statements in a fixed order

Twelve tables, 21 foreign keys, and not one ON DELETE CASCADE, so "delete my history" is four statements in a fixed order

Comments 1
5 min read
Why I like Neon

Why I like Neon

10
Comments 1
2 min read
Supabase Error 42501 "permission denied for table" — The October 30 Fix (Copy-Paste SQL)

Supabase Error 42501 "permission denied for table" — The October 30 Fix (Copy-Paste SQL)

Comments
3 min read
Our free plan hides creators with a window function, and the locked count is the same predicate with a "not" in front

Our free plan hides creators with a window function, and the locked count is the same predicate with a "not" in front

Comments 1
5 min read
Upgrading Pgpool-II for the September 2026 CVEs: a practical order of work

Upgrading Pgpool-II for the September 2026 CVEs: a practical order of work

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