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

21–30 of 96 posts

Re: SQL Operations Studio

#21

Post by userbinator »

jacquesc wrote: post #4

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

You're kidding, right?

This is a Microsoft product. Microsoft have their own database. What value is it to them to help people continue using competitor's products?

Besides, it's not like Postgres doesn't have plenty of GUI tools already:

https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...

Re: SQL Operations Studio

#23

Post by dfox »

SigmundA wrote: post #18
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.

I don't think that virtualized grid is an good idea for something that is primarily meant as GUI for SQL database that implicitly exposes the SQL to user.

Re: SQL Operations Studio

#24

Post by revelation »

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.

Re: SQL Operations Studio

#25

Post by hobs »

userbinator wrote: post #21
jacquesc wrote: post #4

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

You're kidding, right? This is a Microsoft product. Microsoft have their own database. What value is it to them to help people continue using competitor's products? Besides, it's not like Postgres doesn't have plenty of GUI tools already: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...

I was actually in the room listening as the question came up to the team that makes this tool, its not off the table at all.

The value to them is Azure, which hosts open source databases, why not give your customers the decent tooling at the same time?

You'll even find things in the tool that reference non-Microsoft language, eg the button generally labeled "Estimated Execution Plan" in SQL Server Management Studio is labeled "Explain".

The methodology behind the plugin absolutely allows abstracting out the MSSQL specific components, its just an open source fork of VS Code.

Re: SQL Operations Studio

#27

Post by kthejoker2 »

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.

Ssms has menus and GUIs and such for all the non database SQL Server items like SSIS, SSAS (full cube browser), SQL agent, CLR, plus creating more advanced objects like Credentials and application roles and scenarios like suggesting indexes and performing DB maintenance.

This is purely a database development tool, at least in its current form.

Re: SQL Operations Studio

#29

Post by pkaye »

userbinator wrote: post #21
jacquesc wrote: post #4

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

You're kidding, right? This is a Microsoft product. Microsoft have their own database. What value is it to them to help people continue using competitor's products? Besides, it's not like Postgres doesn't have plenty of GUI tools already: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...

Well Microsoft does offer PostgreSQL on Azure from what I can tell... https://azure.microsoft.com/en-us/services/postgresql/

Re: SQL Operations Studio

#30

Post by j_s »

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

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)

Post reply on HN