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

Tag: prisma

7
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′
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 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 09 2026

Functional Programming in TypeScript: What Survives Outside Pretty Examples

Functors, monads, and pipe() can look pristine in small examples, but real Next.js flows with Server Actions and Prisma expose readability, bundle, and onboarding costs worth measuring before adopting the full pattern.

May 09 2026 · 8′ · Experiments · TypeScript · produccion

8′

Series

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

Clusters

  • Software architecture

Categories

  • Experiments98
  • Tutorials69
  • 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.

Series

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

Clusters

  • Software architecture

Categories

  • Experiments98
  • Tutorials69
  • 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.

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.

215 articles published

Blog
Uses
Now