3️⃣ If the queries don’t depend on each other, don’t use an interactive transaction.
Interactive transactions = more control, but more operations.
Use them only when needed (like if you need a value from a previous query). 
2️⃣ Need to create or connect records in one operation?
Use Prisma ORM-specific nested-relation helpers such as `connectOrCreate` or `set` to create or link related records in a single operation. 
1️⃣ Used batched queries instead of looping DB calls.
💡 Use createMany, updateMany, deleteMany to batch work into a single request.
e.g, For the query below, it'll be 1 operation, not 3 👇 
👀 Are you a Prisma Postgres user?
Here are 3 quick tips to write smarter queries and optimize your operation count 🧵 
Also try out rolldown-vite in your Vite projects and share your feedback!
✋ vite@7.0.0-beta.0 is out!
- Browser Target Changed to Baseline Widely Available
- Node 18 support dropped. Vite is now distributed as ESM only
Plus fixes and deprecated feats removals, preparing for rolldown. Help us test the beta and report back 🙏
github.com/vitejs/vite/... 🤔 Need a robust connection pool for your Neon database?
🚀 Check out our step-by-step guide showing how to add Prisma Accelerate to PostgreSQL on Neon for blazing fast responses in your serverless apps!
pris.ly/guide/neon-cp 
Flying to SF this week to attend / speak at @swyx.io’s ai engineer conference. I’ll be around, DM me! 
🙌
Bicycle habitat, king kog, and ride brooklyn all have pretty good reputations!
Bonus point for recording a little 5min video demo of your most proud work showcasing a focus on details, performance and accessibility. 🙏
Looking for an experienced frontend developer for a very interesting contract project (related to AI and LiveStore). Please get in touch via DM with references. (Ideally minimum of 5 years of experience.) Referrals welcome!
🎓 What does Stale-While-Revalidate (SWR) mean when caching DB results?
When you set SWR, results will be served from the cache for the specified time. Also: for every cache hit, a new DB query is triggered and the cached data is "refreshed" & the SWR timer is reset. 
Didn't get a chance to check out our MCP live demo yesterday?
No worries! We just launched a new series with everything you need to get started, from configuration to workflows.
Watch now -> directus.io/tv/directus... 
We've made it easy to migrate from Postgres.
Our new Postgres → PlanetScale migration guides include scripts for automating the process, helping you quickly unlock the performance and scalability of Metal.
planetscale.com/docs/vitess/... 💡 Why this matters: Prisma ORM v7 will require an `output` path. Getting ahead of it now means fewer surprises later.
Read our recent article about why Prisma writes into `node_modules`, what we learned since then & what changes in the future!
pris.ly/output-article 🐛 Seeing issues with a custom `output` path?
No matter which generator you’re using (`prisma-client` or `prisma-client-js`), please open a GitHub issue — we want to help!
github.com/prisma/pris... 🆕 Starting a new project?
We recommend that you use a custom `output` path from the start (e.g., `src/generated/prisma`).
This avoids future issues and prepares you for upcoming Prisma ORM v7 changes. 🔧 Using `prisma-client-js` in an existing project?
If you recently added a custom `output` path and ran into errors — just revert.
If everything works with Prisma Client in `node_modules`, no need to change anything yet! 🧵 When should you use a custom `output` path with Prisma ORM?
Here’s your TL;DR on what you should do today based on your setup 👇 
‼️ Having a connection pooler in front of your database when accessing it from serverless functions is essential to survive traffic spikes!
Don't believe us? Check out the video where we load tested a database with and without a connection pool!
www.youtube.com/watch?v=cnL... This would be a really great question to explore on a @localfirst.fm episode together if you’re interested? 🤘 one of those 370