News for hackers. Stuff that matters.

A comment on Uncle Bob and Silver Bullets. Parent comment

Re:Uncle Bob and Silver Bullets by jdmichal on Friday October 06, 2017 @03:24PM (#15419645)
I'm actually a big fan of myBatis [0] for this very reason. You still write all the SQL, including stored procedures. All it does is map objects to input parameters, and map result sets to objects. Which is awesome, because that's the part of database processing that is actually tedious and sucks. Writing SQL is not.

I think StackExchange's Dapper [1] works similarly in the .NET world.

[0] https://github.com/mybatis/mybatis-3

[1] https://github.com/StackExchange/Dapper

[ Parent | on HN ]
Re:Uncle Bob and Silver Bullets by benmmurphy on Friday October 06, 2017 @03:46PM (#15419812)
this is pretty close to the sweet spot for me. being able to map rows to object easily + being able to easily compose queries are what i want from my 'ORM'. if your SQL layer doesn't support chaining conditions you end up writing it anyway so being able to do .and(condition).and(condition).and(condition), etc is pretty useful. ActiveRecord in rails comes close to this but it also manages relationships as well which makes things a bit more complicated but not as complicated as what hibernate or other ORMs do.
[ Parent | on HN ]