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.
Community Docker Images: keeping the operator open without a vendor registry lock-in
vyacheslav_sarzhan_3c1767 profile

Community Docker Images: keeping the operator open without a vendor registry lock-in

#postgres #kubernetes #opensource #devops
Comments
9 min read
Avoid a Never-Ending SQL UPDATE with Chunking
nicolas_vbgh profile

Avoid a Never-Ending SQL UPDATE with Chunking

#postgres #database #systemdesign #python
1
Comments 2
12 min read
Vector Search in Postgres: What pgvector's Indexes Actually Cost You
jatinjainsaraf profile

Vector Search in Postgres: What pgvector's Indexes Actually Cost You

#postgres #database #ai #backend
1
Comments
8 min read
Your Postgres already knows why it's slow — you just have to ask it
kalpesh_parihar profile

Your Postgres already knows why it's slow — you just have to ask it

#postgres #database #performance #sql
Comments
7 min read
Your Supabase notifications table has RLS on. Anyone signed in can still write into someone else's inbox.
vollos profile
Pon

Your Supabase notifications table has RLS on. Anyone signed in can still write into someone else's inbox.

#supabase #postgres #security #webdev
Comments 7
4 min read
Ditch Polymorphism: Scaling Laravel with JSONB
iprajapatiparesh profile

Ditch Polymorphism: Scaling Laravel with JSONB

#laravel #database #postgres #architecture
Comments
2 min read
Should You Migrate Off pgvector? Run This Shadow-Mode Benchmark First
libme profile
Libme

Should You Migrate Off pgvector? Run This Shadow-Mode Benchmark First

#postgres #database #ai #performance
Comments
6 min read
PostgreSQL vs MongoDB vs Cassandra: Multi-Node and How to Choose
priteshsurana profile

PostgreSQL vs MongoDB vs Cassandra: Multi-Node and How to Choose

#database #backend #postgres #cassandra
Comments
17 min read
Eighty Percent Done Is Not a Real Number

Summer Bug Smash: Smash Stories Submission 🐛🛹
pascal_cescato_692b7a8a20 profile

Eighty Percent Done Is Not a Real Number

#devchallenge #bugsmash #postgres #database
27
Comments 21
10 min read
Defeating the Multi-Tenant SaaS Concurrency Trap in PostgreSQL
dollykm49 profile

Defeating the Multi-Tenant SaaS Concurrency Trap in PostgreSQL

#postgres #saas #database #backenddevelopment
1
Comments 3
1 min read
Building a tamper-evident audit log in NestJS with hash chains
elwin_ernst profile

Building a tamper-evident audit log in NestJS with hash chains

#nestjs #security #typescript #postgres
Comments 2
11 min read
Supabase vs Firebase in 2026: The Migration Questions Nobody Answers
libme profile
Libme

Supabase vs Firebase in 2026: The Migration Questions Nobody Answers

#database #postgres #backend #saas
Comments
5 min read
Adding Full-Text Search
moose978 profile

Adding Full-Text Search

#postgres #nestjs #backend #database
Comments 1
8 min read
A failed read must throw, not return 0 — how Next.js ISR bakes your fallback into the cache
thecompoundtech profile

A failed read must throw, not return 0 — how Next.js ISR bakes your fallback into the cache

#nextjs #webdev #postgres #caching
Comments 1
3 min read
Multi-Tenant Content Isolation in Strapi: Scoping Every Query by Tenant Without Duplicating Content-Types
mukesh_13 profile
Mukesh

Multi-Tenant Content Isolation in Strapi: Scoping Every Query by Tenant Without Duplicating Content-Types

#strapi #multitenancy #postgres #rowlevelsecurity
Comments 2
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.