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.
Django REST API with PostgreSQL — Advanced Queries & Optimization

Django REST API with PostgreSQL — Advanced Queries & Optimization

Comments
5 min read
How to Set Up Automated Database Backups on Linux (PostgreSQL and MySQL)

How to Set Up Automated Database Backups on Linux (PostgreSQL and MySQL)

Comments
2 min read
I Gave Claude Code Access to My Prod Database with MCP

I Gave Claude Code Access to My Prod Database with MCP

Comments 1
3 min read
I Replaced 3 Database Tools With dbridge.dev — Here's the Honest Trade-off

I Replaced 3 Database Tools With dbridge.dev — Here's the Honest Trade-off

Comments
3 min read
Best Stripe Sigma Alternative for PostgreSQL Users

Best Stripe Sigma Alternative for PostgreSQL Users

Comments
10 min read
Building a PostgreSQL Observability Stack with Docker, Grafana, and Prometheus

Building a PostgreSQL Observability Stack with Docker, Grafana, and Prometheus

1
Comments
3 min read
Database Migration Strategies for Zero-Downtime

Database Migration Strategies for Zero-Downtime

Comments
9 min read
How We Made Our Supabase RLS Migrations Idempotent (And Why You Should Too)

How We Made Our Supabase RLS Migrations Idempotent (And Why You Should Too)

Comments
3 min read
Building a Safe Money Transfer System in PostgreSQL — Transactions, Rollbacks, and What Happens When Things Break

Building a Safe Money Transfer System in PostgreSQL — Transactions, Rollbacks, and What Happens When Things Break

Comments
3 min read
Your Database Is Fine. Stop Migrating.

Your Database Is Fine. Stop Migrating.

Comments
3 min read
Auto Estimate PostgreSQL Table and Index Size from EF Core Models

Auto Estimate PostgreSQL Table and Index Size from EF Core Models

Comments
4 min read
How to manage PostgreSQL roles and permissions — a practical guide

How to manage PostgreSQL roles and permissions — a practical guide

Comments
8 min read
Node.js Database Migrations in Production: Zero-Downtime Strategies That Actually Work

Node.js Database Migrations in Production: Zero-Downtime Strategies That Actually Work

Comments
7 min read
How to Use pgvector with Python: A Complete Guide

How to Use pgvector with Python: A Complete Guide

Comments
7 min read
Modifying Tables Safely in PostgreSQL — ALTER TABLE, Constraints, and Defaults

Modifying Tables Safely in PostgreSQL — ALTER TABLE, Constraints, and Defaults

Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.