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.
Your Company Does Not Need Another AI Chatbot. It Needs a Knowledge Layer.
agave_info_solutions profile

Your Company Does Not Need Another AI Chatbot. It Needs a Knowledge Layer.

#ai #postgres #rag #architecture
Comments
12 min read
My database is the referee: a fair exchange enforced by Supabase RLS
peter_panzer_733381724c86 profile

My database is the referee: a fair exchange enforced by Supabase RLS

#supabase #postgres #security #opensource
Comments 3
6 min read
PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table
tbson87 profile

PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table

#postgres #database #sql #migrations
Comments
9 min read
Your Test Suite Is Slow Because It Tests Postgres
_66d02d0cc1ece7d1137c5f profile

Your Test Suite Is Slow Because It Tests Postgres

#testing #pytest #postgres #sql
Comments
3 min read
PostgreSQL index bloat: why VACUUM never shrinks an index, and how to measure it with avg_leaf_density
bitpage profile

PostgreSQL index bloat: why VACUUM never shrinks an index, and how to measure it with avg_leaf_density

#postgres #pgstattuple #reindex #autovacuum
Comments
15 min read
The Pagination Bug Hiding in a Geo-Search Cache
rakno profile

The Pagination Bug Hiding in a Geo-Search Cache

#postgres #redis #typescript #webdev
1
Comments
4 min read
My analytics said 15 users. The database said 2.
innerlove_ai profile

My analytics said 15 users. The database said 2.

#postgres #supabase #startup #buildinpublic
Comments 1
2 min read
Why Page 500 Is Slow and Shows Duplicate Rows: Offset vs Keyset Pagination
libme profile

Why Page 500 Is Slow and Shows Duplicate Rows: Offset vs Keyset Pagination

#postgres #database #api #performance
1
Comments 1
7 min read
pgvector Without Embeddings: When a Feature Vector Beats Semantic Search
agave_info_solutions profile

pgvector Without Embeddings: When a Feature Vector Beats Semantic Search

#postgres #database #vectordatabase #ai
Comments
6 min read
Permission Filters and pgvector: Why Your Most Restricted Users Get the Fewest Answers
agave_info_solutions profile

Permission Filters and pgvector: Why Your Most Restricted Users Get the Fewest Answers

#postgres #ai #security #database
Comments
7 min read
How to Back Up Self-Hosted Spliit: PostgreSQL Dumps, S3 Receipts and a Docker Restore That Loses Nothing
john_182319291 profile
John

How to Back Up Self-Hosted Spliit: PostgreSQL Dumps, S3 Receipts and a Docker Restore That Loses Nothing

#selfhosted #docker #postgres #privacy
1
Comments
17 min read
What I learned parsing every SEC Form 4 filing for a day
insidertradingradar profile

What I learned parsing every SEC Form 4 filing for a day

#showdev #python #fintech #postgres
Comments
4 min read
Integração com o iFood: o problema na homologação do developer
felipebufelli profile

Integração com o iFood: o problema na homologação do developer

#node #typescript #postgres #api
Comments
8 min read
Building an Evidence-Based Medical Q&A Site with Go — Architecture, Structured Data, and an SEO Playbook
aimall profile

Building an Evidence-Based Medical Q&A Site with Go — Architecture, Structured Data, and an SEO Playbook

#go #seo #postgres #webdev
1
Comments
4 min read
Cron Worker Retry Failure Capture Explained — Durable Background Evidence for SaaS
jerichorhodes5847 profile

Cron Worker Retry Failure Capture Explained — Durable Background Evidence for SaaS

#observability #postgres #backgroundjobs
Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.