📊 Publishing results
Check out the results here: benchmarks.prisma.io/
The main table displays the median values of the 500 iterations. For each query, you can see the actual code snippet and a histogram with the distribution. 
⏳ Collecting data
We collected data by executing the benchmark scripts 500 times against various databases.
We intentionally made the repo open-source — feel free to give it a spin yourself and share your results with us! 
🏗️ Infrastructure
We executed the queries from an EC2 instance and ran them against different Postgres instances of various providers. 
🔨 Setup
We have created 14 equivalent queries for Prisma ORM, TypeORM and Drizzle ORM.
Query latency has been measured using this function.
You can find all queries in this repo: github.com/prisma/orm-... 
📊 Last summer, we wanted to know how Prisma ORM compares to other ORMs in performance and created open-source benchmarks!
So, which ORM is the fastest? The (maybe unsatisfying) answer: It depends!
Read on to learn about our methodology and results ... 
confession: I hedge my bets by making sure I stay friendly with Claude, just in case he wakes up. Call it AI-simping. I call it the Pascal AI-wager.
‼️ We're holding an AMA session in Discord today to answer your questions about our move from Rust to TypeScript in the Prisma Query Engine!
Come join us and ask us what you want to know 🤝
11:00 EST / 17:00 CET
discord.gg/Y2TkZhCd?ev... 
perfect editorial art on this post from @phiffer.org phiffer.org/after-big-so... 
I've built my own type-safe SQL query builder for @livestore.dev mostly to support bidirectional schemas (to encode/decode data e.g. date objects, binary data <> ImageBitmap, ...). Can you share more about how you're using them?
Super excited to announce that local-first conf is back for a 2 day conference in Berlin! Based on all the great feedback for last year, we've decided to extend the conference to 2 full days of talks covering the latest technologies and ideas in local-first. See you there!
Increasingly impressed how Cursor/AI isn't just making me more productive but helps resolve non-trivial bugs with ease. Yesterday, I was facing a gnarly memory corruption bug in a SQLite WASM build. Cursor with GPT4o one-shotted the solution.
Can I make my TS notebook part of my `tsc` build setup so my TS build fails if there are some TS related issues in the notebook? Example: If I refactor `Something` to `SomethingElse` in `lib.ts` which is used in `architecture.ipynb`, and I still use `Something` in the notebook, will `tsc` fail?
I should give Deno notebooks a try. Is anyone using this?
deno.com/blog/v1.37 What's the closest equivalent for Jupyter notebooks for TypeScript developers? Use case: I'd like some kind of markdown files where I can import/reference TypeScript definitions e.g. to document/plan my application architecture. This should also serve as context for AIs.
Yesterday, we joined the local CocoaHeads meetup in Berlin and it was great to see Ostap from SumUp evangelizing project generations tools, including @tuist.dev – it's always special to see others being excited by a tool that you have put a lot of thought and energy into 💜 
😀😀😀
And for a sneak peek of what's available next week, Zed Preview v0.170 is out too:
- Better autocomplete suggestions in keymaps
- Better C formatting by default
- LSP Logs: Now with `tail -f` style autoscroll
- And so much more!
Full changelog and download:
https://zed.dev/releases/preview?b=27 Also in Zed 0.168:
- Linux menus keyboard navigation (left/right/up/down)
- Improved support for Coder.com Cloud Developer Environments with SSH remoting
- Restored macOS Big Sur compatability (Sorry!)
- and more!
Full Changelog and Download Zed Stable here:
https://zed.dev/releases/stable?b=27 Zed 0.169 ❤️ Keyboard Users: - Show Project Panel (`cmd-shift-e` / `ctrl-shift-e`) works in more contexts - vim: Add 'g J' JoinLines / JoinLinesNoWhitespace - vim: Add `aq`/`iq` "any quote" text objects And improved emacs compatibility:
AI Assistant Improvements in Zed 0.169
Improved model support:
- @msftresearch.bsky.social 's new Phi4 via Ollama
- Google Gemini 2.0 Flash experimental
- Anthropic Claude 3.5 Haiku
- Beta headers for custom Anthropic models
https://bsky.app/profile/zed.dev/post/3lfku6iu6kl2o 🚅 Zed v0.169 is out! Every week the Zednesday release train comes into the station with all sorts of goodies. Today's releases bring expanded AI Model Support, improved navigation and keybindings, language server enhancements, improved LSP debuggability and numerous bug fixes.
If it's consoling for you, my day has mostly involved nested pointers in the SQLite C/WASM binding and starring at binary buffers. Also: Cursor helped me to write a lot of C code which was really fun actually.
All done! Thanks everyone. We'll do some more swag drops in the near future 🧢