Hacker News

Top stories

Live mirror
30 storiesupdated just nowView source snapshot
  1. Laya the open source version of Jev(convaiinnovations.com ↗)
    119comments
  2. A graphical desktop for the ZX Spectrum(github.com/mindbox77 ↗)
    34comments
  3. Tin: full-text search for Postgres(planetscale.com ↗)
    21comments
  4. AI-generated posters don’t have to be horrible(john.hartnup.uk ↗)
    425comments
  5. Human brain is two separate organs, Stanford Medicine-led research finds(stanford.edu ↗)
    176comments
  6. Black Holes or Black Hole Stars? Astronomers Spar over 'Little Red Dots'(quantamagazine.org ↗)
    11comments
  7. “The Secret Life of Circuits” is here(coredump.cx ↗)
    48comments
  8. Android 17 is the first since 3.x to add new APIs without releasing to the AOSP(grapheneos.social ↗)
    538comments
  9. What Zig felt like, coming from Rust(besok.github.io ↗)
    92comments
  10. I built the fastest PHP webserver in the world(qbixserver.com ↗)
    13comments
  11. Asking Authors About Their Own Papers(medium.com/tmlrorg ↗)
    27comments
  12. Jobs Without LeetCode(noleet.lol ↗)
    discuss
  13. Agreement between the USA and Denmark (1951,2004) [pdf](state.gov ↗)
    1comments
  14. San Francisco Onion Futures Company(onionfutures.com ↗)
    105comments
  15. GPT-6 Astra Solves a WWI German Radio Cipher(prinzai.com ↗)
    126comments
  16. If math is more than proof, we need to better celebrate the rest of it(terrytao.wordpress.com ↗)
    185comments
  17. Learning Another Language May Be One of the Best Ways to Keep Your Brain Healthy(theconversation.com ↗)
    33comments
  18. Cloudflare Quick Tunnels(cloudflare.com ↗)
    301comments
  19. How to Write with an LLM(sockpuppet.org ↗)
    360comments
  20. You can run Git on object storage if you re-make packfiles(tigrisdata.com ↗)
    23comments
  21. Communication by means of modulated Johnson noise(pnas.org ↗)
    18comments
  22. Ray Ozzie and the Optimism of Being Early(reproof.app ↗)
    8comments
  23. Saving another 100TB of RAM(cloudflare.com ↗)
    89comments
  24. SDCC – Small Device C Compiler(sourceforge.net ↗)
    23comments
  25. Science Is Open Software(jepedersen.dk ↗)
    48comments
  26. From Stonemasons to Carpenters(thelastsoftwareengineer.substack.com ↗)
    4comments
  27. Why building a Rust LSP is hard(rust-glancer.github.io ↗)
    44comments
  28. The first new cat species discovered in 100 years(nationalgeographic.com ↗)
    122comments
  29. OpenJev(openjev.com ↗)
    278comments
  30. Ctenophores: Wonders of Biology(quantamagazine.org ↗)
    7comments

ThingieQuery: $19 SQL IDE for Excel

221 pointsby 10y agothingiequery.com
111 comments
10y agoHN ↗

Tried downloading without giving an email addy and it threw "The parameter 'to' cannot be an empty string." with a stack trace - might want to check inputs?

10y agoHN ↗

Relying entirely on client-side validation isn't a great idea.

Also your site doesn't seem to be in production mode, can still see the stack traces on exceptions.

10y agoHN ↗

That is AWESOME! Nice work!

If I can offer a button nitpick - I suggest "Try it out for free!" in big text, and "Version 1.5.248.1, 2016-04-26" in small text. Maybe as simple as wrapping the version info in a <small> tag.

10y agoHN ↗

Thanks a lot, I'm pretty proud of it!:) That's a good point, the version isn't really the important part, will do.

10y agoHN ↗

Wow I just checked and you already updated - fast work!

Also this is a really nice piece of work, great job

10y agoHN ↗

