5 ms·

Contribution to Postgres from Microsoft. We are in reality check. This is an awesome thing. Would love to see more and more open source contributions from Micr

Contribution to Postgres from Microsoft. We are in reality check. This is an awesome thing. Would love to see more and more open source contributions from Microsoft.

AaronFriel 6y ago
Microsoft purchased CitusDB a while back, so you can expect many many contributions to Postgres to be from Microsoft now.
- throwaway_pdp09 6y ago
  I'm deeply glad MS is contributing not controlling, given the declining state of MSSQL. Maybe it'll motivate them to pull their socks up over their own flagship product.
  - baq 6y ago
    what is declining in MSSQL? last 3 years were an absolute gamechanger for my use cases: dockerized linux option for linux testing, very helpful columnstore improvements, the HA story is quite impressive, in fact there are only two major drawbacks that i can tell: no command line tool like pg_dump and the awe-inspiring price of the license (though i hear still less than oracle).
    - throwaway_pdp09 6y ago
      start here https://www.mssqltips.com/sqlservertip/3074/use-caution-with-sql-servers-merge-statement/ https://www.mssqltips.com/sqlservertip/3074/use-caution-with... Many are fixed but should never have been there. Some are still extant. There's plenty more low grade shit in what was once a goof product. I haven't used the features you discuss but then I need basic functionality to work. I've run into stupid performance bugs with trivial CTEs, and I found a link showing a CTE error which I could duplicate (pgres got it right, mssql didn't). Can't find link, sorry.
    - davidgl 6y ago
      The cost, god the cost has got so much higher. I love SQL Server but am being forced off it, especially as you need enterprise to do queryable replicas etc.
  - 0df8dkdf 6y ago
    there is a reason why MSSQL is called tedious in npm moudle.
a_imho 6y ago
Personally I'm not fond of Microsoft embracing anything I use.
- royjacobs 6y ago
  That's a very unfortunate point of view to take, stuck in the mists of time. Wouldn't it be better to be forward-looking instead?
  - akiselev 6y ago
    Embrace (GP) => Extend (looking forward) => Extinguish (We wanted the best, but it turned out like always)
    - royjacobs 6y ago
      I find it quite a mental leap to go from "Microsoft improved connection scalability in Postgres" to "Microsoft is going to extinguish Postgres, arguably the most popular open-source database in existence".
      - akiselev 6y ago
        Times have changed, economic incentives have not. Linux, Postgres, et al will survive but have no doubt that Microsoft will try to extinguish them. EEE is not some discredited strategy from Gates era Microsoft that magically vanished with a few executive changes, it is a fundamental defense mechanism of umbrella enterprises driven largely by a bunch of little decisions by self interested actors at all levels of the hierarchy. Gates' Microsoft helped give it a name with a catchy alliteration, but Nadella's Microsoft will define what that phrase means in the cloud era.
  - throwaway189262 6y ago
    Maybe this will be more like Chrome than IE. Lightning fast and powerfully invasive
  - a_imho 6y ago

Contribution to Postgres from Microsoft. We are in reality check. This is an awesome thing. Would love to see more and more open source contributions from Microsoft.

AaronFriel 6y ago

Microsoft purchased CitusDB a while back, so you can expect many many contributions to Postgres to be from Microsoft now.

throwaway_pdp09 6y ago
I'm deeply glad MS is contributing not controlling, given the declining state of MSSQL. Maybe it'll motivate them to pull their socks up over their own flagship product.
- baq 6y ago
  what is declining in MSSQL? last 3 years were an absolute gamechanger for my use cases: dockerized linux option for linux testing, very helpful columnstore improvements, the HA story is quite impressive, in fact there are only two major drawbacks that i can tell: no command line tool like pg_dump and the awe-inspiring price of the license (though i hear still less than oracle).
  - throwaway_pdp09 6y ago
    start here https://www.mssqltips.com/sqlservertip/3074/use-caution-with-sql-servers-merge-statement/ https://www.mssqltips.com/sqlservertip/3074/use-caution-with... Many are fixed but should never have been there. Some are still extant. There's plenty more low grade shit in what was once a goof product. I haven't used the features you discuss but then I need basic functionality to work. I've run into stupid performance bugs with trivial CTEs, and I found a link showing a CTE error which I could duplicate (pgres got it right, mssql didn't). Can't find link, sorry.
  - davidgl 6y ago
    The cost, god the cost has got so much higher. I love SQL Server but am being forced off it, especially as you need enterprise to do queryable replicas etc.
- 0df8dkdf 6y ago
  there is a reason why MSSQL is called tedious in npm moudle.

a_imho 6y ago

Personally I'm not fond of Microsoft embracing anything I use.

royjacobs 6y ago
That's a very unfortunate point of view to take, stuck in the mists of time. Wouldn't it be better to be forward-looking instead?
- akiselev 6y ago
  Embrace (GP) => Extend (looking forward) => Extinguish (We wanted the best, but it turned out like always)
  - royjacobs 6y ago
    I find it quite a mental leap to go from "Microsoft improved connection scalability in Postgres" to "Microsoft is going to extinguish Postgres, arguably the most popular open-source database in existence".
    - akiselev 6y ago
      Times have changed, economic incentives have not. Linux, Postgres, et al will survive but have no doubt that Microsoft will try to extinguish them. EEE is not some discredited strategy from Gates era Microsoft that magically vanished with a few executive changes, it is a fundamental defense mechanism of umbrella enterprises driven largely by a bunch of little decisions by self interested actors at all levels of the hierarchy. Gates' Microsoft helped give it a name with a catchy alliteration, but Nadella's Microsoft will define what that phrase means in the cloud era.
- throwaway189262 6y ago
  Maybe this will be more like Chrome than IE. Lightning fast and powerfully invasive
- a_imho 6y ago