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.
ClickUp to Custom Kanban: Migration Strategies

ClickUp to Custom Kanban: Migration Strategies

Comments
13 min read
Muscle Activation Data Modeling for Fitness Applications

Muscle Activation Data Modeling for Fitness Applications

Comments
9 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
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
Equipment Categorization and Canonical Name Mapping Strategies

Equipment Categorization and Canonical Name Mapping Strategies

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

Database Schema Design: Prisma vs Drizzle ORM Comparison

Comments
8 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
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
How diffChangelog and Snapshots Work Together

How diffChangelog and Snapshots Work Together

5
Comments
4 min read
Connecting PostgreSQL on a Linux (WSL) Server to DBeaver

Connecting PostgreSQL on a Linux (WSL) Server to DBeaver

2
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 Directory Platform with Node.js & PostgreSQL (Lessons from a Niche Gaming Project)

Building a Directory Platform with Node.js & PostgreSQL (Lessons from a Niche Gaming Project)

Comments
2 min read
What’s missing, what’s coming, and what’s worth the wait: FOSDEM PGDay Recap

What’s missing, what’s coming, and what’s worth the wait: FOSDEM PGDay Recap

Comments
3 min read
PostgreSQL slow queries — 7 ways to find and fix performance bottlenecks

PostgreSQL slow queries — 7 ways to find and fix performance bottlenecks

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