Yeah, it was simple enough to change and VS was already open, so I figured why not change it right away... Thanks for the kind words!

10y agoHN ↗

Hi Dang. That's true, it's been less than a year:( It was a hobby project back then and I've switched to full time now. Trying to launch it properly now. I've done serious work in the meantime and lowered the price, and I think it's worth another go. Rules are rules though. Should I remove it?

10y agoHN ↗

Ok, we restored the post and put the price back in the title. Good luck.

10y agoHN ↗

Thanks a lot! Gosh, analytics instantly going up:)

10y agoHN ↗

Also, I wasn't the one posting it back then. I had posted it on reddit, and someone from there crossposted it to hn. Does that count?

10y agoHN ↗

Are you kidding, dude I love you:) It was a huge moral boost for me at the time, and probably the reason I ended up committing to this project full time!

10y agoHN ↗

Is the change in this posts name due to it being treated as a duplicate? My analytics have gone waaay down since that:(

10y agoHN ↗

Looks like it is Windows only. Is it likely that there will be a Mac version in the nearish future?

10y agoHN ↗

Unfortunately no. The way it integrates into Excel is only available in Excel for Windows. Excel for Mac just doesn't have many ways you can talk to it (that I'm aware of).

10y agoHN ↗

super bummer! I clicked on purchased with paypal and then decided to check and make sure if there was mac option or not. It's too bad there is not. I was ready to buy. That said, great work!

10y agoHN ↗

It's the thought that counts:) Yeah, it's a shame there's no way to integrate with Excel for Mac, not a small market either.

10y agoHN ↗

Dude. You seriously need to market an enterprise edition of this (offer support or something). It's a great idea with exceptional execution. At least half the companies I work with (oil & gas companies—they are addicted to Excel like it's crack or something) would buy this for quite a bit if it were marketed at them.

10y agoHN ↗

Thanks! Something like a site wide license? Any suggestions on a price point for this? I'm decent at development, but I'm a complete noob at marketing and business.

10y agoHN ↗

Site-wide or per-seat, I'm not really sure which would be better. For the companies I work with, which are by-and-large pretty small, I think a per-seat license would be better (several of them only have 2-3 production analysts). You could do ~$600/head including support+updates for a year (might want to cap hours of support, however) pretty easily I think.

I'm not any better at marketing, I just know a lot of people that would use this if it were pitched at them correctly. Unfortunately, most of sales involving enterprisey companies is in the pitch and not actually in the product....

Alternatively you could just get bought by Microsoft like that other guy mentioned.

Best of luck!

10y agoHN ↗

Thanks! I haven't given too much thought to support, but it seems to be a recurring theme here. It's definitely something to think about.

10y agoHN ↗

Yes, good idea. Put "call" in for the price for now and be prepared to negotiate. All the big companies think they're special and will want a "great deal." You can give all of them a great deal and at the same time find out what the market is willing to pay while not underselling.

10y agoHN ↗

Good point. I added that in the FAQ section in the Guide, but really it should also be on the pricing page. I'll add it.

10y agoHN ↗

Just a thought, you may want to think about changing the name if you're going after enterprise. Feels a bit amateurish/not serious.

10y agoHN ↗

That's what I thought at first too, but I suspect it's too late and most companies won't care much. Key is to have an enterprise edition with a support agreement and a higher price (as identified elsewhere in this thread).

10y agoHN ↗

Ever since I saw an invoice for Good for Enterprise (office nickname: Good for Nothing) I've realized enterprise buyers aren't too worried about name.

10y agoHN ↗

Absolutely true. Having trouble coming up with a name. Open to ideas. Currently I'm thinking "Tabularity", I've bought the domain. Not 100% set on it, but I'm definitely set on changing the name.

10y agoHN ↗

I'd advise against using the term 'excel' in the product, unless you use it as 'blah for Excel'.

10y agoHN ↗

eQuery? xlsql? I dunno, but I agree that the name makes it a little bit harder to take seriously.

