QueryStorm
Dev tools
sql ide for excel
SHOW HN2016
130points
64comments
#274of 2,264 in 2016
Top 13%of 2016 by points
How HN took it
MixedNo clear lean
8 positive, 11 neutral or asking, 4 mixed, 5 critical, out of 28 comments about the project. Thread score +0.07.
Pricing: 3 for, 2 againstIdea: 2 for, 2 againstExecution: 1 for, 1 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Useful for querying Excel tables with SQL and regex.
From 3 comments
I'll be honest, I didn't read the full feature list. I looked at some of the quick queries and was really happy to see some of them. Yeah, the amount of intellectual violence…
HCIdivision17 on HNWith the coupon code in this thread, I was willing to go in on it, because it's comparable to what I pay for SSMS Tools. It's really really handy to be able to query an Excel…
HCIdivision17 on HNI bought this last time it was posted here, back when it was ThingieQuery. It's been super useful to me. Definitely recommend trying it out, it's basically a SQL IDE within…
PeCaN on HN
Objections
Subscription pricing is too high or unsuitable compared with one-time purchase.
From 4 comments
Hi, this is great. I'd gladly pay $99 for having such a convenient helper. However, I'm sad to see it's a temporary license. This is not SaaS, but priced like one. Can't you make…
patates on HNWith the coupon code in this thread, I was willing to go in on it, because it's comparable to what I pay for SSMS Tools. It's really really handy to be able to query an Excel…
HCIdivision17 on HNI have to agree, that the SaaS pricing model is a something that kills this for my company. I have no problem with you doing a phone home to verify installation, etc... Until…
Meph504 on HNGiven that MS Office is priced at $99 per year, your pricing seems very high.
echoofecho on HN
Microsoft could build similar features into Excel.
From 2 comments
I guess that's one problem you have to worry about now. Microsoft is bound to incorporate something like this into Excel sooner or later. :(
devoply on HNLooks great but I would guess all this functionality is already built into excel somewhere. You just have to be ninja enough to find it.
Too on HN
Requests
Offer a one-time purchase license option.
From 2 comments
With the coupon code in this thread, I was willing to go in on it, because it's comparable to what I pay for SSMS Tools. It's really really handy to be able to query an Excel…
HCIdivision17 on HNHi, this is great. I'd gladly pay $99 for having such a convenient helper. However, I'm sad to see it's a temporary license. This is not SaaS, but priced like one. Can't you make…
patates on HN
Support for Office Apps and Mac.
From 2 comments
Honestly I haven't tried Office Apps, it just seemd like it would be tricky and I didn't have time to investigate. I can see how the local web server hack might work, though.…
anakic on HNYeah, the .NET one - VSTO, visual studio tools for office. Haven't played around much with the web one. Most things QueryStorm does wouldn't be possible in the office apps model,…
anakic on HN
Questions
Whether a per-user install works on a shared Windows VM without admin rights.
From 2 comments
Awesome! I work in Excel on a shared Windows server VM. Is it possible to install an add-in like this for one user, or will everyone using Excel on this VM see the add-in?…
_raoulcousins on HNGlad you like it!:) It's a per-user installer, so only you would see it. It shouldn't require admin privileges unless a prerequisite is missing. It requires .NET 4.5 and vstor…
anakic on HN
Alternatives named
Pathio for Excel source control.
From 1 comment
About source control in Excel, there's a London based company offering a product along those lines called Pathio (https://www.pathio.com/). I know it's not open source, but I'm…
anakic on HN
PowerPivot with SQL Server Analysis Services.
From 1 comment
>> a pivot table that can work on a relational dataset in a SQL server, without downloading the whole table as a join as a first step. You can do that with PowerPivot + SQL…
anakic on HN