News for hackers. Stuff that matters.

A comment on Migrating to Postgres. Parent comment

Re:Migrating to Postgres by Tadpole9181 on Wednesday May 14, 2025 @09:03PM (#43990805)
It's pretty obvious when somebody has only heard of Prisma, but never used it.

- Using `JOIN`s (with correlated subqueries and JSON) has been around for a while now via a `relationLoadStrategy` setting.

- Prisma has a Rust service that does query execution & result aggregation, but this is automatically managed behind the scenes. All you do is run `npx prisma generate` and then run your application.

- They are in the process of removing the Rust layer.

The JOIN setting and the removing of the middleware service are going to be defaults soon, they're just in preview.

[ Parent | on HN ]
Re:Migrating to Postgres by compton93 on Wednesday May 14, 2025 @09:07PM (#43990828)
They've been saying that for 3 years. We actually had a discount for being an early adopter. But hey its obvious Ive never used it and only heard of it.
[ Parent | on HN ]
Re:Migrating to Postgres by Tadpole9181 on Wednesday May 14, 2025 @09:20PM (#43990893)
The JOIN mode has been in preview for over a year and is slated for GA release within a few months. Which has been on their roadmap.

The removal of the rust service is available in preview for Postgres as of 6.7.[1]

Rewriting significant parts of a complex codebase used by millions is hard, and pushing it to defaults requires prolonged testing periods when the worst case is "major data corruption".

[1]: https://www.prisma.io/blog/try-the-new-rust-free-version-of-...

[ Parent | on HN ]
Re:Migrating to Postgres by compton93 on Wednesday May 14, 2025 @09:54PM (#43991103)
They've had flags and work arounds for ages. Not sure what point you are trying to make? But like you said I've never used it, only heard of it lol.
[ Parent | on HN ]
Re:Migrating to Postgres by paulddraper on Wednesday May 14, 2025 @09:53PM (#43991089)
It is hard.

Harder than just doing joins.

[ Parent | on HN ]
Re:Migrating to Postgres by williamdclt on Thursday May 15, 2025 @05:19AM (#43993225)
Honestly, everything you say makes me want to stay far from prisma _more_.

All this complexity, additional abstractions and indirections, with all the bugs gootguns and gotchas that come with it... when I could just type "JOIN" instead.

[ Parent | on HN ]
Re:Migrating to Postgres by Tadpole9181 on Thursday May 15, 2025 @01:52PM (#43997514)
Okay? It's one setting that will be the default in 2 months. And you could always write type-safe SQL manually instead.

i greatly envy y'all having projects where the biggest complexity is... A single setting once, that's clearly documented. We live in very different worlds, apparently.

[ Parent | on HN ]