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.
PostgreSQL Query Optimization: Reducing API Response Time from 2.8 Seconds to 74 Milliseconds

PostgreSQL Query Optimization: Reducing API Response Time from 2.8 Seconds to 74 Milliseconds

Comments
3 min read
Database Indexes: What's Actually Happening Under the Hood

Database Indexes: What's Actually Happening Under the Hood

Comments
6 min read
Supabase Backups Don't Include Your Storage Files. Here's What Does.

Supabase Backups Don't Include Your Storage Files. Here's What Does.

Comments 1
4 min read
The Supabase RLS gotcha nobody warns you about: infinite recursion in multi-tenant policies

The Supabase RLS gotcha nobody warns you about: infinite recursion in multi-tenant policies

Comments
2 min read
Kysely: Type-Safe SQL Query Builder for Node.js (2026)

Kysely: Type-Safe SQL Query Builder for Node.js (2026)

Comments
7 min read
The Great Simplification: Why Your Database is Your Best Cache

The Great Simplification: Why Your Database is Your Best Cache

5
Comments
2 min read
Hetzner was cheaper at every size I tested and I still chose managed Postgres

Hetzner was cheaper at every size I tested and I still chose managed Postgres

Comments
7 min read
ACID em Bancos de Dados: O Que É e Por Que Deveria Importar Para Você

ACID em Bancos de Dados: O Que É e Por Que Deveria Importar Para Você

Comments
4 min read
PostgreSQL Best Practices for Backend Developers

PostgreSQL Best Practices for Backend Developers

Comments
2 min read
Postgres RLS, silent truncation, and cron on a platform without cron

Postgres RLS, silent truncation, and cron on a platform without cron

Comments
7 min read
Python PostgreSQL with asyncpg: Async Database Operations

Python PostgreSQL with asyncpg: Async Database Operations

Comments
3 min read
Designing a Three Reviewer Consensus Platform for Digital Harm Reporting

Designing a Three Reviewer Consensus Platform for Digital Harm Reporting

Comments
1 min read
Postgres: force drop a database that is being accessed by other users

Postgres: force drop a database that is being accessed by other users

Comments
4 min read
The Easiest Way to Snapshot Tableau's PostgreSQL Repository Over Time

The Easiest Way to Snapshot Tableau's PostgreSQL Repository Over Time

Comments
2 min read
It Worked on Every Environment Except Prod: Getting Daily Reports Right Across Timezones

It Worked on Every Environment Except Prod: Getting Daily Reports Right Across Timezones

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