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.
40001 is not a query error
mohamedaboelmagd profile

40001 is not a query error

#postgres #node #typescript #database
Comments
8 min read
Supabase Auth Schema Explained: Users, Identities, Sessions
not_varunkv profile

Supabase Auth Schema Explained: Users, Identities, Sessions

#supabase #postgres #database #tutorial
Comments
4 min read
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
Why Your OAuth Integration Randomly Returns invalid_grant (and How to Stop Two Workers From Racing)
libme profile

Why Your OAuth Integration Randomly Returns invalid_grant (and How to Stop Two Workers From Racing)

#api #backend #security #postgres
Comments
7 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.