News for hackers. Stuff that matters.

A comment on Why Use Postgres. Parent comment

Re:Why Use Postgres by gouranga on Tuesday May 01, 2012 @04:39AM (#3913487)
In fact they tend to optimise per engine.

If you look at NHibernate for example, if you do paging on SQL 2005+ it will use CTE yet on MySQL it will use LIMIT clauses underneath.

Some enterprise products have a really crappy schema with an ORM thrown over the top - that's where the pain is.

[ Parent | on HN ]
Re:Why Use Postgres by josephcooney on Tuesday May 01, 2012 @08:49PM (#3917097)
Your definition of 'enterprise' might be different to mine. I'm thinking of SAP and PeopleSoft. And I think the crappy schema arises (sometimes) from not wanting to use any proprietary DDL features.
[ Parent | on HN ]