10y agoHN ↗

The name is playful and plays on collective conscious of "thingamabob". I think the name is clever and succinct.

10y agoHN ↗

Nice to hear definitely. That's the vibe I was going for, but it feels a bit clumsy. Maybe I should have use QueryThingie instead:)

10y agoHN ↗

I doubt the name itself matters much as long as the product/site/marketing/branding/support docs/etc. look professional enough. In fact, this name is pretty unique and would probably show up as the only result when searching from Google.

10y agoHN ↗

Also consider a license like JetBrains old "personal purchase for professional use". I've carried Resharper around with me from employer to employer as my own "hammer" resulting in multiple new enterprise licenses when other people see me use it. I imagine this is exactly that kind of software. Scratching an itch the business doesn't yet realize is there.

10y agoHN ↗

I would also like this option. With JetBrains, as long as you yourself are paying for the license you can use the IDE at work. Your employer cannot reimburse you in any way for the license or else you have to get the full on commercial version.

This is something I'd like to be able to purchase to toy around with at work, but not necessarily something I would want to try to get my employer to buy for me, especially so I could move around with it (and use it for personal projects as well).

Maybe something cost-wise between the personal and commercial licenses?

10y agoHN ↗

I've been around the block in corporate. Here's a guidebook (sorry I can't spend more than 15 minutes on this)

1: Get insurance for your product. It will run really cheap for something low-risk like this. (Our firm pays less than 10 grand a year for General Liability, All-risk, and Professional Liability up to 10MM, which is more than good enough for nearly every company out there.)

2: Like Patrick said, the second you throw "HIPAA" compliance up there you have the ability to charge 10 (IME, more realistically, 25x -- but your expenditures increase as a result of that (incurred labor costs of additional support, etc)). At your 20 dollar price-point, you're undervaluing yourself by literally 3 or 4 orders of magnitude. Find an industry (say, that dude who mentioned oil, find out what regulatory institutions dominate), get vendor certified and insured and you're looking at Oracle-esque money + 30% maintenance fees per year + support fees + modification fees.

Corporate sales is all about the steak and strippers (and nepotism) but it's wildly lucrative, even now when oil is trading at like 40/bbl due to SA flooding the hell out of the market. To put it in perspective, Parker hydraulic gear commands a 3 or 4x premium over other brands of nearly-comparable quality. It's a lot like medicine or finance, huge markups but huge barriers to entry re: regulatory certs/risks. I wouldn't sell a site license for the product itself (per actual site, not per corporation, that midtown Manhattan office is billed separately from the LA office) for less than low 6 figures. (Sales cycles are long and expensive, your net on that will probably be 30%, which is why Oracle is always pushing for you to go buy that RAC license, it's only 30% more!)

3: Along the veins of having industry compliance, obviously, offer support. Lets say you want to target the mid-market, Bob the engineer won't be able to do buy the software until his manager sees a support contract available. You're basically not going to maximize revenue targetting this demographic. Supports a must though. (Joel Spolsky factioned software sales off into the "under 1k, petty cash" and "above 100k, gotta take it to the board". Supports a must for either one, at 400 a seat or 400/k/year/seat) I'd target niche oil + board approval market with a relatively long sales cycle (especially if that other HN'er who mentioned oil can get you in for a round of golf with the CIO and give him the 30% rip or whatever's standard now in enterprise sales).

4: Just a note, I take things apart for fun and your product isn't well protected. I'm sure you know that since you left little fun notes around your code base (ps. I do snoop around, and I like you also! haha).

Just another why targeting the "Oracle" demographic (where they literally give copies away with no license keys or anything to everyone on their website), and corporations comply with the fee policies because it's wiser to pay the fees now than have the BSA audit come in and have a 5x fine imposed.

---

I made a really long post about here[1] re: medical hardware (another tightly regulated industry with high margins and a sales team that makes or breaks) -- the relevant information is in the last few paragraphs.

