Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
anakic
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
14 ms
·
91.
▲
by
anakic
10y ago
Thank you for buying it!!
92.
▲
by
anakic
10y ago
I had the same problem. Transitioning from having built the thing to asking people to pay for it felt quite awkward at first. I feel a lot less awkward about it now that I do have paying customers who are happy with it and use it daily. It
93.
▲
by
anakic
10y ago
Well, some things you certainly could, but this really opens up many more possibilities than is obvious at first glance. Another big thing is convenience, which is along the lines of what you said. Single click to open query editor, full au
94.
▲
by
anakic
10y ago
Yeah, 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, e.g. hosting SQLite. It's too bad because it l
95.
▲
by
anakic
10y ago
Glad 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 (visual studio tools for office runtime). - .NET 4.5 c
96.
▲
by
anakic
10y ago
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 mentioning it just in case you
97.
▲
by
anakic
10y ago
Yeah, something like that might be the way to do it. Cut off old licenses from new versions but leave it functioning indefinitely with old versions. Offer a paid upgrade option. I think I like that option.
98.
▲
by
anakic
10y ago
Seems to work fine for me. Hopefully it was just a glitch.
99.
▲
by
anakic
10y ago
Exactly, you can really go to town on your data, get nasty with it:) I love regex myself, I feel like a ninja using them:) The replacex function was one of the first ones I implemented. Regex_split is the latest one and I love it (the singl
100.
▲
by
anakic
10y ago
Thanks, your comment made me smile:)
101.
▲
by
anakic
10y ago
Thanks for your purchase!:) I'm really glad you like it. One thing to note - since the db engine is running in the same process as Excel it can interact with it. There are some nice things it can do because of this, for instance, SQL-b
102.
▲
by
anakic
10y ago
Absolutely. I actually built a reusable infrastructure of my own. It was technically very cool to work on, and at the time I still hadn't yet made the mental shift of buying services that weren't my core domain. The infrastructure
103.
▲
by
anakic
10y ago
Hi patates. I get your point. As a user, I'd want that too. I had previously priced the professional license at $149 as a one-off price, but then noticed companies were buying those instead of the enterprise ones, and getting unlimited
104.
▲
by
anakic
10y ago
Is anyone having installation issues? I'm showing strange things in logs. I can see downloads, but my licensing service does not seem to be issuing the free licenses.
105.
▲
by
anakic
10y ago
Thanks for the heads up (fixed it) and the kind words!
106.
▲
by
anakic
10y ago
I've posted about this about six months ago, the original post ( https://news.ycombinator.com/item?id=11583488 ) was fairly well received, and I thought I'd follow up. Back then the plugin was called ThingieQuery, w
107.
▲
Show HN: QueryStorm – A query IDE inside Excel
(querystorm.com)
130 points
by
anakic
10y ago
|
64 comments
108.
▲
A .NET library for better application state management
(github.com)
2 points
by
anakic
10y ago
|
0 comments
109.
▲
by
anakic
10y ago
Thank you, all very good points.
110.
▲
by
anakic
10y ago
Any chance you could send me your contact info?
111.
▲
by
anakic
10y ago
That sounds awesome! Send me some contact info and I'll get in touch!
112.
▲
by
anakic
10y ago
And you made my day:)
113.
▲
by
anakic
10y ago
Well it was fun, I felt it was the type of tool I would want for my self in Excel. Also, not liking ones regular job goes a long way to fuel enthusiasm for hobby projects:) And it did hit the front page when /u/petepete crossposte
114.
▲
by
anakic
10y ago
Thanks! 1 - much debate about this, it's certainly safer to do so 2 - if you take a look at the license again you'll notice the digital signature field, to make a generator you would need my private key:P Boat is good, I like boat
115.
▲
by
anakic
10y ago
They're good for aggregating data, but they're not designed for precise querying, manipulating and cleaning data. If they were, we'd likely see powerpivot replacing sql server management studio:)
116.
▲
by
anakic
10y ago
If you connect using a SQL Server instance yes, with the built in database - no, SQLite doesn't have them yet. I've added some of my own functions to the SQLite engine though, e.g. ElementAt(pos, elements, orderElements) will retu
117.
▲
by
anakic
10y ago
Would have to think about it, I think I'd say yes to re-selling, not sure about white labeling though, to be successful with it I need to build the brand. Too late here to say anything more, barely awake at the moment:)
118.
▲
by
anakic
10y ago
Doesn't support it yet, did not think to use it for directory services, that's an excellent idea! PowerQuery can query ad already though but still, it's worth investigating. Thanks for the tip.
119.
▲
by
anakic
10y ago
Thank you, that's the plan! And hopefully to earn a decent living while I'm at it:)
120.
▲
by
anakic
10y ago
Any idea what the tool is called? Can't seem to find it on their website
More ›