News for hackers. Stuff that matters.
Re:Why Use Postgres? by stesch on Sunday April 30, 2017 @02:30PM (#14233081)
Some people don't want to use SQL. Or learn it. Or read documentation.

The anti ORM movement convinced only a few interested database users.

Re:Why Use Postgres? by lima on Sunday April 30, 2017 @02:41PM (#14233145)
Many ORMs like ActiveRecord, the Django one and SQLAlchemy support it just fine, so it's probably just a matter of reading the docs :)
Re:Why Use Postgres? by lilbobbytables on Sunday April 30, 2017 @09:45PM (#14234983)
I find the Django docs a bit more digestible then PG docs, personally.

It's because of the Django docs that I've learned about a few of those awesome fields types. https://docs.djangoproject.com/en/1.11/ref/contrib/postgres/...

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.
Re:Why Use Postgres? by flukus on Monday May 01, 2017 @12:34AM (#14235592)
> The anti ORM movement convinced only a few interested database users.

IMO this was because they were too dogmatic and ignored the things ORM's did better, focusing on performance that didn't matter or on issues that come up even when you don't use an ORM (n+1 in the architecture).

That said, I don't think anyone that hasn't learned SQL really don't understand their ORM either. It's one of the fundamentals that any developer should know before they ever write production code.

Re:Why Use Postgres? by manigandham on Monday May 01, 2017 @06:27AM (#14236585)
ORMs are tool. Arguments for and against them are tired and irrelevant. Use the tool if and where it helps.
Re:Why Use Postgres? by ubernostrum on Sunday April 30, 2017 @08:20PM (#14234698)
A rather important library we use at work is built on Potsgres range types. And we interact with it through an ORM (a co-worker of mine will be presenting how it works, and the open-source release of it, at PyCon this year).