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.
9 PostgreSQL Queries Every Data Analyst Should Know (Try Them in Your Browser)
priyajha1294 profile

9 PostgreSQL Queries Every Data Analyst Should Know (Try Them in Your Browser)

#sql #postgres #beginners #analytics
Comments 1
3 min read
PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices
tbson87 profile

PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices

#postgres #database #sql #webdev
Comments 1
9 min read
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
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
How We Handle 10,000+ Product Queries with Django + PostgreSQL Without Breaking a Sweat
mobin_mollapor_8c0cf73a27 profile

How We Handle 10,000+ Product Queries with Django + PostgreSQL Without Breaking a Sweat

#backend #django #performance #postgres
1
Comments
1 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
We asked an agent to tune 1 slow query on 3 Postgres MCP servers. It had notes.
dreyler0 profile

We asked an agent to tune 1 slow query on 3 Postgres MCP servers. It had notes.

#postgres #ai #mcp #database
1
Comments
7 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 a One-Line Column Rename Takes Down Production (and the Expand/Contract Fix)
gaurang_learn profile

How a One-Line Column Rename Takes Down Production (and the Expand/Contract Fix)

#devops #database #postgres #backend
1
Comments 1
2 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
Airtable as a Backup Datastore for Orders Nobody Can Afford to Lose
iurii_rogulia profile

Airtable as a Backup Datastore for Orders Nobody Can Afford to Lose

#typescript #node #postgres #stripe
1
Comments
7 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.