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.
Typed ORM with automatic migrations: Fitz vs SQLAlchemy + Alembic + Pydantic
martin_palopoli profile

Typed ORM with automatic migrations: Fitz vs SQLAlchemy + Alembic + Pydantic

#webdev #postgres #python #opensource
Comments
9 min read
PostgreSQL Performance Tuning for High-Traffic React Applications
uaslimcreate profile

PostgreSQL Performance Tuning for High-Traffic React Applications

#database #performance #postgres
Comments
4 min read
Building a world-history map: PostGIS time+bbox search, a full-screen MapLibre UI, and Wikidata ETL lessons
annalium profile

Building a world-history map: PostGIS time+bbox search, a full-screen MapLibre UI, and Wikidata ETL lessons

#showdev #postgres #webdev #datascience
Comments
8 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
I just published Postgres MCP Server in Go!
akshay_gupta profile

I just published Postgres MCP Server in Go!

#postgres #mcp #go #ai
Comments
2 min read
You Probably Don't Need Kafka: A Durable Outbox and Job Queue in Plain Postgres
poojang profile
Poojan

You Probably Don't Need Kafka: A Durable Outbox and Job Queue in Plain Postgres

#architecture #database #postgres #systemdesign
Comments
8 min read
Your Database MCP Is Lying to You
rasikraj01 profile

Your Database MCP Is Lying to You

#postgres #ai #mcp #database
2
Comments 3
6 min read
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
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
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
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
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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.