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

71–80 of 96 posts

Re: SQL Operations Studio

#71

Post by wluu »

lowkeyokay wrote: post #55
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,…

As for cross-platform, VS Code has a plugin for SQL Server. It doesn't provide all the graphical management tools that SSMS does but all the stored procedures are available, naturally. If you're on a Mac, i suggest [1] Hankinsoft's SQL Studio. I've been using it daily for a couple of years. It's very light weight and supports most db's. It has some neat functions too; like marking rows and columns, right click and ge…

The VS Code plugin and SQL Operations Studio both use the SQL Tools API Service[1].

[1] https://github.com/Microsoft/sqltoolsservice

Re: SQL Operations Studio

#72

Post by nbevans »

This looks like SQL Server Management Studio will be deprecated once this project reaches a v1.0. About time too - as SSMS barely supports SQL Azure at all; pretty much all the useful GUI screens are not available.

Re: SQL Operations Studio

#73

Post by frik »

breakingcups wrote: post #70
frik wrote: post #48

Earlier quoted context omitted.

Good to know. Will move to Percona or MySQL.

That seems like a very short-sighted, if not childish, statement.

What? My decision is based on years of observation. I applauded MariaDB at first, but they almost went bankrupt, merged with another company, changed he business model (release new code parts in a different license). And on the other side I still remember Cyanogen + CyanogenMOD that got so much worse and died because of a certain "sponsor". https://en.m.wikipedia.org/wiki/CyanogenMod nowadays forked as LineageOS, but many things got lost incl older devices. So a small number of companies with deep pockets are like cancer to open source projects, the good thing is they can be forked. But see MaxDB for an open source database that never got forked, and there is no open source project anymore, it got closed source, and nowadays powers parts of expensive SAP HANA data store. It is better to install Percona MySQL fork, or MySQL community edition.

Re: SQL Operations Studio

#74

Post by mnx »

scrollaway wrote: post #68
mnx wrote: post #63

Earlier quoted context omitted.

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

I get your point, but also... You are complaining that they are not willing to give their work away, unless you are willing to give your work away.

Re: SQL Operations Studio

#75

Post by pritambaral »

revelation wrote: post #24
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?

Have you seen pgAdmin III? You are not doing any sort of action in that tool within 30 seconds. Worst of all, it's pre-Electron terrible, where they run a local webserver that is probably leaking your database secrets to every local app.

Do you mean, perhaps, pgAdmin4? What you said is consistent with pgAdmin4, but not with pgAdmin3

Re: SQL Operations Studio

#76

Post by scrollaway »

mnx wrote: post #74
scrollaway wrote: post #68

Earlier quoted context omitted.

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

I get your point, but also... You are complaining that they are not willing to give their work away, unless you are willing to give your work away.

But it's not symmetrical like that: DataGrip isn't open source.

It's not so much a complaint (they're within their rights), I just find it uneasy to ask people to forego revenue. I feel it sends the wrong message and promotes the wrong mindset.

Re: SQL Operations Studio

#77

Post by icc97 »

userbinator wrote: post #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"...

Looks like it's opt-in [0]

[0]: https://github.com/Microsoft/sqlopsstudio/blob/6e05dd7fa13d2...

Re: SQL Operations Studio

#79

Post by ElatedOwl »

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.

On my first cursory glance: no table designer, no execute stored procedure GUI

There's a lot of little things I wish SSMS had/did (like inline text search for sproc/table) and was hoping this would have it. The execution plan screen (explain in this IDE) is a lot cleaner, though.

Re: SQL Operations Studio

#80

Post by mirimir »

userbinator wrote: post #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"...

Microsoft spying is such a trope. So why do they just keep piling it deeper? Do they think that their users are stupid?
Post reply on HN