Constraints in Go

Re:Constraints in Go by rad_gruchalski on Sunday November 17, 2024 @07:47AM (#42163929)

Not the person you’re replying to. The orm sucks because as soon as you go out of the beaten path of your average select/insert/update/delete, you are inevitably going to end up writing raw sql strings. Two cases in point: postgres cte and jsonb queries, there are no facilities in gorm for those, you will be just shoving raw sql into gorm. You might as well stop pretending. There’s a difference between having something writing the sql and mapping results into structs. The latter one can be done with the stdlib sql package and doesn’t require an „orm”.

There are two things an sql lib must do to be very useful: prepared statements and mapping results. That’s enough.

[ Parent | on HN ]

Re:Constraints in Go by bobnamob on Sunday November 17, 2024 @08:00AM (#42163980)

You haven’t answered my question at all.

The parent comment made two claims: ORM not great (I agree) and “boilerplate reduction bad” which still needs some elaboration

[ Parent | on HN ]

Re:Constraints in Go by rad_gruchalski on Sunday November 17, 2024 @09:44AM (#42164432)

I answered it, you just don’t see it. One ends up with the boilerplate anyway as soon as one attempts to step out of the usual crud path. There’s no gain, there’s no difference in templating an sql string vs fighting an orm api.

[ Parent | on HN ]

Re:Constraints in Go by metaltyphoon on Sunday November 17, 2024 @08:06AM (#42164006)

Perhaps you have to yet use a good ORM? I could probably count on my fingers the times I had to drop to raw SQL in EFCore. Even when you do that you can still have mapped results, which reduces boilerplate.

[ Parent | on HN ]

Re:Constraints in Go by rad_gruchalski on Sunday November 17, 2024 @09:51AM (#42164459)

I’m doing this job for 25 years and I haven’t seen a good orm. Sorry. Look, linq is nice. But linq is not enough of a productivity gain to switch the whole stack from go to .net. I used linq 15 years ago extensively and it feel like magic. But then again, how would you model jsonb select for a variable set of of properties and include nested or and and conditions using its notation? Maybe you could but how much longer is it going to take you rather than templating a string?

[ Parent | on HN ]

Re:Constraints in Go by marcus_holmes on Sunday November 17, 2024 @11:29PM (#42169720)

I've been doing this job for over 30 years and I agree.

Entity Framework was the thing that made me spit the dummy with C#, uninstall Windows, install Linux and discover Go in the first place.

Knowing how to write good SQL is a superpower as a developer, and every time I've worked with an ORM fan I get this reinforced. "The database is too slow!" No, your SQL just sucks.

[ Parent | on HN ]

Re:Constraints in Go by rob74 on Monday November 18, 2024 @04:04AM (#42170875)

Maybe people who have only ever used ORMs are happy with them, because they don't know how much more flexible and faster "raw" SQL queries can be?

[ Parent | on HN ]

Re:Constraints in Go by LinXitoW on Sunday November 17, 2024 @04:47PM (#42167612)

Any ORM worth it's salt has an escape hatch that allows you to do all those fancy raw SQL queries.

But the amount of queries that aren't fancy, and that an ORM is perfectly capable of abstracting away is (imho) 90% of all queries run.

Why make 90% or queries more tedious and error prone, just to make 10% slightly easier?

[ Parent | on HN ]

Re:Constraints in Go by rad_gruchalski on Monday November 18, 2024 @04:07AM (#42170888)

I don’t even comprehend your argument. Look: https://gorm.io/docs/, it’s full of strings everywhere. That’s as error prone as anything else and it puts an additional layer of abstraction between you and your sql.

[ Parent | on HN ]

Re:Constraints in Go by jd3 on Thursday November 21, 2024 @09:10PM (#42210541)

https://github.com/stephenafamo/bob supports both CTEs and JSONB in the psql (postgres) dialect

https://bob.stephenafamo.com/docs/query-builder/psql/example...

https://github.com/stephenafamo/bob/blob/main/gen/bobgen-psq...

[ Parent | on HN ]