News for hackers. Stuff that matters.
Re:Why Use Postgres? by jdc0589 on Sunday April 30, 2017 @03:33PM (#14233399)
Letting go of ORMs is so easy with good lightweight model binding libraries. e.g. Dapper (https://github.com/StackExchange/Dapper)
Re:Why Use Postgres? by sbov on Sunday April 30, 2017 @11:38PM (#14235432)
We use something like Dapper at where I work. I think for some projects it's fine, but for some a full ORM can really pay dividends. Especially if you're still working out your problem domain, all the hand crafted SQL can be a pain to update if you find you need to add just 1 more field, or if you figure out you need to split a table up because of a new unforseen feature, etc.
Re:Why Use Postgres? by flukus on Monday May 01, 2017 @12:37AM (#14235596)
Dapper is great for reads but it doesn't handle complex updates nearly as well, although I'd argue most of those are architectural/design issues in nature.
Re:Why Use Postgres? by cryptarch on Sunday April 30, 2017 @05:42PM (#14234005)
How do model binding libraries compare to ORM's w.r.t. performance, e.g. query optimization?
Re:Why Use Postgres? by Nuzzerino on Sunday April 30, 2017 @08:01PM (#14234632)
ORMs are doing more work and are naturally going to have more overhead. With Dapper , at least with the way I used it, you're going to write your own SQL queries so there is nothing to optimize. I've even run into some nasty SQL server parameter sniffing issues. But despite that I still prefer the style over ORMs.
Re:Why Use Postgres? by bluejekyll on Sunday April 30, 2017 @09:34PM (#14234944)
MyBatis is great for Java as well.