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.
Snapshotting a DigitalOcean Droplet while it's running

Snapshotting a DigitalOcean Droplet while it's running

8
Comments 1
6 min read
Your RAG Agent Is Quoting Deleted Documents (Postgres + pgvector Fix)

Your RAG Agent Is Quoting Deleted Documents (Postgres + pgvector Fix)

Comments
5 min read
Prisma 8 Upgrade: What Breaks and How to Migrate

Prisma 8 Upgrade: What Breaks and How to Migrate

Comments
7 min read
Our AI assistant can write to exactly one table. Postgres enforces it, not our code

Our AI assistant can write to exactly one table. Postgres enforces it, not our code

4
Comments 3
4 min read
Building a CPQ Engine for B2B: Rules, Pricing, Approvals

Building a CPQ Engine for B2B: Rules, Pricing, Approvals

Comments
6 min read
supa_audit is archived. Here's a maintained audit log for Supabase.

supa_audit is archived. Here's a maintained audit log for Supabase.

Comments
3 min read
Navicat Premium 18 on Linux: a hands-on review with Postgres, SQLite, Oracle and MySQL

Navicat Premium 18 on Linux: a hands-on review with Postgres, SQLite, Oracle and MySQL

Comments
27 min read
Finding and Killing N+1 Queries in a Rails API Before Your Users Notice

Finding and Killing N+1 Queries in a Rails API Before Your Users Notice

Comments
4 min read
Preventing Overselling in Inventory Systems with PostgreSQL Transactions and Idempotency

Preventing Overselling in Inventory Systems with PostgreSQL Transactions and Idempotency

Comments
9 min read
PostgreSQL

PostgreSQL

Comments
5 min read
Extension Tables, Expo Configs, and Static MCP Scanners in supabase-rls-check 0.6.3

Extension Tables, Expo Configs, and Static MCP Scanners in supabase-rls-check 0.6.3

Comments
5 min read
Three-Way Invoice Matching: Automating AP in Custom ERP

Three-Way Invoice Matching: Automating AP in Custom ERP

Comments
7 min read
Moving a desktop app from PostgreSQL to SQLite without losing a cent

Moving a desktop app from PostgreSQL to SQLite without losing a cent

Comments
5 min read
Designing multi-tenant Supabase Row Level Security for an AI PRD generator

Designing multi-tenant Supabase Row Level Security for an AI PRD generator

Comments 1
3 min read
Postgres to Redshift: A CDC Walkthrough That Ends in One External Schema

Postgres to Redshift: A CDC Walkthrough That Ends in One External Schema

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