To get the best performance and proper lock ordering for concurrent updates I usually need to resort to using a variety of MSSQL only SQL extensions. (Lock hints, isolation levels, specific join methods, etc)<p>Is there a list of exactly what coverage this has? Does it support pinning execution plans?<p>Here’s an example of the crap I had to resort to in my last big project: <a href="https://github.com/realartists/shiphub-server/blob/master/RealArtists.ShipHub.Database/Procedures/BulkUpdateIssues.sql" rel="nofollow">https://github.com/realartists/shiphub-server/blob/master/Re...</a>
I am seriously impressed if that actually works. For simply queries, sure, it's tricky, but it makes sense that you can do it. For complex queries, I have no idea how you'd even start to implement something like that.<p>Do they translate Transact SQL to Postgresql syntax, for do that build a new "language parser"-thing and use the internals of Postgresql to store and process the queries?
This sounds great but performance is the obvious question. Is this intended for long term usage? Or is this one of those stop gap solutions you're intended to replace but end up keeping for 5 years?<p>Also interesting to know how they map SQL Server security on top of this.<p>Very cool sounding but at the same time I might dread inheriting a system running on this if I started a new job.
Far more discussion yesterday, on the original AWS announcement:
<a href="https://news.ycombinator.com/item?id=25267204" rel="nofollow">https://news.ycombinator.com/item?id=25267204</a>
It seems quite interesting if it's 100% compatible. It has a lot of potential, but then customers may not want to migrates some tools since those tools don't officially support this product.
I wonder if this means that it will be compatible with SQL Server Management Studio (SSMS) and the SQL Data Tools (SDDT) that come with Visual Studio community edition.<p>One thing I really like about SQL Server aside from the high quality tooling is that I can write stored procedures which return multiple heterogeneous result sets with no ceremony. The TSQL dialect is one of the best IMO.