There are also .NET licensing components if you make the (imo unwise) decision of targeting the mid-market, which uses USB keys + a network server to limit your trial functionality, but as I'm sure you know, the second those bits hit the hard-disk, someone like me is going to take Olly to it and have it smashed into pieces within a few hours to a few days. Those keys just keep the honest honest (i.e. a company might forget that their trial ran out, or the note to authorize the purchase didn't make it down to their AR/AP dept, etc).

[1] https://news.ycombinator.com/item?id=11543670

10y agoHN ↗

Haha, glad I didn't write that class for nothing:)

Anyway... wow that's some comment! It's a lot of info to unpack! Would love to be able to hit you up with a question or two later if possible, but this gives me a sh*tload of stuff to research, you have my thanks!

10y agoHN ↗

Contact information is in my profile, I'd be happy to help if I can, though 90% of it's going to be just rubbing elbows with the right people and hiring out the proper staff. (Though one can do fairly well organically guest posting on relevant blogs - i.e., if I were targeting the financial industry I'd post about how my software helps with risk analysis, if I were targeting primary lenders, I'd blog about how much easier it is to keep a real-time view of your cash-flow/accounts, etc). Not sure how much I can help specifically, but my contact information is in my profile if you'd like strategic advise which is fairly cross industry.

10y agoHN ↗

I'm a marketer :-) Also, I have purchased a non-trivial amount of BI, Analytics, and Marketing software at total contract values as high as $X00K.

I suggest that you offer at least two tiers (personal/education and corporate). You can keep the personal tier low to drive adoption as part of your growth strategy and price your corporate license at $200-$600 per person per year. I have never been in a situation where there was even a need to discuss the cost of a tool at those price points. If it will increase productivity, just buy it.

Lastly, consider an enterprise or site option for users with more than X licenses.

10y agoHN ↗

price your corporate license at $200-$600 per person per year. I have never been in a situation where there was even a need to discuss the cost of a tool at those price points

Come work for government, then despair.

10y agoHN ↗

I used to work for a Japanese multinational making networking gear. Excel was part of the mandated SOE, and was used for everything (even unit testing frameworks in VBscript), so this would be a no brainer for their environment. The engineers would have difficulty getting this purchase through as it is too cheap for the enterprise version... In the accountant brain, cheap == a toy for a number of companies.

10y agoHN ↗

I think the logic is like "they can't possibly support this product at this price point, we would rather depend on something which may be inferior but well-supported".

10y agoHN ↗

Support is such a crucial point in enterprise software. The reason why they pay big bucks is they have someone to call when something goes wrong

10y agoHN ↗

Or not. Selling to enterprise is very different from selling to individuals. If you enjoy networking and the process of selling, go for enterprise sales.

If you prefer to just work on your project, you can make a decent amount of money from selling to individuals. I make around 10k a month from an SQL client app that is targeted at web developers, and I spend very little effort on sales.

10y agoHN ↗

I'm totally amazed by this (10k/month from postico, mac app only).

What _is_ your selling point for postico? I'm genuinely curious since there are other SQL client apps out there that either: 1) free or 2) F/OSS or 3) cross-platforms. Granted they may not look as "beautiful" as yours but gosh... they work out of the box...

Man I need to do more market research....

10y agoHN ↗

When you use an app professionally, it doesn't matter if it is free or if it costs $40. If it saves you one hour of work, it's worth the price.

It also doesn't matter if the app is cross-platform. Most people use only a single platform, and it turns out that Macs are very popular among my target audience (web developers & data analysts).

It also doesn't need to support a lot of features. I focussed on features that are important for web developers and data analysts, and I made sure they work really well. Yeah, pgAdmin has more admin features, but my users don't care about that.

I discovered most of what I know of the market as I went along, by talking to customers. Nobody bought the early versions of my app; it took three years of iterating on customer feedback to get to 10k a month.

