Etiqueta

#database

3 articulos

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
Single Table Design

code

December 27, 2023

Single Table Design

Exploring Java 17's New Features with examples

  • #code
  • #database
  • #aws