SQL Operations Studio

#1

Post by rahulshiv » Thu, Nov 16, 2017, 10:13 PM UTC

SQL Operations Studio
github.com

Re: SQL Operations Studio

#2

Post by GFischer » Thu, Nov 16, 2017, 10:51 PM UTC

Would this be the "Visual Studio Code" to the SQL Server Management Studio?

No mention of CosmosDB (I want some kind of SSMS equivalent for CosmosDB).

Re: SQL Operations Studio

#3

Post by ah- » Thu, Nov 16, 2017, 11:18 PM UTC

GFischer wrote: post #2

Would this be the "Visual Studio Code" to the SQL Server Management Studio? No mention of CosmosDB (I want some kind of SSMS equivalent for CosmosDB).

I think there's a VS Code plugin for CosmosDB.

Re: SQL Operations Studio

#4

Post by jacquesc » Thu, Nov 16, 2017, 11:22 PM UTC

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

Re: SQL Operations Studio

#5

Post by johnnyb9 » Thu, Nov 16, 2017, 11:26 PM UTC

With minimal effort this may prove better than SSMS.

Re: SQL Operations Studio

#6

Post by jflowers45 » Thu, Nov 16, 2017, 11:38 PM UTC

I wonder what SSMS can do that this can't? SSMS is not cross platform as far as I know, whereas this is. Would be nice if they elaborated on the differences and pros/cons.

Re: SQL Operations Studio

#7

Post by sixdimensional » Thu, Nov 16, 2017, 11:40 PM UTC

I guess it's a good thing I didn't do the project I was thinking about. I observed the fact that SQL Server had no management tool that was cross-platform, and thought perhaps I would build such a thing. Nice work Microsoft!

On a side-note, I'd love to see an even more minimalist stripped-down, read-mostly query/tabular result only (with pivot tables) tool, which had some local columnar storage caching/query engine, and simple import/export to common file formats as well. A simple "SQL notebook" that was cross platform, if you will, but worked more like a traditional query tool. And not embedded in MS Excel, like PowerQuery or PowerPivot (although it's powerful!).

Something lighter weight than BI tools such as Power BI, Tableau, Qlik, etc., definitely lighter weight than tools such as SSMS, DBeaver, SQuirrel, etc. - not for administrative use. I've seen a few applications that are coming close listed on HN lately, but would be nice to have something as pretty as this and which is open source.

Perhaps a fork with the admin features stripped out, some additional plumbing added, and read-only connections, I'm not sure.

Will have to think about it. Main use case is data scientists / data analysts / SQL power users.

Re: SQL Operations Studio

#8

Post by chungy » Thu, Nov 16, 2017, 11:40 PM UTC

Unfortunate license, you can't redistribute it, verbatim or otherwise.

Re: SQL Operations Studio

#9

Post by jensvdh » Fri, Nov 17, 2017, 12:08 AM UTC

No Support for SQLite?

Re: SQL Operations Studio

#10

Post by eat_veggies » Fri, Nov 17, 2017, 12:09 AM UTC

how does this compare with datagrip?

https://www.jetbrains.com/datagrip/