News for hackers. Stuff that matters.
Re:I wandered off and built an IDE by kelvin0 on Friday April 06, 2018 @08:17AM (#16772604)
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 by anakic on Friday April 06, 2018 @08:51AM (#16772791)
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 convenience. As a dev, most times I just wouldn't bother with the ODBC approach unless I really had to. Convenient C# and SQL though, I'd use them at least 10x more often.

Re:I wandered off and built an IDE by foobarchu on Friday April 06, 2018 @09:24AM (#16772986)
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).
Re:I wandered off and built an IDE by gnud on Friday April 06, 2018 @10:17AM (#16773373)
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.

Re:I wandered off and built an IDE by badloginagain on Friday April 06, 2018 @01:03PM (#16774907)
You guys, Microsoft just acquires the already built project and our happy dev get his mansion.
Re:I wandered off and built an IDE by m_mueller on Friday April 06, 2018 @04:35PM (#16777152)
yeah, but what color though?
Re:I wandered off and built an IDE by badloginagain on Friday April 06, 2018 @05:14PM (#16777515)
Play your cards right and you get any color of your choice
Re:I wandered off and built an IDE by emodendroket on Friday April 06, 2018 @10:02AM (#16773266)
I wouldn't be. The energy is in O365 at the moment, isn't it? VBA is the big programming environment at the moment and it's basically VB6 and hasn't been touched in a long time. There's also that JavaScript thing, which I think is still pretty half-baked.
Re:I wandered off and built an IDE by chatmasta on Friday April 06, 2018 @01:29PM (#16775201)
The JavaScript office API looks like a good solution for integrating your UI within the app. It’s still quite limited in terms of heavier capabilities, eg data processing etc. That’s probably because right now MS is focused more on a shared plugin API for all office products than on deep integration of any one specific product.
Re:I wandered off and built an IDE by TuringTest on Friday April 06, 2018 @09:46AM (#16773154)
Isn't it similar to PowerPivot?
Re:I wandered off and built an IDE by the-dude on Friday April 06, 2018 @08:29AM (#16772659)
See the Dropbox HN argument.

Polish.

Re:I wandered off and built an IDE by thisisandyok on Friday April 06, 2018 @08:48AM (#16772773)
Re:I wandered off and built an IDE by zerr on Friday April 06, 2018 @10:04AM (#16773288)
To be honest - dropbox is still burning investors money, right? AFAIK they are not profitable even today.
Re:I wandered off and built an IDE by drgath on Friday April 06, 2018 @10:21AM (#16773410)
They’re about to IPO. Doesn’t mean they’re profitable, but it does mean their finances are healthy enough that they can be publicly traded.
Re:I wandered off and built an IDE by TomV1971 on Friday April 06, 2018 @10:43AM (#16773581)
They already IPO’d. :-)
Re:I wandered off and built an IDE by levimaes on Friday April 06, 2018 @09:23AM (#16772975)
Holy hell, that's Drew Houston!
Re:I wandered off and built an IDE by fastball on Friday April 06, 2018 @10:23AM (#16773434)
Oh god. I was so confused by your comment because this guy is on a Polish accelerator and I was trying to figure out how that was relevant.
Re:I wandered off and built an IDE by the-dude on Friday April 06, 2018 @11:31AM (#16773987)
I noticed directly after posting, decided to keep it.
Re:I wandered off and built an IDE by kirubakaran on Friday April 06, 2018 @12:28PM (#16774502)
No pun in ten did get upvotes though.
Re:I wandered off and built an IDE by jxub on Friday April 06, 2018 @09:44AM (#16773136)
It would be even better if BrandonM also commented here ;)
Re:I wandered off and built an IDE by zerr on Friday April 06, 2018 @10:07AM (#16773312)
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 by rkangel on Friday April 06, 2018 @10:56AM (#16773685)
Dropbox's solution was significantly more streamlined than any of the others. You installed it and it just worked as the saying goes.
Re:I wandered off and built an IDE by the-dude on Friday April 06, 2018 @12:53PM (#16774780)
Was the web interface there from the start?

If it is the case, you did not even have to install it.

Dropbox did not only solve 'local file system'-mirroring, but (legal) file sharing in general.

Re:I wandered off and built an IDE by the-dude on Friday April 06, 2018 @10:08AM (#16773320)
> there were many similar services back then

Citations please.

Re:I wandered off and built an IDE by thisisandyok on Friday April 06, 2018 @10:38AM (#16773545)
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 my favorite problems to solve. You can’t focus on what everyone else is doing — it has to be about what’s really broken and what you can do to fix it.”"

http://firstround.com/review/How-to-Win-as-a-First-Time-Foun...

Re:I wandered off and built an IDE by zerr on Friday April 06, 2018 @10:58AM (#16773704)
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 by zerr on Friday April 06, 2018 @10:44AM (#16773583)
https://en.wikipedia.org/wiki/Comparison_of_file_synchroniza...

You can find when each of these companies were founded by following the links...

Don't remember the name, but I remember similar service even in late 90s, when dial-up was popular. You'd pay for some amount of storage hosted on their servers (no "cloud" term back then) and they had Windows client integrated as a drive. Not sure if they had "freemium", maybe dropbox differentiated with this business model.

Re:I wandered off and built an IDE by hitekker on Friday April 06, 2018 @09:05AM (#16772862)
Excellent shorthand.