TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

SQL Operations Studio

299 pointsby rahulshivover 7 years ago

19 comments

scrollawayover 7 years ago
Oh please please please postgres support! The only free+open source option for Linux is Sqlectron (<a href="https:&#x2F;&#x2F;github.com&#x2F;sqlectron&#x2F;sqlectron-gui" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;sqlectron&#x2F;sqlectron-gui</a>) which has massive performance issues.<p>I badly want an alternative to DataGrip. It&#x27;s great, but it&#x27;s not free and its open source license criteria are frankly ridiculous [<a href="https:&#x2F;&#x2F;www.jetbrains.com&#x2F;buy&#x2F;opensource&#x2F;?product=datagrip" rel="nofollow">https:&#x2F;&#x2F;www.jetbrains.com&#x2F;buy&#x2F;opensource&#x2F;?product=datagrip</a>]:<p>&gt;&gt; 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.
评论 #15721338 未加载
评论 #15720987 未加载
sixdimensionalover 7 years ago
I guess it&#x27;s a good thing I didn&#x27;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!<p>On a side-note, I&#x27;d love to see an even more minimalist stripped-down, read-mostly query&#x2F;tabular result only (with pivot tables) tool, which had some local columnar storage caching&#x2F;query engine, and simple import&#x2F;export to common file formats as well. A simple &quot;SQL notebook&quot; that was cross platform, if you will, but worked more like a traditional query tool. And not embedded in MS Excel, like PowerQuery or PowerPivot (although it&#x27;s powerful!).<p>Something lighter weight than BI tools such as Power BI, Tableau, Qlik, etc., definitely lighter weight than tools such as SSMS, DBeaver, SQuirrel, etc. - not for administrative use. I&#x27;ve seen a few applications that are coming close listed on HN lately, but would be nice to have something as pretty as this and which is open source.<p>Perhaps a fork with the admin features stripped out, some additional plumbing added, and read-only connections, I&#x27;m not sure.<p>Will have to think about it. Main use case is data scientists &#x2F; data analysts &#x2F; SQL power users.
评论 #15718312 未加载
评论 #15720037 未加载
评论 #15718415 未加载
评论 #15717899 未加载
评论 #15719820 未加载
评论 #15718093 未加载
userbinatorover 7 years ago
In case you&#x27;re wondering, or just want to confirm the reason for the presence of a &quot;privacy statement&quot; --- yes, it does phone home:<p><a href="https:&#x2F;&#x2F;github.com&#x2F;Microsoft&#x2F;sqlopsstudio&#x2F;tree&#x2F;master&#x2F;src&#x2F;vs&#x2F;platform&#x2F;telemetry" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;Microsoft&#x2F;sqlopsstudio&#x2F;tree&#x2F;master&#x2F;src&#x2F;vs...</a><p>At least the source is available, so it should be relatively easy to remove, but as the saying goes, &quot;look before you leap&quot;...
评论 #15722816 未加载
评论 #15722284 未加载
评论 #15738627 未加载
jacquescover 7 years ago
No Postgres support yet. Looks like a great app though. <a href="https:&#x2F;&#x2F;github.com&#x2F;Microsoft&#x2F;sqlopsstudio&#x2F;issues&#x2F;56" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;Microsoft&#x2F;sqlopsstudio&#x2F;issues&#x2F;56</a>
评论 #15718090 未加载
评论 #15718304 未加载
评论 #15718237 未加载
jflowers45over 7 years ago
I wonder what SSMS can do that this can&#x27;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&#x2F;cons.
评论 #15718288 未加载
评论 #15722358 未加载
评论 #15717983 未加载
评论 #15726527 未加载
评论 #15720797 未加载
darklajidover 7 years ago
Currently extracting the 16819 files in the archive.. ;-)<p>That said, the screenshots look decent and I&#x27;ve been looking for an alternative to the SQL Server Management Studio a couple times already. So I already applaud the effort.
评论 #15718613 未加载
GFischerover 7 years ago
Would this be the &quot;Visual Studio Code&quot; to the SQL Server Management Studio?<p>No mention of CosmosDB (I want some kind of SSMS equivalent for CosmosDB).
评论 #15805855 未加载
评论 #15718645 未加载
评论 #15717594 未加载
评论 #15725389 未加载
chungyover 7 years ago
Unfortunate license, you can&#x27;t redistribute it, verbatim or otherwise.
评论 #15718280 未加载
评论 #15717947 未加载
genieycloover 7 years ago
This is a good time to ask: is there any good SQL IDE for Oracle better than SQL Developer?
评论 #15718784 未加载
评论 #15718361 未加载
评论 #15718679 未加载
评论 #15720942 未加载
评论 #15718351 未加载
评论 #15722300 未加载
eat_veggiesover 7 years ago
how does this compare with datagrip?<p><a href="https:&#x2F;&#x2F;www.jetbrains.com&#x2F;datagrip&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.jetbrains.com&#x2F;datagrip&#x2F;</a>
评论 #15717942 未加载
halfnibbleover 7 years ago
Where was this last month when I was at a Microsoft Hackathon with my Macbook Pro trying to browser MS SQL hosted on Azure?
johnhenryover 7 years ago
An overview would be awesome: <a href="https:&#x2F;&#x2F;docs.microsoft.com&#x2F;en-us&#x2F;sql&#x2F;sql-operations-studio&#x2F;what-is" rel="nofollow">https:&#x2F;&#x2F;docs.microsoft.com&#x2F;en-us&#x2F;sql&#x2F;sql-operations-studio&#x2F;w...</a>
nbevansover 7 years ago
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.
评论 #15723130 未加载
arjover 7 years ago
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?
anon335dtzbvcover 7 years ago
Be aware of the non free license
johnnyb9over 7 years ago
With minimal effort this may prove better than SSMS.
jensvdhover 7 years ago
No Support for SQLite?
评论 #15718083 未加载
partycoderover 7 years ago
DataGrip from Jetbrains is good for SQL stuff.
flukusover 7 years ago
Finally, DBA&#x27;s can experience the &quot;wonders&quot; of electron too.<p>When you accidentally select * and get 100,000 items back how does the non-native table view hold up?
评论 #15718500 未加载
评论 #15718261 未加载
评论 #15718086 未加载