Live data from Hacker News

I wandered off and built an IDE

blog.querystorm.com

101–110 of 273 posts

Re: I wandered off and built an IDE

#101
post #45

I loved that you used your technical skills to solve a real problem, besides regular stuff at corporate work :) Insipiring! Sorry this could be a dumb question, but,does this plugin work with Spreadsheets in Google docs? If Yes, thats great, just from the perspective that it will add more customers for you. If not, are you planning to add support in google sheets as well?

Not inside Google Sheets, there's nothing stopping you from moving your spreadsheets to Excell though.

Exactly. It just works in Excel, but if you have Excel then it makes spreadsheets easier and more useful.

Re: I wandered off and built an IDE

#102
post #83
post #53

Earlier quoted context omitted.

But, as a developer, it's soul-wrenching and just feels wrong to try to sell something before something proper has even been made. This has been my biggest struggle.

In my experience, technical people latently believe the thing that people buy from you is a product. So if the product isn't done / ready / etc, then you are being misleading trying to "sell" them or engage with them. It feels wrong, like you're forced to misrepresent yourself. You imagine the potential buyer as a hyper-critical power-user that will expect everything to be perfect. But what if the above isn't true at…

This shift in perspective has been critical for me. Similarly, it is critical to ask “Whose problem am I solving?”

I am an engineer and tinkering with tech brings me pleasure from creating, I crave mental stimulation, and I get immense satisfaction from havingright things in right places”. Polishing the code is like polishing the car engine for a petrolhead.

But those are my problems and triggers. I am feeding _my_ needs, then implicitly expect other people to give me _their_ money for doing this. Because look how hard I toiled! Yet many people do not care how polished their car engine is. And I have never seen clean code that was generating revenue.

The critical shift was to accept that people and have needs I don’t have, and they are desperate to solve them. And their professional lives are often painful - I get frustrated when I spend a day with almost any professional outside of tech. “This is the shit you have to put up with to get anything done??!” I haven’t had that problem since teens, if ever, and I can fix it. Automatically, empathy takes over, and I want to rescue them from the daily dread. So I wire together a minimal app that will make them glow with delight for 6 months, and they’ll give me dollars in return. Today was a good day, because two strangers supported each other and did not focus entirely on themselves.

If it were up to me, everyone would get a juicy steak. But when going fishing it’s more effective to bring worms.

Re: I wandered off and built an IDE

#103
post #86

Earlier quoted context omitted.

See the Dropbox HN argument. Polish.

It would be even better if BrandonM also commented here ;)

Not OP, but even today I still don't understand why is Dropbox different except for hype and media coverage - there were many similar services back then (including integrating as a virtual drive on Windows) and we have literally tons of these services now.

Re: I wandered off and built an IDE

#106
post #103
post #86

Earlier quoted context omitted.

It would be even better if BrandonM also commented here ;)

Not OP, but even today I still don't understand why is Dropbox different except for hype and media coverage - there were many similar services back then (including integrating as a virtual drive on Windows) and we have literally tons of these services now.

> there were many similar services back then

Citations please.

Re: I wandered off and built an IDE

#107
working on a daily basis with excel/vba/sql and was intrigued for a moment. Then I wandered into the pricing and was truly surprised. Again, a niche tool that charges as much as the complete jetbrains suite (if you're a subscriber for 3 years).

Re: I wandered off and built an IDE

#108
@anakic

I have used excel as a data source using VBA before so one problem I had there that I'm curious how you approached was how to automatically determine data types? IIRC the ODBC engine in VBA scans a set amount of rows to guess. Are you doing anything different?

Re: I wandered off and built an IDE

#109
Trial purchase page seems to be only place you describe the difference between free and Professional (https://www.querystorm.com/trial.html). Perhaps add to FAQ in docs or elsewhere to make clear the added functionality that comes from purchase, beyond the "non-commercial vs. commercial" use license requirement.

Otherwise, cool system!

Re: I wandered off and built an IDE

#110
post #58

Earlier quoted context omitted.

Primarily, it's a lot more convenient. There's no setup involved, you just click and and the data is available through SQL or C#. There's no need to clean the data around the tables, it works on live data (file does not need to be saved), no connection strings to set up or boilerplate code to write. There's more, e.g. the SQLite engine can interact with Excel and fiddle with formatting, but I think the major thing is…

Are you ever worried about Microsoft a feature that acts similar in a future version of Excel? It's a problem that has bit others before (Firebug, Growl, tabbed-browsing extensions for IE).

I don't think Microsoft would be able to produce something that was just ready, without having to create a project or click through a wizard first.

Much of this functionality is available already, through ODBC, powershell, c# - but it's cumbersome to use. That's the selling point of this software, it seems to me.

Post reply on HN