PostgreSQL is the worlds’ best database
I use PostgreSQL and MS SQL Server. I love Postgres. There are some things that SQL Server does differently that I would love to see supported in Postgres:<p>* Protocol: (a) no wire level named parameters support; everything must be by index. (b) Binary vs text is is not great, and binary protocol details is mostly &quot;see source&quot; (c) no support for inline cancellation: to cancel a query client can&#x27;t signal on current TCP connection, the client must open or use a different connection to kill an existing query, this is sometimes okay, but if you are behind a load balancer or pooler this can end up being a huge pain.<p>* Multiple Result Sets from a single query without hacks. While you can union together results with similar columns or use cursors, these  are hacks and work only in specific cases. If I have two selects, return two result sets. Please.<p>* Protocol level choosing of language. Yes, you can program in any language, but submitting an arbitrary query in any language is a pain and requires creating an anonymous function, which is a further pain if your ad-hoc query has parameters. I would love a protocol level flag that allows you to specify: &quot;SQL&quot;, &quot;PG&#x2F;plSQL&quot;, &quot;cool-lang-1&quot; and have it execute the start of the text as that.<p>I do love Postgres recently added Procs! Yay!