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.
The 8 tables behind a real auth system (Postgres schema, explained column by column)

The 8 tables behind a real auth system (Postgres schema, explained column by column)

3
Comments
10 min read
# Building a Streaming Session Analytics Pipeline with Kafka, Postgres, and dbt

# Building a Streaming Session Analytics Pipeline with Kafka, Postgres, and dbt

Comments
6 min read
The Compliance Problem That Disappears When You Stop Updating Rows

The Compliance Problem That Disappears When You Stop Updating Rows

Comments
6 min read
Idempotency explained — Part 1: basics, idempotency key and Go implementation

Idempotency explained — Part 1: basics, idempotency key and Go implementation

Comments
8 min read
PostgreSQL JSONB Indexing: GIN, Expression & Partial Index Strategies

PostgreSQL JSONB Indexing: GIN, Expression & Partial Index Strategies

Comments
4 min read
PostgreSQL Backup and Recovery: A Complete Guide

PostgreSQL Backup and Recovery: A Complete Guide

Comments
5 min read
TimescaleDB Continuous Aggregates: What I Got Wrong (and How to Fix It)

TimescaleDB Continuous Aggregates: What I Got Wrong (and How to Fix It)

Comments
5 min read
Stop Losing Data: How to Fix Race Conditions in Laravel 🛑

Stop Losing Data: How to Fix Race Conditions in Laravel 🛑

Comments
2 min read
A Long Story about how I dug into the PostgreSQL source code to write my own WAL receiver, and what came out of it

A Long Story about how I dug into the PostgreSQL source code to write my own WAL receiver, and what came out of it

Comments
15 min read
Busca fuzzy em 55 milhões de registros: como pg_trgm salvou meu projeto

Busca fuzzy em 55 milhões de registros: como pg_trgm salvou meu projeto

2
Comments
4 min read
PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale

PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale

Comments
3 min read
Add slow-query detection and request budgets to Node without swapping your DB client

Add slow-query detection and request budgets to Node without swapping your DB client

1
Comments
1 min read
PostgreSQL Full Text Search vs Elasticsearch Comparison

PostgreSQL Full Text Search vs Elasticsearch Comparison

Comments
9 min read
I Tested PostgreSQL on 5 Million Rows, Here’s What Actually Makes Queries Fast

I Tested PostgreSQL on 5 Million Rows, Here’s What Actually Makes Queries Fast

Comments
5 min read
PostgreSQL Transaction Isolation Levels Explained

PostgreSQL Transaction Isolation Levels Explained

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