Talking to (potential) customers is really important. In the beginning, I thought that DB admins would be my target audience. But from talking to people at pgConf, I discovered that most PostgreSQL admins don't care about GUIs, but web developers do. So that's where I put my focus.

I think the most important choice I made in the beginning was to focus on PostgreSQL rather than MySQL. The latter might be 10x as popular, but PostgrSQL is gaining popularity and growing, and there's lots of interest in PostgreSQL -- perfect conditions for starting a business.

10y agoHN ↗

Thank you for this great advise!

I guess I hang out with the wrong circle ;). Most developers around me typically would just download something that is free (if it's cross-platform it gets +1 added-value since often we switch between Windows and Ubuntu). Case and Point: Eclipse vs IntelliJ. I bought IntelliJ during the Doomsday discount (75% discount) but people around me still using Eclipse until some event where they decided to move to the "free" (community) version of IntelliJ. I haven't gone back to Eclipse after that...

I'm just amazed with your story. I need to "get out" more and talk to more people... seriously...

10y agoHN ↗

IntelliJ is a lot more expensive than $40. At their price point, I'd assume they mostly target enterprise customers, and not so much individual developers.

Maybe that's another selling point for my app? Most other database software is targeted at enterprise customers (endless feature checklists, a price of $500 per seat); whereas I mostly target individual developers.

10y agoHN ↗

I can vouch for this! I bought a copy to use at home. Unfortunately my business suffers terribly from NIH syndrome, and everything has to be kept as simple as possible because everyone is supposed to be replaceable.

10y agoHN ↗

Any chance you could send me your contact info?

10y agoHN ↗

This is amazing. Microsoft is going to buy you for a TON of cash. I said it first! (?)

10y agoHN ↗

If it happens, I will find you and make sure you get TONS of beer delivered to your doorstep:)

10y agoHN ↗

Shit, can I opt in to this as well?! On topic: downloading

10y agoHN ↗

Need to come up with an algorithm for this now, fingers crossed I actually end up doing the calculation:) Half a ton for you too!:)

10y agoHN ↗

I am so down for this. I'm also down to grab a beer at any point on your journey. You should be really proud of what you've built.

10y agoHN ↗

That sounds awesome! Send me some contact info and I'll get in touch!

10y agoHN ↗

I'm recommending this to all my friends in the office not only because it's a great idea (playing with the free trial now), but because you have an awesome attitude!

10y agoHN ↗

This ought to be a part of Excel. Microsoft, bring out your wallet for this fine gentleman!

10y agoHN ↗

At least Excel 2013 and above has the ability to build models of related tables, but not full SQL afaik.

10y agoHN ↗

Very very well done! I have no use for this right now but I'm buying it anyway because you deserve the support. Congrats on launching!

10y agoHN ↗

This is quite impressive! Congratulations! Its cool stuff such as this that makes the life of a lot of people easier. Good work!

10y agoHN ↗

Thank you, that's the plan! And hopefully to earn a decent living while I'm at it:)

10y agoHN ↗

Am I misunderstood somewhere? Did you provide a sql interface to excel? are you asking a DBA to use excel instead of a real database?

For me, it seemed to be more interesting to provide an excel interface to database.

10y agoHN ↗

Both really. Some times you don't need the overhead of a database, you just want to do a damn join in Excel or something.

But also, it has the option to connect to an external database. When connecting, you can pull Excel tables into the database as temp tables, do queries (or import the data from the temp tables into permanent tables), and write results back into Excel. What's more you can automate this, even without VBA.

10y agoHN ↗

Looks great, but your pricing sucks. $19, seriously? Multiply that 10-20-50 fold.

10y agoHN ↗

I would not say 10 fold, but $99 has ring to it ;)

10y agoHN ↗

Well, $99 seems fair to me as well:) The reason for the low price now is I need the users and word of mouth. I'm well aware it's worth a whole lot more than $19, but right now I just don't know how to get it in front of potential customers other than by keeping a low price for a month or two.

10y agoHN ↗

http://fcell.io/

