Sponsored Content

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.
I put reminders, contacts and recipes in the same Postgres table. Here is the SQL, and what it cost.
xneuronal profile

I put reminders, contacts and recipes in the same Postgres table. Here is the SQL, and what it cost.

#postgres #database #architecture #ai
Comments
5 min read
Using an AST to validate AI-generated PostgreSQL before it runs
nur-zaman profile

Using an AST to validate AI-generated PostgreSQL before it runs

#postgres #ai #security #typescript
Comments
3 min read
The RLS Policy Was Correct. The Write Was Still Wrong.
toddsullivan profile

The RLS Policy Was Correct. The Write Was Still Wrong.

#security #supabase #postgres #devops
Comments
3 min read
MCP vs. a Direct Database Connection: A Security and Workflow Comparison
vivekdraxlr profile

MCP vs. a Direct Database Connection: A Security and Workflow Comparison

#sql #database #ai #postgres
Comments
7 min read
One View Per Layer: Four Sharp Edges I Found in My Own Code
srdjan_poppovic profile

One View Per Layer: Four Sharp Edges I Found in My Own Code

#postgres #gis #django #webdev
Comments
6 min read
A Small Fintech Challenge, and Why I Let Postgres Hold the Money
jeyem profile

A Small Fintech Challenge, and Why I Let Postgres Hold the Money

#postgres #go #fintech #concurrency
Comments
4 min read
Building WafyURL: A High-Performance URL Shortener with Real-Time Analytics & Security
afeemuhammodwafy profile

Building WafyURL: A High-Performance URL Shortener with Real-Time Analytics & Security

#python #flask #webdev #postgres
Comments
2 min read
Moving Oracle to PostgreSQL with a Single `INSERT` — No Oracle Client, No Python
sergey_rudenko_40963c1b7f profile

Moving Oracle to PostgreSQL with a Single `INSERT` — No Oracle Client, No Python

#dataengineering #duckdb #oracledatabase #postgres
Comments
11 min read
Redis Caching in NestJS: I Cut Database Calls by 60% in Production
arihantjain916 profile

Redis Caching in NestJS: I Cut Database Calls by 60% in Production

#nextjs #redis #backend #postgres
Comments
5 min read
Don't pick a partial index for speed: what I measured on a 10M-row Postgres queue table
muhammetsafak profile

Don't pick a partial index for speed: what I measured on a 10M-row Postgres queue table

#postgres #database #performance #backend
Comments
9 min read
A rate limiter changes when it leaves memory
saoudih profile

A rate limiter changes when it leaves memory

#typescript #node #redis #postgres
Comments
4 min read
Postgres Can Do Typo-Tolerant Search. You Don't Need Elasticsearch Yet.
chizee profile

Postgres Can Do Typo-Tolerant Search. You Don't Need Elasticsearch Yet.

#postgres #database #search #tutorial
1
Comments
3 min read
Parte 2: Resolvendo o Desafio TĂ©cnico de Backend do PicPay
_devzin profile

Parte 2: Resolvendo o Desafio TĂ©cnico de Backend do PicPay

#backend #docker #postgres #tutorial
1
Comments
3 min read
PostgreSQL psql: Schema Navigation Quick Reference
amelye_chatila_717552aace profile

PostgreSQL psql: Schema Navigation Quick Reference

#sql #database #postgres #devtips
Comments
1 min read
How We Architected an Enterprise-Grade PostgreSQL Database on Supabase with a 99.99% Cache Hit Ratio
mayank_tiwari_42bbe7d7386 profile

How We Architected an Enterprise-Grade PostgreSQL Database on Supabase with a 99.99% Cache Hit Ratio

#architecture #database #performance #postgres
1
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.