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.
Cleaning Messy Phone Numbers in PostgreSQL Using REGEXP_REPLACE

Cleaning Messy Phone Numbers in PostgreSQL Using REGEXP_REPLACE

Comments
6 min read
Every AI database answer needs a source trail

Every AI database answer needs a source trail

Comments
1 min read
How I Eliminated Race Conditions in a High-Concurrency Ticketing API

How I Eliminated Race Conditions in a High-Concurrency Ticketing API

1
Comments
3 min read
Approaches to tenancy in Postgres

Approaches to tenancy in Postgres

1
Comments 1
12 min read
Auth multi-tenant que prova, nĂŁo promete: como o GarraIA fecha 110 cenĂĄrios de RBAC + 81 de RLS antes do beta da Fase 3

Auth multi-tenant que prova, nĂŁo promete: como o GarraIA fecha 110 cenĂĄrios de RBAC + 81 de RLS antes do beta da Fase 3

1
Comments
6 min read
GroundedQL: a semantic compiler for natural-language Postgres analytics

GroundedQL: a semantic compiler for natural-language Postgres analytics

Comments
2 min read
What it took to put six cities' affordable housing data on one map

What it took to put six cities' affordable housing data on one map

Comments
6 min read
CONNECTING POWER BI TO SQL

CONNECTING POWER BI TO SQL

1
Comments
5 min read
Stop Running psql Commands by Hand — Build a REST API for PostgreSQL User Management

Stop Running psql Commands by Hand — Build a REST API for PostgreSQL User Management

1
Comments 3
5 min read
I extracted a government's entire budget from a 625-page PDF in 4 seconds

I extracted a government's entire budget from a 625-page PDF in 4 seconds

1
Comments
3 min read
Diffing two EXPLAIN plans as trees, not text

Diffing two EXPLAIN plans as trees, not text

Comments
4 min read
Pourquoi ton audit DB trouve toujours plus que ton inventaire ne disait

Pourquoi ton audit DB trouve toujours plus que ton inventaire ne disait

Comments
3 min read
Stop Paying for Algolia: Master PostgreSQL Full-Text Search 🐘

Stop Paying for Algolia: Master PostgreSQL Full-Text Search 🐘

Comments 1
3 min read
SQLAlchemy Event Listeners for Automatic Tenant Data Isolation: Enforcing Multi-Tenancy at the ORM Layer Without Manual Filtering

SQLAlchemy Event Listeners for Automatic Tenant Data Isolation: Enforcing Multi-Tenancy at the ORM Layer Without Manual Filtering

Comments
4 min read
PostgreSQL Window Functions for Multi-Tenant Feature Adoption Analytics: Ranking Users Without Application-Layer Sorting

PostgreSQL Window Functions for Multi-Tenant Feature Adoption Analytics: Ranking Users Without Application-Layer Sorting

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