They have a product like yours but will do C#/F#/VB instead of SQL (in your case). Their pricing is pretty heavy ;).

10y agoHN ↗

First time I see this, pretty cool stuff. Glad to see I potentially have a lot of room for pricing adjustments:)

10y agoHN ↗

What?! $1k license or bust? Any idea of the number of customers they have?

10y agoHN ↗

What benefit does it have over VBA? A lot of the things shown in the demo could be done by simply importing a dll.

10y agoHN ↗

I like your comment:) That's the home version of it, the commercial is $149/year per machine. Basically I need traction, and a community of users, so I'm aiming for it being affordable for people to use at home. I'm hoping this will transfer into people wanting to use it in their companies which is where I charge money. As I mentioned before, I'm a complete noob in business and marketing so I might be going about this very wrong. In any case, I'm very open to suggestions.

10y agoHN ↗

Feel free to give it a try, but I don't think adoption will work that way for this kind of product. Have you thought about reaching out to financial blogs? You need to get this in front of people.

Also, $149 is nothing for a business. If you're selling to a financial business, whose $100-200-300k paid employees use Excel a lot, it's easily worth $500-1,000 per license (or more!). You need to price for value in the context in which your software is being used.

The trial version should be sufficient to convince people to upgrade -- asking for an e-mail address before initiating the download probably isn't a bad idea. :-)

10y agoHN ↗

Get rid of the "home" version. Your market is business. Up your prices 2-3 fold per license. Rename it.

P.S. And quit claiming you're a noob. You're in business now. So get to reading on positioning your product and doing some direct outreach.

10y agoHN ↗

Get a press kit first. I can help you with marketing ( at least for this kind of appliation)

Great job! Seriously

10y agoHN ↗

Dayummmm..!!!! (y) That is soooo awesommeee..!!! :)

10y agoHN ↗

Just an FYI...Exact software offer a similar tool like this to enable power users to query their data. It's not fully loaded as this so you might be up for grabs if the price is right. Why not connect with them after you review your value.

10y agoHN ↗

Any idea what the tool is called? Can't seem to find it on their website

10y agoHN ↗

I think he's referring to Power Query / Get & Transform

10y agoHN ↗

If you support the .NET Framework Data Provider for OLEDB, it's worth mentioning. That opens up a bunch of additional data sources for folks, potentially including Active Directory, and suddenly you're (maybe) getting the attention of enterprise IT folks as well as the business side.

10y agoHN ↗

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.

10y agoHN ↗

Are you open to re-selling? Maybe white label it? If you don't want to talk about it publicly please email me (check profile). :)

10y agoHN ↗

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:)

10y agoHN ↗

I will email you. Thanks for the response. Go sleep. :)

10y agoHN ↗

Every now and then one sees something on HN that makes you think "why didn't I think of that?" This is one of those ideas executed very well. My prediction is this guy makes millions and is eventually bought by Microsoft for a ridiculous sum of money.

I think he'd be a shoe-in for YC, but I also think that'd be a waste now - with a product like this he can easily show it off to investors and raise money, if needed, or just bootstrap off his own revenue. $120K for 7% is not a good deal with a polished product like this - I think it would be easy to beat.

10y agoHN ↗

Wow this is excellent. In telecom, everything gets passed around as Excel sheets. And people spend non trivial effort screwing around in it. This would have saved so much time.

Like everyone else said, your pricing and marketing is aiming too low.

10y agoHN ↗

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:)

10y agoHN ↗

It's not every day that you come across such rave comments about a "Show HN" kind of thing. Congratulations to the dev.

I'm not familiar with enterprise / Excel requirements & use cases. Could someone explain why is this such a great product [1]. I wrongly assumed that excel champs won't be comfortable dealing with SQL because they are either non-engineers or have been away from programming for way too long.

[1] No offense to the author, I'd love to understand what the enthusiasm is all about.

10y agoHN ↗

Have similar thoughts and would like to know others opinion on that.

