12 ms·

Azure Data Studio: An Open-Source GUI Editor for Postgres

307 points by craigkerstiens 8y ago

sixhobbits 8y ago
This looks really nice, but it's functionality is similar enough to Google Data Studio (also connects to data sources) but different enough (an editor instead of a dashboard) that it's going to cause confusion.
lol768 8y ago
For anyone else who's curious: yes, it's an Electron app (source at: https://github.com/Microsoft/azuredatastudio https://github.com/Microsoft/azuredatastudio). Think I'll stick to DataGrip personally, though I'd be interested to see some performance benchmarks to disprove my own comprehension of the quality of apps built primarily in HTML/JS/Electron.
- WorldMaker 8y ago
  VS Code is often very favorably remarked on for its good, consistent performance. Azure Data Studio shares a lot of dependencies/components directly with VS Code and has what appears to be a very similar build infrastructure. Microsoft seems to have very good quality in their HTML/JS/Electron apps.
  - gmueckl 8y ago
    Good quality Electron apps? I guess the Skype team didn't get that memo... :( Seriously, even if performance of JS has been dragged kicking and screaming in to the 21st century now, the huge memory footprint of these abominations feels utterly wrong to me.
    - GordonS 8y ago
      I've been suffering with the abomination that is pgAdmin 4 for a while now - I'd bet money that Azure Data Studio uses less memory than it.
- userbinator 8y ago
  ...and yes, it phones home: https://docs.microsoft.com/en-us/sql/azure-data-studio/usage-data-collection https://docs.microsoft.com/en-us/sql/azure-data-studio/usage...
  - fxfan 8y ago
    God forbid they learn which features people use more and maybe improve them? Surely you don't use gmail or any other webmail or a web service?
    - bitwize 8y ago
      The Daily Telegraph once put heat monitors under everyone's desk. There was an outcry among the employees about this, and the explanation from the Telegraph was it was part of their HVAC system, and allowed the air conditioner and heater to smartly determine which parts of the building needed more heating and cooling due to more human activity going on in those parts. Under the most charitable interpretation of the above, the Telegraph meant what it said, and only ever intended to use the data thus collected to optimize HVAC output to only those areas with enough human activity to warrant it. But, you see, once they had the data about who was at their desk and who wasn't, it behooves them to act on it.
      - fxfan 8y ago
        Except the privacy policy clearly states what Microsoft users this data for. You can go around flailing your hands in constant paranoia or you can actually give an evidence of wrongdoing and sue the shit out of them. But why wait for evidence when posting "Micro$oft is evil" is more fun?
        nrb 8y ago
        Also, the first thing you see when you launch for the first time is a notification about this functionality and simple opt-out instructions. I guess ideally it would be opt-in but I definitely wouldn't classify this as sinister. VS Code seems to have driven a lot of improvement to features most important to users based on this data.
based2 8y ago
Does a datpac already exist? Data-tier Application Component Packages
t0astbread 8y ago
Can this do PL/pgSQL?
- rachelagy 8y ago
  Yes, you can create functions with plpgsql as the language.
kumarvvr 8y ago
Does this work on local postgres servers??
- obenn 8y ago
  Yes. “The Postgres server can be hosted on-premises, in a virtual machine (VM), or from the managed service of any cloud provider.”
mark_l_watson 8y ago
I like that you can use it in its own app and also as a plugin for VSCode. Microsoft really turned it around by supporting developers, IMO.
- putlake 8y ago
  Took a while for me to find the VSCode extension. Here it is: https://marketplace.visualstudio.com/items?itemName=ms-ossdata.vscode-postgresql https://marketplace.visualstudio.com/items?itemName=ms-ossda...
- pjmlp 8y ago
  They never stopped supporting developers on Windows.
  - mark_l_watson 8y ago
    You are of course right. I was talking from my perspective. I don’t use Windows but I think Office 365 is the best deal ever, and I appreciate general tools like VSCode, keeping github on track and not changing things, etc.
- 1wd 8y ago
  The VSCode plugin supports to "Write queries with IntelliSense". This sounds fantastic. But Ctrl+Space (Trigger Suggest) does not suggest anything useful for me. In what situations does this work?
- h1d 8y ago
  I'd say JetBrains is about to get nervous with these free offerings on top of VSCode.
craigkerstiens 8y ago
New to the Microsoft team I got an early look at this and was super excited. Personally I'm biased towards psql [1], but admittedly there are many that prefer a GUI interface [2] when working with their database. Postgres is a great and powerful database, but as a community we're behind in this aspect. While I don't think we need a million editors for a database that there isn't a clear winner when it comes to Postgres makes this a welcome addition and I'm excited to see how it helps make Postgres more approachable for others. 1. http://www.craigkerstiens.com/2013/02/13/How-I-Work-With-Postgres/ http://www.craigkerstiens.com/2013/02/13/How-I-Work-With-Pos... 2. https://www.softwareandbooz.com/postgresql-for-a-sql-server-dba-a-series/ https://www.softwareandbooz.com/postgresql-for-a-sql-server-...
- j88439h84 8y ago
  https://github.com/dbcli/pgcli https://github.com/dbcli/pgcli is my favorite terminal client for postgres. It has smart completion, syntax highlighting, and more.
xfalcox 8y ago
Really like it so far. I was a heavy pgAdmin3 user at $lastjob and the fact that clicking some elements would freeze it wasn't great. This looks to cache all details on connection. The data view doesn't really work with very long text fields, maybe allowing users to edit those in a panel or modal could help UX. Also, it doesn't really handles schemas, just prepend those to the table name, instead of treating it like a "folder". Schemas have permissions so we need to "see" those. With the great hole that pgAdmin4 left, and with DataGrip being more on the heavy side, I think this app can grab a good share of users. Good work!
jsmeaton 8y ago
It looks like the VSCode extension version is missing the connection and object explorer that the standalone app contains. That's unfortunate. A few other issues: Creating a connection from the command palette can not use a non-default port. You'll need to edit the settings file by hand to change that. Currently no support for SSH tunnels (unless you launch a tunnel yourself from a terminal). I've opened a GitHub issue for that support. When running a query it keeps asking me for a username for the connection, even though the username is configured in the connection profile. I currently use datagrip, but I'd much prefer to stay within the vscode interface rather than switching between the two, as I'm much more familiar with the vscode keyboard shortcuts and command palette. It's never really obvious which connection a datagrip "console" is attached to.
- nitinreddy88 8y ago
  I appreciate your efforts to put down missing functionality. Products evolve over time, cant expect everything in first cut and compare it with product which is staying for quite sometime
  - h1d 8y ago
    I don't really see how people are supposed to connect to databases without SSH tunnel support. Are you supposed to be connecting to your development localhost database or be inside corporate network where direct connection to the database is allowed?
    - odorousrex 8y ago
      My assumption is that they were building for MSSQL Server first, where AD/Windows Authentication is still the most popular authentication scheme.
    - tatersolid 8y ago
      Most people use a VPN of some sort when connecting to remote databases Our DB servers don’t have any ports listening on the internet, not even SSH. TLS can be enforced for DB connections (both pg and mssql support this), but that’s still prone to credential stuffing and the client machine isn’t usually authenticated. Lots of regulations generally require some extra security layer protecting connections to the DB.
fxfan 8y ago
Does it have the excellent perf analysis that sql server express's client comes with?
symlinkk 8y ago
Why does it have "Azure" in its name? Whoever is in charge of naming things at Microsoft is doing a poor job.
- michaelmarkell 8y ago
  For consistent branding around all tools and technologies that could feasibly be used to build applications on top of Azure
  - titanix2 8y ago
    That's still not good naming: Azure has so much services you could practically run anything on it. If keeping the Azure name to products actually running in the cloud it makes sense, otherwise it's just brand dilution.
  - PudgePacket 8y ago
    That's not a super strong argument.. Visual Studio -> Azure Code Studio, TypeScript -> AzureScript, Windows -> Azuredows.. (Only a little tongue in cheek )
- Delmania 8y ago
  Originally it was built to manage SQL server instances on Azure.
paulmendoza 8y ago
My database server has 200+ databases and I had to stop using Datagrip because it would freezea the time. Super excited to check this out.
- philliphaydon 8y ago
  Turn off auto sync then. Sync only the portion of the tree you want synced.
some-one-too 8y ago
I've never seen on HN anyone ever mentioned "SQL Workbench/J": works across many database systems, code completion, import/export, scripting, console mode, the list just goes on and on... www.sql-workbench.eu
- mmsimanga 8y ago
  I am a big fan of SQL Workbench/J. I have mentioned it in a few threads[0][1] on SQL tools but have also been surprised it isn't more popular. [0]https://news.ycombinator.com/item?id=18934949 https://news.ycombinator.com/item?id=18934949 [1]https://news.ycombinator.com/item?id=18934436 https://news.ycombinator.com/item?id=18934436
garyclarke27 8y ago
Wow, well done Microsoft, I am looking forward to trying this out. PgAdmin is an embarrassment to the incredible Postgres community - it’s SQL editor is virtually useless, so slow and buggy. Probably because PSQL is the favoured option for most of the contributors, I’m not a huge fan of command line editing, I much prefer tools like Sublime Text, so I use Sublime Text 3 for SQL editing and it’s wonderful - blazing speed, rock solid, quite happy to display a few million rows, such queries would have no chance in Pgadmin. Also has a pg specific syntax highlighting plugin.
- cabraca 8y ago
  I'm quite happy with https://dbeaver.io/ https://dbeaver.io/ Maybe give it a try?
  - kkarakk 8y ago
    Dbeaver just has one glaring issue in my mind -it has a VERY slow pace of development and issue managment. They had something like 900 issues open on their github the last time i saw it with around 200 of them having no replies at all. I was trying it out for sql server though so i don't know if it does better or not for postgres
    - throwaway333444 8y ago
      The large number of open issues is a valid complaint although that is more of an indicator of popularity. As for the pace of development I’d challenge you to name another SQL IDE that releases updates twice a month. (Note: The exception was the last release cycle which took 3 weeks rather than 2 but that was for the 6.0 release)
- pjmlp 8y ago
  When the new version of PgAdmin came out, I kept using the previous native version, much better than their UI reboot.
  - emptyfile 8y ago
nindalf 8y ago
Quick summary of the thread for those joining us * This looks like a neat tool. Will check this out and compare it to DataGrip, Dbeaver etc. * It's electron. This is terrible. * There's analytics code in there. This is terrible.
- switch007 8y ago
  Azure Data Studio also stores your credentials in plaintext if you tick 'Remember' (on Linux at least – it does not use the system keychains)
  - vetinari 8y ago
    It also supports GSSAPI out of the box, unlike java-based alternatives (at least under linux, where java doesn't support ccache other than FILE, and under macos, where java needs monkeying with java.login.config).
  - SamuelAdams 8y ago
    Please report an issue here: https://github.com/Microsoft/azuredatastudio/issues https://github.com/Microsoft/azuredatastudio/issues
    - switch007 8y ago
      There is one already — as a feature request to implement keychains.
  - datavirtue 8y ago
    In secure home directory.
- GordonS 8y ago
  > There's analytics code in there. This is terrible Sorry, this is another point I disagree with. As a developer I can appreciate the need to understand how an application is used, and to get diagnostic data when things go wrong. What is terrible is when you can't opt-out of telemetry, and when what is sent is completely opaque - that's not the case here.
radiKal07 8y ago
This looks nice but as I expected it's built with Electron. I personally use https://tableplus.io/ https://tableplus.io/ . It's native and has great UI and features.
- sydd 8y ago
  For me DataGrip. How do these 2 compare to it?
  - philliphaydon 8y ago
    Table plus appears to me MAC only. A shame. But I’m happy with datagrip.
    - bbernoulli 8y ago
      It is on windows too: https://tableplus.io/windows https://tableplus.io/windows
      - philliphaydon 8y ago
        Oh cool. I couldn’t find that link on my phone and all I saw was OS X download and screen shots so I assumed OS X only. I’ll give it a go tomorrow. Thanks.
  - h1d 8y ago
    You can easily tell if you just give TablePlus a try with its demo. Starts up very quickly, doesn't have bunch of options and stuff but I think it has enough to be far more intuitive. I'd say the interface is almost comparable to SequelPro just not as polished. (Font sizing, space padding and column sizing. Small stuff but it does feel awkward to me.)
- walterstucco 8y ago
  Some small difference Tableplus is - not cross platform - not open source - not free
aeroaks 8y ago
I thought DBeaver is also there!
anewhnaccount2 8y ago
From the license, this is "shared source" not OSI open source: https://github.com/Microsoft/azuredatastudio/blob/master/LICENSE.txt https://github.com/Microsoft/azuredatastudio/blob/master/LIC...
- kevcunnane 8y ago
  The PostgreSQL extension is fully MIT licensed: https://github.com/Microsoft/azuredatastudio-postgresql/blob/master/LICENSE https://github.com/Microsoft/azuredatastudio-postgresql/blob... and https://github.com/Microsoft/pgtoolsservice/blob/master/License.txt https://github.com/Microsoft/pgtoolsservice/blob/master/Lice... for the backing service.
pella 8y ago
I hope someday they will support PostGIS geometry viewer - like: http://www.bostongis.com/blog/index.php?/archives/272-pgAdmin4-now-offers-PostGIS-geometry-viewer.html http://www.bostongis.com/blog/index.php?/archives/272-pgAdmi...
fredley 8y ago
I use Azure Data Studio for SQL Server already and it's fantastic. Super lightweight, fast, and a really well-thought-through interface. It's honestly the SQL administration app that I prefer out of all that I've used, free or otherwise, and I'm very happy MS are taking it to more backends.
drewda 8y ago
I've recently been having good luck with this VS Code extension that adds a Postgres tab for exploring schemas and running queries: https://marketplace.visualstudio.com/items?itemName=ckolkman.vscode-postgres https://marketplace.visualstudio.com/items?itemName=ckolkman...
b0bby_tabl3s 8y ago
I love Azure Data Studio. I can bang out SQL, Powershell, and Bash all from a single entry point. Good stuff.
bmaupin 8y ago
The title was a bit misleading for me, giving me the impression that Azure Data Studio is a new tool specifically for Postgres. The reality seems to be that Azure Data Studio is an existing tool which already supports MS SQL databases, and preview support for Postgres has been added. Which makes more sense to me than Microsoft creating a new tool just for Postgres.
marcus_holmes 8y ago
Looked really interesting. I'm working on a SQL-intensive project using Postgres at the moment, and a better way of editing the numerous scripts would be great. Downloaded it, got it connected to my localhost Postgres server. Opened a script file, nice syntax highlighting, yay :) Syntax error at or near "drop". Oh dear. Ah well, back to Code and psql it is...
envoked 8y ago
I’ve been using Postico (https://eggerapps.at/postico https://eggerapps.at/postico) on OSX for the last few years and been enjoying it: clean look, ability to edit and explore schemas, ability to export results to a variety of formats (JSON, CSV, etc.), and good cadence with releases. The main thing it can’t do well is export/import large databases but that’s what ‘pg_dump’ and friends are for.
minhajuddin 8y ago
For vim users, there is an awesome plugin to talk to postgres and a ton of other databases called dbext.vim https://github.com/vim-scripts/dbext.vim https://github.com/vim-scripts/dbext.vim Setting it up takes a little effort though.
yellowapple 8y ago
I've been using ADS for a couple months now at work (since we've switched to a new warehouse management system that uses SQL Server for its database) and it's been pretty great as a cross-platform replacement for SSMS. The built-in support for CSV and JSON dumps has been incredibly handy, too. It's both among the few Electron (I think?) apps I like and among the few Microsoft products I like. Being able to use the same tool for Postgres would be awesome (we use both Postgres and Redshift here, too); I've long felt that SQL Server's a god-awful DB with awesome tooling while PostgreSQL's an awesome DB with god-awful tooling, and now I'm looking forward to finally getting the best of both worlds. I wonder if it's possible to create extensions for arbitrary ODBC and/or JDBC connections? If so, then that'd be yet another thing I could manipulate with ADS (our ERP exposes its database via a presumably-proprietary DB protocol for which they provide their own ODBC and JDBC connectors). It'd be awesome to have a properly-good one-stop shop for all my SQL-finagling needs. Now if only I could integrate all this with Emacs somehow... EDIT: alas, it does not seem to want to install correctly on Slackware, whether via ADS' extensions manager or by manually downloading/installing the VSIX package. Seems to hang on "Starting pgsql service", and any attempt to actually do anything throws a giant "Provider doesn't exist. id: PGSQL" error (and attempting to run queries anyway just throws "Error: No Handler Registered").

This looks really nice, but it's functionality is similar enough to Google Data Studio (also connects to data sources) but different enough (an editor instead of a dashboard) that it's going to cause confusion.

lol768 8y ago

For anyone else who's curious: yes, it's an Electron app (source at: https://github.com/Microsoft/azuredatastudio https://github.com/Microsoft/azuredatastudio). Think I'll stick to DataGrip personally, though I'd be interested to see some performance benchmarks to disprove my own comprehension of the quality of apps built primarily in HTML/JS/Electron.

WorldMaker 8y ago
VS Code is often very favorably remarked on for its good, consistent performance. Azure Data Studio shares a lot of dependencies/components directly with VS Code and has what appears to be a very similar build infrastructure. Microsoft seems to have very good quality in their HTML/JS/Electron apps.
- gmueckl 8y ago
  Good quality Electron apps? I guess the Skype team didn't get that memo... :( Seriously, even if performance of JS has been dragged kicking and screaming in to the 21st century now, the huge memory footprint of these abominations feels utterly wrong to me.
  - GordonS 8y ago
    I've been suffering with the abomination that is pgAdmin 4 for a while now - I'd bet money that Azure Data Studio uses less memory than it.
userbinator 8y ago
...and yes, it phones home: https://docs.microsoft.com/en-us/sql/azure-data-studio/usage-data-collection https://docs.microsoft.com/en-us/sql/azure-data-studio/usage...
- fxfan 8y ago
  God forbid they learn which features people use more and maybe improve them? Surely you don't use gmail or any other webmail or a web service?
  - bitwize 8y ago
    The Daily Telegraph once put heat monitors under everyone's desk. There was an outcry among the employees about this, and the explanation from the Telegraph was it was part of their HVAC system, and allowed the air conditioner and heater to smartly determine which parts of the building needed more heating and cooling due to more human activity going on in those parts. Under the most charitable interpretation of the above, the Telegraph meant what it said, and only ever intended to use the data thus collected to optimize HVAC output to only those areas with enough human activity to warrant it. But, you see, once they had the data about who was at their desk and who wasn't, it behooves them to act on it.
    - fxfan 8y ago
      Except the privacy policy clearly states what Microsoft users this data for. You can go around flailing your hands in constant paranoia or you can actually give an evidence of wrongdoing and sue the shit out of them. But why wait for evidence when posting "Micro$oft is evil" is more fun?
      - nrb 8y ago
        Also, the first thing you see when you launch for the first time is a notification about this functionality and simple opt-out instructions. I guess ideally it would be opt-in but I definitely wouldn't classify this as sinister. VS Code seems to have driven a lot of improvement to features most important to users based on this data.

based2 8y ago

Does a datpac already exist? Data-tier Application Component Packages

t0astbread 8y ago

Can this do PL/pgSQL?

rachelagy 8y ago
Yes, you can create functions with plpgsql as the language.

kumarvvr 8y ago

Does this work on local postgres servers??

obenn 8y ago
Yes. “The Postgres server can be hosted on-premises, in a virtual machine (VM), or from the managed service of any cloud provider.”

mark_l_watson 8y ago

I like that you can use it in its own app and also as a plugin for VSCode. Microsoft really turned it around by supporting developers, IMO.

putlake 8y ago
Took a while for me to find the VSCode extension. Here it is: https://marketplace.visualstudio.com/items?itemName=ms-ossdata.vscode-postgresql https://marketplace.visualstudio.com/items?itemName=ms-ossda...
pjmlp 8y ago
They never stopped supporting developers on Windows.
- mark_l_watson 8y ago
  You are of course right. I was talking from my perspective. I don’t use Windows but I think Office 365 is the best deal ever, and I appreciate general tools like VSCode, keeping github on track and not changing things, etc.
1wd 8y ago
The VSCode plugin supports to "Write queries with IntelliSense". This sounds fantastic. But Ctrl+Space (Trigger Suggest) does not suggest anything useful for me. In what situations does this work?
h1d 8y ago
I'd say JetBrains is about to get nervous with these free offerings on top of VSCode.

craigkerstiens 8y ago

New to the Microsoft team I got an early look at this and was super excited. Personally I'm biased towards psql [1], but admittedly there are many that prefer a GUI interface [2] when working with their database. Postgres is a great and powerful database, but as a community we're behind in this aspect. While I don't think we need a million editors for a database that there isn't a clear winner when it comes to Postgres makes this a welcome addition and I'm excited to see how it helps make Postgres more approachable for others. 1. http://www.craigkerstiens.com/2013/02/13/How-I-Work-With-Postgres/ http://www.craigkerstiens.com/2013/02/13/How-I-Work-With-Pos... 2. https://www.softwareandbooz.com/postgresql-for-a-sql-server-dba-a-series/ https://www.softwareandbooz.com/postgresql-for-a-sql-server-...

j88439h84 8y ago
https://github.com/dbcli/pgcli https://github.com/dbcli/pgcli is my favorite terminal client for postgres. It has smart completion, syntax highlighting, and more.

xfalcox 8y ago

Really like it so far. I was a heavy pgAdmin3 user at $lastjob and the fact that clicking some elements would freeze it wasn't great. This looks to cache all details on connection. The data view doesn't really work with very long text fields, maybe allowing users to edit those in a panel or modal could help UX. Also, it doesn't really handles schemas, just prepend those to the table name, instead of treating it like a "folder". Schemas have permissions so we need to "see" those. With the great hole that pgAdmin4 left, and with DataGrip being more on the heavy side, I think this app can grab a good share of users. Good work!

jsmeaton 8y ago

It looks like the VSCode extension version is missing the connection and object explorer that the standalone app contains. That's unfortunate. A few other issues: Creating a connection from the command palette can not use a non-default port. You'll need to edit the settings file by hand to change that. Currently no support for SSH tunnels (unless you launch a tunnel yourself from a terminal). I've opened a GitHub issue for that support. When running a query it keeps asking me for a username for the connection, even though the username is configured in the connection profile. I currently use datagrip, but I'd much prefer to stay within the vscode interface rather than switching between the two, as I'm much more familiar with the vscode keyboard shortcuts and command palette. It's never really obvious which connection a datagrip "console" is attached to.

nitinreddy88 8y ago
I appreciate your efforts to put down missing functionality. Products evolve over time, cant expect everything in first cut and compare it with product which is staying for quite sometime
- h1d 8y ago
  I don't really see how people are supposed to connect to databases without SSH tunnel support. Are you supposed to be connecting to your development localhost database or be inside corporate network where direct connection to the database is allowed?
  - odorousrex 8y ago
    My assumption is that they were building for MSSQL Server first, where AD/Windows Authentication is still the most popular authentication scheme.
  - tatersolid 8y ago
    Most people use a VPN of some sort when connecting to remote databases Our DB servers don’t have any ports listening on the internet, not even SSH. TLS can be enforced for DB connections (both pg and mssql support this), but that’s still prone to credential stuffing and the client machine isn’t usually authenticated. Lots of regulations generally require some extra security layer protecting connections to the DB.

fxfan 8y ago

Does it have the excellent perf analysis that sql server express's client comes with?

symlinkk 8y ago

Why does it have "Azure" in its name? Whoever is in charge of naming things at Microsoft is doing a poor job.

michaelmarkell 8y ago
For consistent branding around all tools and technologies that could feasibly be used to build applications on top of Azure
- titanix2 8y ago
  That's still not good naming: Azure has so much services you could practically run anything on it. If keeping the Azure name to products actually running in the cloud it makes sense, otherwise it's just brand dilution.
- PudgePacket 8y ago
  That's not a super strong argument.. Visual Studio -> Azure Code Studio, TypeScript -> AzureScript, Windows -> Azuredows.. (Only a little tongue in cheek )
Delmania 8y ago
Originally it was built to manage SQL server instances on Azure.

paulmendoza 8y ago

My database server has 200+ databases and I had to stop using Datagrip because it would freezea the time. Super excited to check this out.

philliphaydon 8y ago
Turn off auto sync then. Sync only the portion of the tree you want synced.

some-one-too 8y ago

I've never seen on HN anyone ever mentioned "SQL Workbench/J": works across many database systems, code completion, import/export, scripting, console mode, the list just goes on and on... www.sql-workbench.eu

mmsimanga 8y ago
I am a big fan of SQL Workbench/J. I have mentioned it in a few threads[0][1] on SQL tools but have also been surprised it isn't more popular. [0]https://news.ycombinator.com/item?id=18934949 https://news.ycombinator.com/item?id=18934949 [1]https://news.ycombinator.com/item?id=18934436 https://news.ycombinator.com/item?id=18934436

garyclarke27 8y ago

Wow, well done Microsoft, I am looking forward to trying this out. PgAdmin is an embarrassment to the incredible Postgres community - it’s SQL editor is virtually useless, so slow and buggy. Probably because PSQL is the favoured option for most of the contributors, I’m not a huge fan of command line editing, I much prefer tools like Sublime Text, so I use Sublime Text 3 for SQL editing and it’s wonderful - blazing speed, rock solid, quite happy to display a few million rows, such queries would have no chance in Pgadmin. Also has a pg specific syntax highlighting plugin.

cabraca 8y ago
I'm quite happy with https://dbeaver.io/ https://dbeaver.io/ Maybe give it a try?
- kkarakk 8y ago
  Dbeaver just has one glaring issue in my mind -it has a VERY slow pace of development and issue managment. They had something like 900 issues open on their github the last time i saw it with around 200 of them having no replies at all. I was trying it out for sql server though so i don't know if it does better or not for postgres
  - throwaway333444 8y ago
    The large number of open issues is a valid complaint although that is more of an indicator of popularity. As for the pace of development I’d challenge you to name another SQL IDE that releases updates twice a month. (Note: The exception was the last release cycle which took 3 weeks rather than 2 but that was for the 6.0 release)
pjmlp 8y ago
When the new version of PgAdmin came out, I kept using the previous native version, much better than their UI reboot.
- emptyfile 8y ago

nindalf 8y ago

Quick summary of the thread for those joining us * This looks like a neat tool. Will check this out and compare it to DataGrip, Dbeaver etc. * It's electron. This is terrible. * There's analytics code in there. This is terrible.

switch007 8y ago
Azure Data Studio also stores your credentials in plaintext if you tick 'Remember' (on Linux at least – it does not use the system keychains)
- vetinari 8y ago
  It also supports GSSAPI out of the box, unlike java-based alternatives (at least under linux, where java doesn't support ccache other than FILE, and under macos, where java needs monkeying with java.login.config).
- SamuelAdams 8y ago
  Please report an issue here: https://github.com/Microsoft/azuredatastudio/issues https://github.com/Microsoft/azuredatastudio/issues
  - switch007 8y ago
    There is one already — as a feature request to implement keychains.
- datavirtue 8y ago
  In secure home directory.
GordonS 8y ago
> There's analytics code in there. This is terrible Sorry, this is another point I disagree with. As a developer I can appreciate the need to understand how an application is used, and to get diagnostic data when things go wrong. What is terrible is when you can't opt-out of telemetry, and when what is sent is completely opaque - that's not the case here.

radiKal07 8y ago

This looks nice but as I expected it's built with Electron. I personally use https://tableplus.io/ https://tableplus.io/ . It's native and has great UI and features.

sydd 8y ago
For me DataGrip. How do these 2 compare to it?
- philliphaydon 8y ago
  Table plus appears to me MAC only. A shame. But I’m happy with datagrip.
  - bbernoulli 8y ago
    It is on windows too: https://tableplus.io/windows https://tableplus.io/windows
    - philliphaydon 8y ago
      Oh cool. I couldn’t find that link on my phone and all I saw was OS X download and screen shots so I assumed OS X only. I’ll give it a go tomorrow. Thanks.
- h1d 8y ago
  You can easily tell if you just give TablePlus a try with its demo. Starts up very quickly, doesn't have bunch of options and stuff but I think it has enough to be far more intuitive. I'd say the interface is almost comparable to SequelPro just not as polished. (Font sizing, space padding and column sizing. Small stuff but it does feel awkward to me.)
walterstucco 8y ago
Some small difference Tableplus is - not cross platform - not open source - not free

aeroaks 8y ago

I thought DBeaver is also there!

anewhnaccount2 8y ago

From the license, this is "shared source" not OSI open source: https://github.com/Microsoft/azuredatastudio/blob/master/LICENSE.txt https://github.com/Microsoft/azuredatastudio/blob/master/LIC...

kevcunnane 8y ago
The PostgreSQL extension is fully MIT licensed: https://github.com/Microsoft/azuredatastudio-postgresql/blob/master/LICENSE https://github.com/Microsoft/azuredatastudio-postgresql/blob... and https://github.com/Microsoft/pgtoolsservice/blob/master/License.txt https://github.com/Microsoft/pgtoolsservice/blob/master/Lice... for the backing service.

pella 8y ago

I hope someday they will support PostGIS geometry viewer - like: http://www.bostongis.com/blog/index.php?/archives/272-pgAdmin4-now-offers-PostGIS-geometry-viewer.html http://www.bostongis.com/blog/index.php?/archives/272-pgAdmi...

fredley 8y ago

I use Azure Data Studio for SQL Server already and it's fantastic. Super lightweight, fast, and a really well-thought-through interface. It's honestly the SQL administration app that I prefer out of all that I've used, free or otherwise, and I'm very happy MS are taking it to more backends.

drewda 8y ago

I've recently been having good luck with this VS Code extension that adds a Postgres tab for exploring schemas and running queries: https://marketplace.visualstudio.com/items?itemName=ckolkman.vscode-postgres https://marketplace.visualstudio.com/items?itemName=ckolkman...

b0bby_tabl3s 8y ago

I love Azure Data Studio. I can bang out SQL, Powershell, and Bash all from a single entry point. Good stuff.

bmaupin 8y ago

The title was a bit misleading for me, giving me the impression that Azure Data Studio is a new tool specifically for Postgres. The reality seems to be that Azure Data Studio is an existing tool which already supports MS SQL databases, and preview support for Postgres has been added. Which makes more sense to me than Microsoft creating a new tool just for Postgres.

marcus_holmes 8y ago

Looked really interesting. I'm working on a SQL-intensive project using Postgres at the moment, and a better way of editing the numerous scripts would be great. Downloaded it, got it connected to my localhost Postgres server. Opened a script file, nice syntax highlighting, yay :) Syntax error at or near "drop". Oh dear. Ah well, back to Code and psql it is...

envoked 8y ago

I’ve been using Postico (https://eggerapps.at/postico https://eggerapps.at/postico) on OSX for the last few years and been enjoying it: clean look, ability to edit and explore schemas, ability to export results to a variety of formats (JSON, CSV, etc.), and good cadence with releases. The main thing it can’t do well is export/import large databases but that’s what ‘pg_dump’ and friends are for.

minhajuddin 8y ago

For vim users, there is an awesome plugin to talk to postgres and a ton of other databases called dbext.vim https://github.com/vim-scripts/dbext.vim https://github.com/vim-scripts/dbext.vim Setting it up takes a little effort though.

yellowapple 8y ago

I've been using ADS for a couple months now at work (since we've switched to a new warehouse management system that uses SQL Server for its database) and it's been pretty great as a cross-platform replacement for SSMS. The built-in support for CSV and JSON dumps has been incredibly handy, too. It's both among the few Electron (I think?) apps I like and among the few Microsoft products I like. Being able to use the same tool for Postgres would be awesome (we use both Postgres and Redshift here, too); I've long felt that SQL Server's a god-awful DB with awesome tooling while PostgreSQL's an awesome DB with god-awful tooling, and now I'm looking forward to finally getting the best of both worlds. I wonder if it's possible to create extensions for arbitrary ODBC and/or JDBC connections? If so, then that'd be yet another thing I could manipulate with ADS (our ERP exposes its database via a presumably-proprietary DB protocol for which they provide their own ODBC and JDBC connectors). It'd be awesome to have a properly-good one-stop shop for all my SQL-finagling needs. Now if only I could integrate all this with Emacs somehow... EDIT: alas, it does not seem to want to install correctly on Slackware, whether via ADS' extensions manager or by manually downloading/installing the VSIX package. Seems to hang on "Starting pgsql service", and any attempt to actually do anything throws a giant "Provider doesn't exist. id: PGSQL" error (and attempting to run queries anyway just throws "Error: No Handler Registered").