Etiqueta

#postgresql

3 articulos

Transactional Outbox: Saving State Without Losing Events

code

June 15, 2025

Transactional Outbox: Saving State Without Losing Events

Understand the database-and-broker dual-write problem, implement a transactional outbox, and handle delivery retries, duplicate events, ordering, and recovery.

  • #code
  • #architecture
  • #events
  • #postgresql
  • #microservices
The N+1 Query Problem: Finding and Fixing a Slow Search Endpoint

code

April 15, 2025

The N+1 Query Problem: Finding and Fixing a Slow Search Endpoint

Understand the N+1 query problem, detect it in a Java service backed by PostgreSQL, and compare projections, fetch joins, batching, and pagination strategies.

  • #code
  • #java
  • #postgresql
  • #performance
  • #database
Relational vs. NoSQL Databases: Why PostgreSQL Is My Default

code

March 15, 2025

Relational vs. NoSQL Databases: Why PostgreSQL Is My Default

Lessons from using MySQL, PostgreSQL, and MongoDB, including schema evolution, data consistency, and why database-side event logic deserves caution.

  • #code
  • #database
  • #postgresql
  • #mongodb
  • #architecture