10y agoHN ↗

Excel superuser here. There's a lot of excel users who aren't comfortable with SQL, but I think they're a dying breed. The SQL you need to know for about 99% of your workflow is something you can learn in a couple of weekends. Most of the younger people I know learn SQL basics in college (I'm talking about business people, not just engineers).

Spreadsheets are just really terrible at data manipulation. Good Excel analysts know this and understand why a query language is so useful.

Data usage is exploding and business users want to roll their own analyses and not wait around for an IT ticket to be filled. So having business users able to easily use SQL in Excel makes things a lot more efficient.

Using VLOOKUP functions and pivot tables is just not an elegant solution to a lot of data problems. A SQL script would be much more useful.

10y agoHN ↗

Can I use window functions like partition by?

10y agoHN ↗

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 return the element at position pos in a group, ordered by orderElements. Not exactly window functions, but close.

10y agoHN ↗

This provides a lot of value for businesses - therefore I'd definitely charge more. I would also consider changing the name to something else - "Thingie" might cause some friction in purchases.

As to setting the price - I'd look at comparables such as Sublime, JetBrains IDEs/Resharper. I'd be looking at charging at least $49 - but I think $79 to > $100 would feel right to me.

As to a long term enterprise pricing plan, I dunno - but I'd definitely be looking at it.

Good luck and well done.

10y agoHN ↗

As a heavy excel user this is tremendous. I've always wanted to be able to run SQL queries against a Range.

However: from much experience working in gigantic firms where Excel forms the core of a like a gazillion work flows and is the default analytics platform - sadly most users just aren't technical enough for this to be useful to them. There's probable a niche 1% who'd get value from this. Most people do not understand databases, SQL, and have little/no experience in any kind of coding including VBA.

10y agoHN ↗

I fully agree that enterprise version would be in high demand. I work in a business org at a large tech company. Everybody is an excel user, most are sort of familiar with SQL but aren't great at setting up ETL jobs. This product is amazing.

10y agoHN ↗

This is an awesome product, but: the name and price-point will not encourage customers to take the product seriously.

For a while I've been thinking about how hard it is to wean corporate analysts off Excel (it's their frame of reference) and on to something more 'Enterprise-y', and the solution is to go the other way and scale Excel instead.

This product is an excellent start at that.

10y agoHN ↗

Strongly agree on scaling Excel. Excel is deeply entrenched in corporate environments because it's the go to tool for users when IT depts can't or won't deliver what they need. Consequently there's a huge amount of Excel based end user generated solutions out there that are business critical. Looks like ThingieQuery has hit a sweet spot for power users working on Excel-as-a-DB type problems. Another outfit taking the scale up Excel approach is BlockSpring. Thingie could add a lot of value manipulating BlockSpring imported data. My own interests lie in Excel-as-calc-engine rather than DB, and I think there's a lot of value to be had in scaling up calcs by serverizing.

10y agoHN ↗

Little bit of advice:

1) Obfuscate your deliverables

2) Don't store the Licensing information in plain-text in a XML file; it's trivial to create a generator to generate a valid license for the current product. Make sure to use a public/private key you sign it and check it, not giving the client the information to create a valid license if they know the CPU Id, Hdd s/n's and Nic Mac Adresses.

Other than that: well done, looks great and as others have said: market it for enterprises and buy a boat :)

10y agoHN ↗

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. :)

10y agoHN ↗

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 crossposted it from reddit last year, which was a big moral boost.

10y agoHN ↗

Incredible! I wish this was out before I switched roles. Would've been extremely useful especially for advanced pivoting.

10y agoHN ↗

Google Sheets has a "query" function in which you can write out SQL-like scripts and I have found it to be tremendously useful. I've been disappointed that a similarly easy-to-use function doesn't exist in Excel. This is a solution to that problem.

At first I thought this might not be all that useful given Excel's Power Query functionality, but then I realized there are still a lot of use cases where this could come in handy.