Live data from Hacker News

SQL Operations Studio

github.com

61–70 of 96 posts

Re: SQL Operations Studio

#61
post #53

Earlier quoted context omitted.

Why on earth would it be dreadful on a SATA SSD? Does it really matter if it takes 15 seconds vs 18 seconds?

Don't get it either. Took at most a minute here on my non-SSD laptop.

Maybe something else was going on with my laptop, but it took several minutes for me.

Was using a few instances of Visual Studio 2017, but I don't think they were going flat out.

Re: SQL Operations Studio

#63

Oh please please please postgres support! The only free+open source option for Linux is Sqlectron ( https://github.com/sqlectron/sqlectron-gui ) which has massive performance issues. I badly want an alternative to DataGrip. It's great, but it's not free and its open source license criteria are frankly ridiculous [ https://www.jetbrains.com/buy/opensource/?product=datagrip ]: >> Your OS project may not offer paid spon…

Well, basically they only want to give it away for free, if you actually cannot pay for it. That seems reasonable. But I agree, an OS alternative would be great, and this seems like it could be it.

Re: SQL Operations Studio

#64

Earlier quoted context omitted.

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.

I am wondering if the long-term solution is going to be that SQL Management Studio goes away, in favor of SQL Operations Studio and possibly some other graphical tools for more specialized things like data warehousing etc. The more good next-generation cross-platform tooling that MS roll out, the more it sort of grates to have to flip back into a Windows system for that one specific thing.

Re: SQL Operations Studio

#65
In case you're wondering, or just want to confirm the reason for the presence of a "privacy statement" --- yes, it does phone home:

https://github.com/Microsoft/sqlopsstudio/tree/master/src/vs...

At least the source is available, so it should be relatively easy to remove, but as the saying goes, "look before you leap"...

Re: SQL Operations Studio

#66

Oh please please please postgres support! The only free+open source option for Linux is Sqlectron ( https://github.com/sqlectron/sqlectron-gui ) which has massive performance issues. I badly want an alternative to DataGrip. It's great, but it's not free and its open source license criteria are frankly ridiculous [ https://www.jetbrains.com/buy/opensource/?product=datagrip ]: >> Your OS project may not offer paid spon…

What about DBeaver? I use it all the time in Fedora to manage SQL Server and other DB's. https://en.m.wikipedia.org/wiki/DBeaver

Re: SQL Operations Studio

#67
post #30

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

These discussions have some options: Google Data Studio | https://news.ycombinator.com/item?id=15446049 (Oct 2017, 228 comments) PopSQL – Modern, collaborative SQL editor for your team | https://news.ycombinator.com/item?id=15377339 (Oct 2017, 49 comments) Franchise – An Open-Source SQL Notebook | https://news.ycombinator.com/item?id=15303833 (Sep 2017, 63 comments)

DBeaver... https://en.m.wikipedia.org/wiki/DBeaver

Re: SQL Operations Studio

#68
post #63

Oh please please please postgres support! The only free+open source option for Linux is Sqlectron ( https://github.com/sqlectron/sqlectron-gui ) which has massive performance issues. I badly want an alternative to DataGrip. It's great, but it's not free and its open source license criteria are frankly ridiculous [ https://www.jetbrains.com/buy/opensource/?product=datagrip ]: >> Your OS project may not offer paid spon…

Well, basically they only want to give it away for free, if you actually cannot pay for it. That seems reasonable. But I agree, an OS alternative would be great, and this seems like it could be it.

Yeah, I understand the logic behind the licensing.

However, under the guise of promoting open source, what this actually does is it promotes giving your work away for free and discourages making money with open source products.

As a huge proponent of open source myself, I have no problem with projects that are open source and make money; anything that isn't "hobbyist level" should be able to make money, and if you want to make money your mindset shouldn't fall back on going closed source.

Huge shout out to Sentry in that matter: They are open source, and if you're open source they service you for free. https://sentry.io/for/open-source/ -- Comparatively, DataGrip is closed source, and they only give you a free license if you can't make money. Very different mindset...

Re: SQL Operations Studio

#69
post #15

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.

I use DBeaver for cross platform support of SQL Servr at work. Obvious missing things like Query Plan support and all the newer goodies. For basic query design and ad hoc work it's great.
Post reply on HN