News for hackers. Stuff that matters.
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.
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.
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.
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.