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.
SQLAlchemy Mapper Configuration for Tenant-Scoped Relationships: Preventing Accidental Cross-Tenant Data Access in ORM Lazy-Loaded Relations

SQLAlchemy Mapper Configuration for Tenant-Scoped Relationships: Preventing Accidental Cross-Tenant Data Access in ORM Lazy-Loaded Relations

1
Comments
4 min read
O bug de 16 minutos: quando 'dado faltando' Ă© uma corrida contra o relĂłgio

O bug de 16 minutos: quando 'dado faltando' Ă© uma corrida contra o relĂłgio

Comments
3 min read
Building My First Real Database: What a Weekend SQL Assignment Taught Me About Postgres (and Git)

Building My First Real Database: What a Weekend SQL Assignment Taught Me About Postgres (and Git)

2
Comments
3 min read
Designing a Multi-Tenant Video Aggregator Schema in PostgreSQL

Designing a Multi-Tenant Video Aggregator Schema in PostgreSQL

Comments
10 min read
PostgreSQL JSON Columns: Flexible Schema Design for Modern Applications

PostgreSQL JSON Columns: Flexible Schema Design for Modern Applications

Comments 1
4 min read
Alternative to load test: Model using the Universal Scalability Law

Alternative to load test: Model using the Universal Scalability Law

2
Comments
6 min read
The Code Is Fine, but Requests Queue Until They Time Out: Puma, Pools, CDN

The Code Is Fine, but Requests Queue Until They Time Out: Puma, Pools, CDN

Comments
4 min read
Your Team Doesn’t Need a Better AI Model This Week

Your Team Doesn’t Need a Better AI Model This Week

Comments
4 min read
Why I Kept Search Scope Inside a Single Supabase RPC

Why I Kept Search Scope Inside a Single Supabase RPC

Comments 2
8 min read
Deploying a Multi-Module Spring Boot App to Render with PostgreSQL, Redis, Docker, and Flyway

Deploying a Multi-Module Spring Boot App to Render with PostgreSQL, Redis, Docker, and Flyway

2
Comments
7 min read
User Roles & Permissions for Business

User Roles & Permissions for Business

Comments
3 min read
Preventing Double-Spend in Spring Boot 3 Using Pessimistic SERIALIZABLE Locking

Preventing Double-Spend in Spring Boot 3 Using Pessimistic SERIALIZABLE Locking

1
Comments
5 min read
PostgreSQL 19 vs. 18: What Actually Changed, Feature by Feature

PostgreSQL 19 vs. 18: What Actually Changed, Feature by Feature

Comments
12 min read
Testing Data Persistence, Service Name Resolution, and stdout Logging in a Flask and PostgreSQL Multi-Container Environment

Testing Data Persistence, Service Name Resolution, and stdout Logging in a Flask and PostgreSQL Multi-Container Environment

2
Comments 2
7 min read
CREATE OR REPLACE didn't replace: one optional parameter, and my API 400'd in production

CREATE OR REPLACE didn't replace: one optional parameter, and my API 400'd in production

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