What PostgreSQL has over other open source SQL databases: Part II

Re:What PostgreSQL has over other open source SQL databases:... by chrisutz on Saturday October 24, 2015 @10:25PM (#10445706)

Having worked with MySQL for years, my mind was blown using Postgres for the first time this year (mainly due to HStore, CTEs, and transactional DDL statements). However, one constant pain point for me was the lack of an upsert. Glad to read Postgres will be getting it in 9.5!

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by spacemanmatt on Sunday October 25, 2015 @05:26AM (#10446445)

I wrote an upsert generator a long time ago. It was one of the easier things to work around.

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by jeltz on Sunday October 25, 2015 @06:02AM (#10446499)

I have seen quite many broken home-rolled UPSERT implementations, so it is apparently not that easy to get it right. Still not very hard though once you have understood the potential problems involved.

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by chrisutz on Sunday October 25, 2015 @12:22PM (#10447284)

Alot of the difficulty was explaining to others that there wasn't an easy way to upsert, and trying to ensure everyone did it the proper way.

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by spacemanmatt on Sunday October 25, 2015 @03:41PM (#10448078)

In OSS communities it's a serious problem. At work, it was routine: this is yet another thing that can be more easily screwed up if you don't use a library solution we've provided you.

[ Parent | on HN ]