Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

SQL Operations Studio

github.com

Post reply on HN
Print view View original

11–20 of 96 posts

Re: SQL Operations Studio

#11

Post by cbcoutinho »

sixdimensional wrote: post #7

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,…

I'm also looking for a tool like this. I think plot.ly's new Falcon tool comes close to barebones sql + plotting. [0]

I love reading blog posts on small projects hooking up sql and simple data analysis - check out this small Flask/sql/d3 app I found earlier [1]. I'm not sure how closer a stripped down product can come to something like this. I guess you could wrap everything into an electron app, but maybe I think it would then be overkill for what I've been looking for.

[0]: https://plot.ly/free-sql-client-download/

[1]: http://www.datasciencebytes.com/bytes/2015/03/07/a-d3js-plot...

Re: SQL Operations Studio

#12

Post by flukus »

Finally, DBA's can experience the "wonders" of electron too.

When you accidentally select * and get 100,000 items back how does the non-native table view hold up?

Re: SQL Operations Studio

#13

Post by giancarlostoro »

eat_veggies wrote: post #10

how does this compare with datagrip? https://www.jetbrains.com/datagrip/

This one's directed at Microsoft SQL offerings, including the ones in the Azure cloud. Whereas DataGrip is for most SQL databases. Also this one's free, and DataGrip isn't (almost a shame but it's worth it's salt). DataGrip definitely is more featureful since it's been around a bit longer. Funnily enough the one Microsoft made looks like it derives from Visual Studio Code, much like MSSQL Management Studio derives from regular Visual Studio, and I think that'll mean Microsoft might embed some features from this into Visual Studio Code, but that's me just speculating, and it could take a while before they do.

Re: SQL Operations Studio

#14

Post by giancarlostoro »

chungy wrote: post #8

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

Hopefully that changes, it would become a really great cross platform SQL toolset, especially if and when they add in support for other SQL databases. Might be focused for Azure / MSSQL like Azure Storage Explorer is for Azure Blob Storage only (not sure what else it would support really).

Re: SQL Operations Studio

#15

Post by neves »

jflowers45 wrote: post #6

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.

I also would like to know. I use Management studio at work. It would be great to find a good multiplataform that I can use everywhere.

Re: SQL Operations Studio

#16

Post by megaman22 »

giancarlostoro wrote: post #13
eat_veggies wrote: post #10

how does this compare with datagrip? https://www.jetbrains.com/datagrip/

This one's directed at Microsoft SQL offerings, including the ones in the Azure cloud. Whereas DataGrip is for most SQL databases. Also this one's free, and DataGrip isn't (almost a shame but it's worth it's salt). DataGrip definitely is more featureful since it's been around a bit longer. Funnily enough the one Microsoft made looks like it derives from Visual Studio Code, much like MSSQL Management Studio derives fr…

It'd be nice if SQL Management Studio and Visual Studio from the same generations were based upon the same platform, although I can understand why that's difficult and why SQLMS lags behind. I did get a little sick of having VS 2010 components kicking around for years after I'd moved on.

Re: SQL Operations Studio

#18

Post by SigmundA »

flukus wrote: post #12

Finally, DBA's can experience the "wonders" of electron too. When you accidentally select * and get 100,000 items back how does the non-native table view hold up?

Hopefully they use a virtualized grid, which there are more than one js ones to choose from that have no problem with 100,000 rows.

Re: SQL Operations Studio

#20

Post by rahilsondhi »

sixdimensional wrote: post #7

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,…

Excuse me for my second plug this week, but we've built almost exactly what you're describing over at PopSQL (https://popsql.io).
Post reply on HN