PWV Portfolio Feed

Copy over the `DATABASE_URL` and `PULSE_API_KEY` to the .env file in your Next.js project.

🧵 Let's build a quick realtime inbox with @nextjs and Prisma Postgres

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

impersonation system not working well

Thanks Apple for doing more open source 😀. These contributions wouldn’t be possible otherwise.

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

✏️ 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).

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