tag:blogger.com,1999:blog-2356137376934964551.post4287510484437801680..comments2023-06-14T06:01:24.499-04:00Comments on Andrew Dunstan's PostgreSQL and Technical blog: PostgreSQL 9.4 and beyondAndrew Dunstanhttp://www.blogger.com/profile/04684286585449188201noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-2356137376934964551.post-72630420817715907092014-12-20T11:54:57.525-05:002014-12-20T11:54:57.525-05:00SQL Assertions might be nice, but they aren't ...SQL Assertions might be nice, but they aren't something I really want to work on, TBH.Andrew Dunstanhttps://www.blogger.com/profile/04684286585449188201noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-86241034413963867082014-12-20T05:47:53.554-05:002014-12-20T05:47:53.554-05:00>SQL Assertions have been discussed in the past...>SQL Assertions have been discussed in the past.<br />I imagine that the main counterargument is performance. But first, lest acknowledge that there are different kinds of systems with different requirements. Not all have billions of rows, thousands of parallel users and tens of distributed computers.<br /><br />There are prototype relational (not SQL) systems, created by only single developer that have implemented assertion-like general constraints. Therefore I assume it is technically possible to achieve. It seems to be (sadly) that it just has not been the focus of the DBMS-development community. <br /><br />In my opinion it would be a great productivity boost if instead of writing A4 page-long procedural code, one could achieve the same result by writing only couple of lines. Exclusion constraints are a good example in this regard. Not all systems require/want this but there are many systems that would benefit a lot.Anonymoushttps://www.blogger.com/profile/10722028211822850497noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-38376653073321115292014-12-19T20:22:23.670-05:002014-12-19T20:22:23.670-05:00Thanks for all your work; we rely heavily on the J...Thanks for all your work; we rely heavily on the JSON functionality in Postgres, and I can't wait to start using jsonb. Trevor Morganhttps://www.blogger.com/profile/02583257795864285412noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-36932873755517695982014-12-19T19:05:46.538-05:002014-12-19T19:05:46.538-05:00SQL Assertions have been discussed in the past. I&...SQL Assertions have been discussed in the past. I'm not sure how possible they are.Andrew Dunstanhttps://www.blogger.com/profile/04684286585449188201noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-7835144046624419772014-12-19T17:59:52.555-05:002014-12-19T17:59:52.555-05:00>I'm now looking for new PostgreSQL project...>I'm now looking for new PostgreSQL projects<br /><br />What about implementing the support of SQL ASSERTION's in PostgreSQL. It would really raise PostgreSQL above the other SQL DBMS's.Anonymoushttps://www.blogger.com/profile/10722028211822850497noreply@blogger.com