anakic

10 ms·

61.
by anakic 9y ago
Yeah, it was really fun to built! The parser, editor features and C# support were amazing to work on. Some times I felt like I was wasting time, but when I compare what I was working on most days in a corp to what I get to work on with Quer
62.
by anakic 9y ago
Never heard of them. I'll check 'em out, thanks!:)
63.
by anakic 9y ago
Thanks! I touch on the project a little, but the point was to stick to the story and make it enjoyable to read. I'm glad it worked:)
64.
by anakic 9y ago
Saving up for a turquoise one:) Thanks!
65.
by anakic 9y ago
Love it, haha <3
66.
by anakic 9y ago
I felt like I should keep it about the story, but yeah, maybe a picture or two would be nice. I'll see about including a gif at the beginning.
67.
by anakic 9y ago
Oh, also it's freemium. Most of the functionality is free, you just have a label saying it's "free for non-commercial use"
68.
by anakic 9y ago
Sure. With Access you'd have to first get the data into it, process it there and get it back. With QueryStorm, you just click "connect" and you get a nice SQL editor, code completion and all. Anything that's marked as a
69.
by anakic 9y ago
Yeah, I do get that comment every now and then. It was originally called ThingieQuery, but then I got people saying that they liked it but couldn't ask a manager to buy something called ThingieQuery. I didn't consciously steal the
70.
I wandered off and built an IDE(blog.querystorm.com)
1053 points by anakic 9y ago|256 comments
71.
by anakic 9y ago
I'll join in with a bit of show-and-tell of my own, if I may. I'm working on a plugin for Excel for dev's and other technical people. It lets the user use SQL and C# in Excel, connect to various types of databases and move da
72.
by anakic 9y ago
Cheers! Yep, most people can't be bothered to make their own lives easier. The algorithm is: if it involves anything unknown - bail.
73.
by anakic 9y ago
It's entirely possible. I'll have to see what kind of support Roslyn has for F#. If the support is there, it would be extremely easy to support F#. I'll look into this, thanks for the tip!
74.
by anakic 9y ago
Thanks, I really appreciate that! Glad the hours I spent preparing the videos and docs didn't go to waste:)
75.
by anakic 9y ago
Well thanks a lot:) I'd love to support Python, but for now there's not enough manpower to go into it. Glad you like the docs and videos!
76.
by anakic 9y ago
QueryStorm: optimizing the way we abuse Excel!:) Well, jokes aside, C# and .NET are a better tool, so at least its easier to make a good solution in Excel. I think Excel is an excellent platform for developer tools. E.g. if you're maki
77.
by anakic 9y ago
Yea, you could do it. In the simplest case, you could build a login form (e.g. winforms) in code in your script and use it to get the username and password from the user. In a more serious use case, you could build your login form and all t
78.
by anakic 9y ago
Yeah, Excel is crazy flexible so it's no wonder that where ever there isn't a designated application for something, people fall back to Excel. I think it's a good platform to introduce dev tools in, all those small ad-hoc use
79.
by anakic 9y ago
Whoops... Well, at least it's also going to make creating maintainable mission critical Excel based monstrosities easier:)
80.
by anakic 9y ago
Thanks for the comment! Yeah, VBA in Excel is pretty outdated in many ways, and Excel isn't going anywhere any time soon. I missed having SQL in Excel originally so that's why I started the plugin. I added C# just now, but I reall
81.
by anakic 9y ago
Yeah, VSTO is a tricky animal. I've had quite a few mysterious issues over the last few years while building this plugin. In my case though, since I'm hosting a WPF user interface in a COM application in a WinForms host, talking t
82.
by anakic 9y ago
A while ago, as a hobby and later a business, I made an Excel plugin for using SQL in Excel: https://www.querystorm.com I've now added the capability to use C# in Excel, using Roslyn. Sort of like Linqpad in Excel. This let
83.
Show HN: C# support in Excel(querystorm.com)
77 points by anakic 9y ago|34 comments
84.
by anakic 10y ago
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. Would it work in the browser and on the Mac?
85.
by anakic 10y ago
Hey, I remember your username from back then, thanks for the support!! Yeah, that was the first HN post I did. About use-cases: techy people use if for hacking away at data in Excel and import/export. Enterprises also seem to want the
86.
by anakic 10y ago
Yeah, if you can understand vlookup, you can certainly pick up sql joins fairly easily. You can do quite a lot even with basic SQL skills. Reaching business people from a marketing perspective and talking to them about SQL is a whole differ
87.
by anakic 10y ago
Nice catch!
88.
by anakic 10y ago
Well, there's producthunt, betapage etc.
89.
by anakic 10y ago
>> 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 Server Analysis Services, no? Requires SQL Server and SSAS li
90.
by anakic 10y ago
It's going slowly. For now, I make enough to cover my expenses, but I earned more as a contractor working for a corp. Some days, though, I earn way more from QueryStorm, I just have to make those days more common. People seem to like t

More ›