News for hackers. Stuff that matters.
Re:PostgresJs: The Fastest full featured PostgreSQL client f... by esafak on Saturday October 14, 2023 @04:23PM (#37883945)
prisma appears to have a transaction problem. https://github.com/prisma/prisma/discussions/12715
Re:PostgresJs: The Fastest full featured PostgreSQL client f... by misnome on Saturday October 14, 2023 @04:54PM (#37884192)
Wow, a project describing itself as a “Next generation ORM” that… doesn’t do joins, with no way to optimise queries.

Perhaps they mean “Next generation” as in, the 1987 TV series sense. Which would still be a long time after the concept of joins…

Re:PostgresJs: The Fastest full featured PostgreSQL client f... by djbusby on Saturday October 14, 2023 @06:01PM (#37884661)
To boldly go where the problem was solved ages ago
Re:PostgresJs: The Fastest full featured PostgreSQL client f... by pstuart on Saturday October 14, 2023 @09:10PM (#37885859)
There's One Weird Trick™ in managing joins in this case -- create views that implement the joins and then just treat it as yet another table. Bonus feature is creating a consistent way of working with that relation using native DB tools. ;-)
Re:PostgresJs: The Fastest full featured PostgreSQL client f... by cultofmetatron on Saturday October 21, 2023 @01:07PM (#37968594)
that works great till your database gets big. Then you will watch your memory use skyrocket to perform joins into that view and it will F@#$@# your shit up. eventually it will take so much time to construct your view table that you'll tiemout your connection pool.

to be clear, dont' use views in production queries. you WILL regret it.

source: made this mistake.

Re:PostgresJs: The Fastest full featured PostgreSQL client f... by meekaaku on Saturday October 14, 2023 @06:25PM (#37884806)
Really wow. Such a basic feature should be available in beta version