Live data from Hacker News

I wandered off and built an IDE

blog.querystorm.com

141–150 of 273 posts

Re: I wandered off and built an IDE

#141

Earlier quoted context omitted.

> there were many similar services back then Citations please.

I read a quote of Drew's a while back that stuck with me. Just googled and found it: "When Dropbox was getting off the ground in 2007, there were hundreds of small storage companies. It was almost a cliche, the way that many people believe mobile photo sharing is a cliche now, he says. “The important thing was, I would keep asking people if they used any one of these hundred options, and they all said no. These are m…

He should've said what he did differently - seamless integration (aka virtual drive in Windows) was a selling point, but again, other services also had this.

Re: I wandered off and built an IDE

#143

“You might be surprised to learn that in a developer’s life, there aren’t all that many chances to impress girls with your coding skills.” Ha ha. When my wife and I were new she asked to use my laptop and was surprised that it “had no icons”. (No window system). So I started to show her how to avoid using a GUI. 12 years later she uses a terminal about half of her time as a stock administrator.

Textbased internet surfing must be awesome.

Re: I wandered off and built an IDE

#146

@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?

Hey! I scan the entire contents of the table. I have a cache layer in memory anyway so that works quickly. If you have multiple types in the same column, it just treats the type as "object". If you connect, and start entering various types into your columns, you'll notice in the object explorer that it updates the type information.

Re: I wandered off and built an IDE

#147

There were many components mentioned here that sound like they would be marvelously useful to the open-source community without being too competitive (eg; various SQLite parsing tooling, SQLite/Excel interface, SQLite/other db interface, etc). Might be worth open-sourcing? Perhaps even under a restrictive license (free for FOSS work, otherwise paid).

There's been quite a bit of open source work in this space. https://github.com/dinedal/textql runs queries against CSVs on the command line. http://sheetjs.com/sexql/ runs queries against excel files in the web browser.

Re: I wandered off and built an IDE

#149

This was hilarious and utterly relatable. I've also built a lot of one-off tools for my pharmacist girlfriend (now wife - she learned SQL with me ;) Congrats on the launch and the joining accelerator, hope it gains traction! It looks fantastic!

Thanks and congrats to you too!:)
Post reply on HN