Announcing SQL Server on Linux

Re:Announcing SQL Server on Linux by dsp1234 on Monday March 07, 2016 @04:11PM (#11241722)

I'm honestly not sure how much of that would be related to the query planner vs linked server network code.

Speaking of which, linked servers (cross OS, cross SQL type database queries) are native in MSSQL, but require a third party odbclink in postgres, which does not appear to have been updated since 2010[0].

[0] - http://www.cybertec.at/en/media/downloads/

[ Parent | on HN ]

Re:Announcing SQL Server on Linux by sixdimensional on Monday March 07, 2016 @04:22PM (#11241798)

Linked servers in Postgres can be implemented using foreign data wrappers (part of the SQL/MED implementation in Postgres - MED = management of external data which is actually in the SQL spec): https://wiki.postgresql.org/wiki/Foreign_data_wrappers

[ Parent | on HN ]

Re:Announcing SQL Server on Linux by dsp1234 on Monday March 07, 2016 @05:00PM (#11242087)

Which are super awesome!

but stuff like "Does not compile with PostgreSQL >= 9.2!", "A patched, but completely untested version", and "The current version does not yet support WHERE clause push-down, column push-down, JOIN push-down, or write operations."[0] are riskier (and a harder sell to management) than having the functionality backed in the core engine and admin interfaces.

[0] - https://github.com/GeoffMontee/tds_fdw

[ Parent | on HN ]