2 ms·
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 b
by 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").