SQL Operations Studio
github.com
github.com
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.
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...
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.
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, and simple import/export to common file formats as well. A simple "SQL notebook" 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's powerful!).
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'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.
Perhaps a fork with the admin features stripped out, some additional plumbing added, and read-only connections, I'm not sure.
Will have to think about it. Main use case is data scientists / data analysts / SQL power users.
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)
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.
I love reading blog posts on small projects hooking up sql and simple data analysis - check out this small Flask/sql/d3 app I found earlier [1]. I'm not sure how closer a stripped down product can come to something like this. I guess you could wrap everything into an electron app, but maybe I think it would then be overkill for what I've been looking for.
[0]: https://plot.ly/free-sql-client-download/
[1]: http://www.datasciencebytes.com/bytes/2015/03/07/a-d3js-plot...
I guess I'm saying, partially it's the packaging for end users who want to run independently like a standalone application which is the issue.
But yes, Metabase is great and the team working on it is doing a great job.
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"...
[0]: https://github.com/Microsoft/sqlopsstudio/blob/6e05dd7fa13d2...
"telemetry.enableTelemetry": false
In Preference > Settings
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 grew up with the Microsoft you describe, but they've been gone for several years now. Not to say they can do no wrong, or that we shouldn't be wary, but to think it ridiculous that they could support multiple databases is not compatible with their actions lately.
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.
http://www.zdnet.com/article/microsoft-nearly-one-in-three-a...
It’s Nadella Microsoft, amigo. Not saying marry them, but at least let them buy you a beer.
http://www.zdnet.com/article/microsoft-says-40-percent-of-al...
This is purely a database development tool, at least in its current form.
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.
I use a combination of SQL Hunting Dog http://sql-hunting-dog.com/ (quick search all object names) and a SQL script from the (free) SSMSBoost plugin that looks at most object definitions but not table columns unfortunately. I've used Red Gate's SQL Search in the past but it's always been slow and buggy over the VPN.
If you're looking for a better execution plan utility, check out SQL Sentry's Plan Explorer. It's free.
SQL Hunting Dog looks exactly like what I've been wanting, thanks for the recommendation!
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.
Very exciting development, looking forward to trying it out.
Was using a few instances of Visual Studio 2017, but I don't think they were going flat out.
No mention of CosmosDB (I want some kind of SSMS equivalent for CosmosDB).
But I haven't used it with CosmosDB yet.
I know a few people who just use Intellij for it.
When you accidentally select * and get 100,000 items back how does the non-native table view hold up?
2) when presenting results of user supplied SQL in this way you have to rewrite it somehow, which means that database ends up running different query than what the user entered, which is counterintuitive behavior and there certainly are cases where it is not desirable at all.
The main issue with displaying 100,000 rows in the browser is DOM overhead. A virtualized grid like Slickgrid which they are using, reuses dom elements as you scroll and in its simplest form is just backed by an in-memory JS object.
Once you start exceeding what works well in memory you can move to a local temp file system, which it sounds like what they are doing.
None of this has anything to do with the SQL server itself, it simply sends the entire result set to the client which deals with buffering and virtualizing it to the UI in whatever way necessary.
This is how native SQL UI's tend to work, I have never seen one rewrite SQL to try and virtualize all the way to the DB.
Obviously unless you do use the DB there will be limits, but 100,000 rows fits entirely in memory without issue: checkout this sample: http://mleibman.github.io/SlickGrid/examples/example-optimiz...