Live data from Hacker News

I wandered off and built an IDE

blog.querystorm.com

31–40 of 273 posts

Re: I wandered off and built an IDE

#32
post #6

If I wanted to combine Excel and SQL, I would look at MS Access first. How does this compare? Also with the latest powerquery add ons Excel you can actually do joins in Excel itself

It is possible to connect an Excel spreadsheet directly as an ODBC data source to Access. Then you can run SQL queries, views, reports on the data, without having to export or modify it in any way.

Re: I wandered off and built an IDE

#33
I really like this guy's tenacity and clever use of excel. But from my experience you can use excel files as an ODBC database source (Windows).

https://stackoverflow.com/questions/15844633/using-excel-as-...

Once you create your ODBC source from the excel files, you can run queries and use the language of your choice (Python,C# ....). I am pretty sure you can also insert/update rows and columns too.

Wondering how this differs from the approach I describe (which has existed for many years).

Good work!

Re: I wandered off and built an IDE

#36
post #17

@anakic That was an enjoyable read! I have also tried qutting my job as a developer, tried making money by working for myself (and focusing on developing features instead of actually making money, same as you), then returning to a "proper job" as an engineer. There were many recognizable moments in the blog post. I once took a course in entrepreneurship, as a distraction from computer science, and the bottom line is…

I think that there's a rising "Maker" culture that focuses on building first and launching fast.

For example: https://www.youtube.com/watch?v=6reLWfFNer0

Re: I wandered off and built an IDE

#39
That was a fantastic read. In a world of products and apps that seem to be a solution looking for a problem, it's nice to see a full story illustrating a common problem, and how a technical person came to provide a featured solution to that problem.

I think I already know the answer to this, but I assume that this IDE is Windows only? I couldn't see any information about platforms on the main product page, which might throw someone off if they use Excel on a Mac.

Re: I wandered off and built an IDE

#40

Congratulations on the project. It actually seems like something quite fun to build! I'd probably have kept it open source and just do it for fun, but good luck with the company nontheless! Personally I did not immediatly think about Jetbrains when reading this name, probably because I mostly use IntelliJ IDEA rather than PHPStorm.

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 QueryStorm, I'm pretty happy I did what I did. As for open source, that might be a better way to go. The project needs a community and open sourcing would help a lot. It's something for me to consider.
Post reply on HN