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

51–60 of 96 posts

Re: SQL Operations Studio

#51

Post by sixdimensional »

Osiris wrote: post #35
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,…

DataGrip by JetBrains is cross-platform and supports a large variety of database servers.

It's a nice tool, but is a full admin use case- I'm looking for a simpler query only situation. I think I tested this actually when it was codenamed 0xDBE.

Re: SQL Operations Studio

#52

Post by chrisper »

sundvor wrote: post #40
darklajid wrote: post #34

Currently extracting the 16819 files in the archive.. ;-) That said, the screenshots look decent and I've been looking for an alternative to the SQL Server Management Studio a couple times already. So I already applaud the effort.

Same here - I'm glad I have a NVME drive, dread to think about the extract on a SATA one. :D Very exciting development, looking forward to trying it out.

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

Re: SQL Operations Studio

#53

Post by rym_ »

chrisper wrote: post #52
sundvor wrote: post #40

Earlier quoted context omitted.

Same here - I'm glad I have a NVME drive, dread to think about the extract on a SATA one. :D Very exciting development, looking forward to trying it out.

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.

Re: SQL Operations Studio

#54

Post by samgaw »

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

Have you looked at Metabase? http://www.metabase.com

Re: SQL Operations Studio

#55

Post by lowkeyokay »

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 get insert statements. It's not free, but for me, it has been well worth the price.

If you want something for quick data analysis, I would suggest looking into queryStorm [2]. It was on HN's front page [3] last week, but for it's C# capabilities. It started as as SQL query tool for excel. I have yet to try it but it seems very useful and fast. Although I don't think it has any column store caching.

[1] http://www.hankinsoft.com

[2] https://querystorm.com

[3] https://news.ycombinator.com/item?id=15670030

Re: SQL Operations Studio

#56

Post by karma_fountain »

hobs wrote: post #25
userbinator wrote: post #21

Earlier quoted context omitted.

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

I implore you to do this. Every time pgadmin dies, I also die a little inside.

Re: SQL Operations Studio

#57

Post by arj »

This is actually quite decent for a first version. I can see that it has git integrated. What workflows do people use to combine git and sql?

Re: SQL Operations Studio

#59

Post by scrollaway »

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 sponsorship; receive funding from commercial companies or organizations (NGO, education, research, or governmental). You do not provide any paid support, consulting or training services for your OS project, and you do not distribute paid versions of your OS software. Contributors who are paid to work on the project are not eligible.

Post reply on HN