Juanchi.dev
Digital Native · real systems
·
HomeCasesCVBlogLabContact
Skip to content
Juanchi.dev
Digital Native · real systems
·
HomeCasesCVBlogLabContact

Tag: postgresql

18
Aug 04 2026

The Complete Guide to Docker HEALTHCHECK: Dockerfile vs Compose vs Orchestrator

Why a HEALTHCHECK copied from a tutorial usually lies more than having none at all, and how to decide between Dockerfile, Compose, and the orchestrator based on what you actually need to monitor.

Aug 04 2026 · 9′ · Tutorials · docker · devops

9′
Jul 13 2026

Barman vs pgBackRest: a decision tree for PostgreSQL backup in production

There's no universal winner. Barman wins on simplicity and real-time WAL streaming with low operational overhead. pgBackRest wins on volume and restore speed. The criteria matter more than the tool.

Jul 13 2026 · 9′ · Tutorials · devops · produccion

9′
Jun 03 2026

Prisma 5 → Prisma 6: The Breaking Changes I Hit in My Real Schema and How I Fixed Them Without Breaking Production

Prisma 6 improves ergonomics and performance, but there are three behavior changes that won't scream at you in the compiler — and will absolutely show up at runtime if you don't audit your relational queries first. Practical guide with checklist.

Jun 03 2026 · 8′ · Tutorials · TypeScript · backend

8′
May 28 2026

The benchmark that made me change my mind about Jakarta EE in 2026

Same backend, same database, same k6. In the first runs it looked like Embedded GlassFish was on top. When I fixed JDK, warmup, window, heap, and DB attribution, the story changed: Spring Boot ended up with the best local profile for this workload. Payara Micro was the cleanest Jakarta EE by check failures. GlassFish surprised by being viable.

May 28 2026 · 10′ · Experiments · Performance · backend

10′
May 25 2026

Prisma Query Logging and PostgreSQL: Where the ORM Ends and the Database Begins

Prisma query logs help you catch patterns, but if the problem lives inside PostgreSQL, the ORM won't show it to you. Here I break down when Prisma logging is enough and when you need to instrument the database directly.

May 25 2026 · 7′ · Tutorials · TypeScript · backend

7′
May 18 2026

Prisma Server Actions in Next.js 16: the patterns that work and the N+1 that sneaks up on you

Prisma in Next.js 16 Server Actions has an N+1 vector that doesn't exist in classic API routes. The culprit isn't the ORM — it's how Actions compose. Here are the patterns that prevent it.

May 18 2026 · 7′ · Experiments · TypeScript · Performance

7′
May 16 2026

Prisma vs JDBC: the benchmark that almost made me blame the wrong ORM

I built a reproducible lab to compare Prisma 5 against Spring Boot JdbcTemplate on the same PostgreSQL 16. What I found wasn't a winner: it was that query shape and N+1 explain almost everything, and blaming the ORM is too easy.

May 16 2026 · 5′ · Experiments · TypeScript · Performance

5′
May 15 2026

HikariCP: the p95 that lies to you and how to read the real pool signals

A low p95 with a 97% error rate isn't a fast pool — it's a pool that fails fast. I built a reproducible experiment with Spring Boot 3, PostgreSQL, and k6 to understand which signals actually matter — and which ones deceive you.

May 15 2026 · 13′ · Experiments · Performance · backend

13′
May 09 2026

Spring Boot in Real Production: Defaults the Official Docs Do Not Emphasize

Spring Boot works very well in production, but its defaults do not always fit PaaS constraints, tight memory, and real observability. These are the points worth reviewing before trusting the initial setup.

May 09 2026 · 10′ · Experiments · Performance · backend

10′

Series

  • Open Data and Creativity2
  • Awesome Curated: The Tools11
  • Awesome Curated1
See all

Clusters

  • Software architecture
  • TypeScript in production
  • Security and operations
  • Agents and LLMs with judgment

Categories

  • Experiments99
  • Tutorials93
  • Opinion44
  • Reflections18
  • Technology8
  • History6

Tags

  • #TypeScript
  • #arquitectura
  • #nextjs
  • #railway
  • #java
  • #LLM
  • #postgresql
  • #ia
  • #prisma
  • #software-architecture
  • #firma-digital
  • #AI

Popular

  1. 01pnpm vs npm vs yarn vs bun: The Real Comparison Nobody Gives You in 2025
  2. 02Next.js App Router: The Guide I Wish I Had When I Migrated from Pages Router
  3. 03TypeScript: The Patterns I Actually Use Every Single Day
  4. 04Docker for Node.js Developers: From Zero to Production Without Losing Your Mind
  5. 05Your Digital Signing Cryptography Has an Expiration Date: What NIST Published and How to Migrate Your HSM

Newsletter

One email a week. What I'm learning, building, and breaking.

All
Experiments
Tutorials
Opinion
Reflections
Technology
History

Juanchi.dev is Juan Torchia’s public notebook — architecture, real systems and product decisions. Written and reviewed by hand in Buenos Aires. Built with Next.js, Prisma and PostgreSQL; deployed on Railway. No third-party trackers beyond aggregate analytics.

GitHubRSS© 2026 Juan Torchia · All rights reserved.

Real code. Unfiltered takes.

Architecture, real systems, product decisions and technical lessons. Everything reviewed with my own judgment before it ships.

230 articles published

Series

  • Open Data and Creativity2
  • Awesome Curated: The Tools11
  • Awesome Curated1
See all

Clusters

  • Software architecture
  • TypeScript in production
  • Security and operations
  • Agents and LLMs with judgment

Categories

  • Experiments99
  • Tutorials93
  • Opinion44
  • Reflections18
  • Technology8
  • History6

Tags

  • #TypeScript
  • #arquitectura
  • #nextjs
  • #railway
  • #java
  • #LLM
  • #postgresql
  • #ia
  • #prisma
  • #software-architecture
  • #firma-digital
  • #AI

Popular

  1. 01pnpm vs npm vs yarn vs bun: The Real Comparison Nobody Gives You in 2025
  2. 02Next.js App Router: The Guide I Wish I Had When I Migrated from Pages Router
  3. 03TypeScript: The Patterns I Actually Use Every Single Day
  4. 04Docker for Node.js Developers: From Zero to Production Without Losing Your Mind
  5. 05Your Digital Signing Cryptography Has an Expiration Date: What NIST Published and How to Migrate Your HSM

Newsletter

One email a week. What I'm learning, building, and breaking.

Blog
Uses
Now