an ai agent that runs on your desktop and has its own cursor and constantly sabotages your work, writing 'later nerds' at the end of emails right before you hit send, closing windows randomly, signing up for online games and doing all the in-app purchases
🤔 Is Prisma ORM slow?
Prisma ORM has received countless performance improvements over the years
📊 And we've even measured with benchmarks
Here's a short recap of what we've done, where we're at, and where we're going 👇
youtu.be/z_sfTz5S3SU impersonation system not working well
You can read the motivations behind the newsletter here:
community.tuist.dev/t/our-first-... We took a lot of inspiration for this from the only one Dense Discovery newsletter www.densediscovery.com.
We often share ideas that we stumble upon internally, and we thought it’d be useful to curate them in a different format.
Let us know what you think 😀 
Thanks Apple for doing more open source 😀. These contributions wouldn’t be possible otherwise.
Our first issue of “Swift Stories” is out where we talk about Concurrency Oriented Programming Languages (COPL), interview @jdx.dev, the creator of Mise, and share exciting projects and ideas.
Swift Stories is our love letter to the Swift ecosystem to cross-pollinate ideas
tuist.dev/newsletter/i... ❤️ taylor.town/no-mentoring 
Our goal was to make SwiftPM registry resolution faster – but "accidentally", we made clean checkouts 2x faster for _any SwiftPM setup_: github.com/swiftlang/sw...
For example, a clean checkout that would on average take 73 seconds took only 36 seconds with the changes from this branch. It’s time to give @tuist.dev’s documentation a new iteration to:
• Better showcase its value
• Improve the navigation
• Align with the future
• Align with the marketing identity
Rolling out soon 😀 
New @tuist.dev swag just dropped 🔥 
🤔 Joining data from multiple tables is a complicated topic!
💡 In this article, we look at 3 different JOIN strategies and explain their tradeoffs so you can always pick the best for your use case!
❓ What other questions do you have about JOINs?
pris.ly/demystify-j... We're live now with the AMA 🎉
Come ask us any questions you've got about our move from Rust to TypeScript for the Prisma Query Engine 🙌
discord.gg/Y2TkZhCd?ev... 
there was a secondary market for startup equity that used graphql and just dumped their whole data model in there, the names and emails of all sellers and buyers were just there in plaintext on every request to the page
❓ Learn more
This thread was just a high-level summary of our efforts. Check out the benchmarking repo and our blog post for more details on the setup, methodology and results.
www.prisma.io/blog/perfor... ✅ Performance checklist
To help you with your database queries, we've put together a performance checklist to ensure that your Prisma ORM queries are at optimal performance.
If you still see slow queries, don't hesitate to open a new issue on GitHub: github.com/prisma/pris... 
✏️ Conclusion
The hard truth about query performance is that it's possible to write fast as well as slow queries with each ORM library!
In the end, much of an application's performance depends on the developer's ability to follow best practices, identify slow queries, and optimize them over time. 🔎 If you zoom out and look at the results from a distance, you'll notice that most queries actually perform in similar ballparks with only a few milliseconds difference.
As an example, here are the results we've collected on AWS RDS: 
🤔 So, which ORM is the fastest?
As unsatisfying as it may be, the answer is as so often: It depends! Performance is a nuanced topic and depends on lots of factors.
While we can't provide a conclusive answer, analyzed some patterns in the blog post (link at the end). 📊 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 ... 