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.
You aren't a DBA. You're a paramedic for a closed-source replication engine

You aren't a DBA. You're a paramedic for a closed-source replication engine

Comments
3 min read
Building a Production-Ready Event Store in PostgreSQL: Schema Design, Projections, and Replay

Building a Production-Ready Event Store in PostgreSQL: Schema Design, Projections, and Replay

1
Comments
20 min read
Building a Production-Ready Event Store with PostgreSQL: Lessons from Running It at Scale

Building a Production-Ready Event Store with PostgreSQL: Lessons from Running It at Scale

Comments
17 min read
Building Production-Ready APIs with .NET: From Minimal APIs to Clean Architecture

Building Production-Ready APIs with .NET: From Minimal APIs to Clean Architecture

Comments
19 min read
ClickUp to Custom Kanban: Migration Strategies

ClickUp to Custom Kanban: Migration Strategies

Comments
13 min read
Equipment Categorization and Canonical Name Mapping Strategies

Equipment Categorization and Canonical Name Mapping Strategies

Comments
8 min read
Building an Exercise Database: Multi-Source Data Normalization

Building an Exercise Database: Multi-Source Data Normalization

Comments
10 min read
Exercise Selection Algorithms with Equipment Constraints

Exercise Selection Algorithms with Equipment Constraints

Comments
12 min read
Building Fitness Program Adaptation Algorithms

Building Fitness Program Adaptation Algorithms

Comments
10 min read
Hexagonal Architecture: Escaping the Framework Trap with Ports and Adapters

Hexagonal Architecture: Escaping the Framework Trap with Ports and Adapters

Comments
18 min read
Implementing Hexagonal Architecture in Microservices: A Practical Guide to Ports and Adapters

Implementing Hexagonal Architecture in Microservices: A Practical Guide to Ports and Adapters

Comments
19 min read
Muscle Activation Data Modeling for Fitness Applications

Muscle Activation Data Modeling for Fitness Applications

Comments
9 min read
PostgreSQL vs Redis: Building a Hybrid Architecture for Real-Time Applications

PostgreSQL vs Redis: Building a Hybrid Architecture for Real-Time Applications

Comments
20 min read
Database Schema Design: Prisma vs Drizzle ORM Comparison

Database Schema Design: Prisma vs Drizzle ORM Comparison

Comments
8 min read
Migrating from Redis to PostgreSQL: Session Management Patterns

Migrating from Redis to PostgreSQL: Session Management Patterns

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