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 ... 
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!