15 ms·

No Postgres support yet. Looks like a great app though. https://github.com/Microsoft/sqlopsstudio/issues/56 https://github.com/Microsoft/sqlopsstudio/issues/56

WesleyLivesay 9y ago
I hope this grows like VS Code has since it was launched. Will hopefully add support for a lot of different DBs.
userbinator 9y ago
You're kidding, right? This is a Microsoft product. Microsoft have their own database. What value is it to them to help people continue using competitor's products? Besides, it's not like Postgres doesn't have plenty of GUI tools already: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...
- hobs 9y ago
  I was actually in the room listening as the question came up to the team that makes this tool, its not off the table at all. The value to them is Azure, which hosts open source databases, why not give your customers the decent tooling at the same time? You'll even find things in the tool that reference non-Microsoft language, eg the button generally labeled "Estimated Execution Plan" in SQL Server Management Studio is labeled "Explain". The methodology behind the plugin absolutely allows abstracting out the MSSQL specific components, its just an open source fork of VS Code.
  - karma_fountain 9y ago
    I implore you to do this. Every time pgadmin dies, I also die a little inside.
- pkaye 9y ago
  Well Microsoft does offer PostgreSQL on Azure from what I can tell... https://azure.microsoft.com/en-us/services/postgresql/ https://azure.microsoft.com/en-us/services/postgresql/
- reificator 9y ago
  Not kidding. If my database is Postgres, I develop for it in Visual Studio Code and deploy it to Azure, why shouldn't I be able to explore it with another Microsoft product. I grew up with the Microsoft you describe, but they've been gone for several years now. Not to say they can do no wrong, or that we shouldn't be wary, but to think it ridiculous that they could support multiple databases is not compatible with their actions lately.
- qarioz 9y ago
  Then explain why Microsoft become platinum sponsor for MariaDB.
  - frik 9y ago
    Good to know. Will move to Percona or MySQL.
    - breakingcups 9y ago
      That seems like a very short-sighted, if not childish, statement.
      - frik 9y ago
        What? My decision is based on years of observation. I applauded MariaDB at first, but they almost went bankrupt, merged with another company, changed he business model (release new code parts in a different license). And on the other side I still remember Cyanogen + CyanogenMOD that got so much worse and died because of a certain "sponsor". https://en.m.wikipedia.org/wiki/CyanogenMod https://en.m.wikipedia.org/wiki/CyanogenMod nowadays forked as LineageOS, but many things got lost incl older devices. So a small number of companies with deep pockets are like cancer to open source projects, the good thing is they can be forked. But see MaxDB for an open source database that never got forked, and there is no open source project anymore, it got closed source, and nowadays powers parts of expensive SAP HANA data store. It is better to install Percona MySQL fork, or MySQL community edition.
- jsmthrowaway 9y ago
  You do realize this very release works on competitors to Windows, which is still a revenue driver at Microsoft, yeah? As does, you know, Azure? ...aaaand SQL Server? :) http://www.zdnet.com/article/microsoft-nearly-one-in-three-azure-virtual-machines-now-are-running-linux/ http://www.zdnet.com/article/microsoft-nearly-one-in-three-a... It’s Nadella Microsoft, amigo. Not saying marry them, but at least let them buy you a beer.
  - smartbit 9y ago
    Up from 30% in 2016, nowadays 40% of the instances on Azure run Linux http://www.zdnet.com/article/microsoft-says-40-percent-of-all-vms-in-azure-now-are-running-linux/ http://www.zdnet.com/article/microsoft-says-40-percent-of-al...
manigandham 9y ago
The 2ndQuadrant team is building OmniDB: https://github.com/OmniDB/OmniDB https://github.com/OmniDB/OmniDB

WesleyLivesay 9y ago

I hope this grows like VS Code has since it was launched. Will hopefully add support for a lot of different DBs.

userbinator 9y ago

You're kidding, right? This is a Microsoft product. Microsoft have their own database. What value is it to them to help people continue using competitor's products? Besides, it's not like Postgres doesn't have plenty of GUI tools already: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...

hobs 9y ago
I was actually in the room listening as the question came up to the team that makes this tool, its not off the table at all. The value to them is Azure, which hosts open source databases, why not give your customers the decent tooling at the same time? You'll even find things in the tool that reference non-Microsoft language, eg the button generally labeled "Estimated Execution Plan" in SQL Server Management Studio is labeled "Explain". The methodology behind the plugin absolutely allows abstracting out the MSSQL specific components, its just an open source fork of VS Code.
- karma_fountain 9y ago
  I implore you to do this. Every time pgadmin dies, I also die a little inside.
pkaye 9y ago
Well Microsoft does offer PostgreSQL on Azure from what I can tell... https://azure.microsoft.com/en-us/services/postgresql/ https://azure.microsoft.com/en-us/services/postgresql/
reificator 9y ago
Not kidding. If my database is Postgres, I develop for it in Visual Studio Code and deploy it to Azure, why shouldn't I be able to explore it with another Microsoft product. I grew up with the Microsoft you describe, but they've been gone for several years now. Not to say they can do no wrong, or that we shouldn't be wary, but to think it ridiculous that they could support multiple databases is not compatible with their actions lately.
qarioz 9y ago
Then explain why Microsoft become platinum sponsor for MariaDB.
- frik 9y ago
  Good to know. Will move to Percona or MySQL.
  - breakingcups 9y ago
    That seems like a very short-sighted, if not childish, statement.
    - frik 9y ago
      What? My decision is based on years of observation. I applauded MariaDB at first, but they almost went bankrupt, merged with another company, changed he business model (release new code parts in a different license). And on the other side I still remember Cyanogen + CyanogenMOD that got so much worse and died because of a certain "sponsor". https://en.m.wikipedia.org/wiki/CyanogenMod https://en.m.wikipedia.org/wiki/CyanogenMod nowadays forked as LineageOS, but many things got lost incl older devices. So a small number of companies with deep pockets are like cancer to open source projects, the good thing is they can be forked. But see MaxDB for an open source database that never got forked, and there is no open source project anymore, it got closed source, and nowadays powers parts of expensive SAP HANA data store. It is better to install Percona MySQL fork, or MySQL community edition.
jsmthrowaway 9y ago
You do realize this very release works on competitors to Windows, which is still a revenue driver at Microsoft, yeah? As does, you know, Azure? ...aaaand SQL Server? :) http://www.zdnet.com/article/microsoft-nearly-one-in-three-azure-virtual-machines-now-are-running-linux/ http://www.zdnet.com/article/microsoft-nearly-one-in-three-a... It’s Nadella Microsoft, amigo. Not saying marry them, but at least let them buy you a beer.
- smartbit 9y ago
  Up from 30% in 2016, nowadays 40% of the instances on Azure run Linux http://www.zdnet.com/article/microsoft-says-40-percent-of-all-vms-in-azure-now-are-running-linux/ http://www.zdnet.com/article/microsoft-says-40-percent-of-al...

manigandham 9y ago

The 2ndQuadrant team is building OmniDB: https://github.com/OmniDB/OmniDB https://github.com/OmniDB/OmniDB