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

Tag: postgresql

19
Jul 29 2026

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

Prisma's query log shows you what SQL the ORM generated, not why that SQL is slow. A practical guide to knowing when logging is enough and when you need to go straight into PostgreSQL.

Jul 29 2026 · 8′ · Tutorials · TypeScript · postgresql

8′
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 11 2026

Prisma query logging and PostgreSQL: when the ORM is enough and when you have to go deeper

Prisma Client logs show you what queries the ORM generated. PostgreSQL has its own observability layer. Confusing the two is the source of incomplete diagnostics. Here I separate the two planes and give you a concrete criterion for deciding which one to look at first.

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

8′
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′

Series

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

Clusters

  • Software architecture

Categories

  • Experiments98
  • Tutorials67
  • Opinion42
  • 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.

213 articles published

Series

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

Clusters

  • Software architecture

Categories

  • Experiments98
  • Tutorials67
  • Opinion42
  • 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