Live data from Hacker News

Eve Version 0

chris-granger.com

191–195 of 195 posts

Re: Eve Version 0

#191

Earlier quoted context omitted.

Hey, I clicked through, read the tutorial, got excited about your examples.. tried to download and found out it was windows only! I would have totally evaluated it further if there were an os x/linux option.

Thanks for checking it out! As we're targeting Tableau users so eventually we will release an OS X version.

Speaking of Tableau (which was founded on the concept of VizQL), how is this different? Doesn't tableau basically enable knowledge workers to create data-centric web applications?

Re: Eve Version 0

#193

Earlier quoted context omitted.

> VBA also does SQL operations on Excel tables, but that's, well, worse. Are you sure about that? Afaik it doesn't but I may be mistaken.

Yeah, it could be done using the ADODB interface on data in the workbook itself rather than from some actual DB. See this link for an example: http://stackoverflow.com/a/26678696/1502035 That being said, when I encountered someone doing this I was pretty surprised as well.

Pretty wild - it would be nice if MS would put a little effort into their cash cows now and then so people wouldn't have to resort to such things though.

Re: Eve Version 0

#194

Earlier quoted context omitted.

The PowerPivot engine itself I imagine is in unmanaged code, but the code that just writes datasets and whatnot to the model is (from what I've heard)managed code, and indeed you can decmpile the libraries and see all sorts of things, I've only looked around for about 10 minutes or so. And I had just read on some obscure thread that someone had successfully found the undocumented API call to write to the model, which…

Right, makes sense, I'll try and check out what's available then. :) By writing to the model, you mean programmatically adding new measures or the like? My interest is in programmatically querying models using DAX, though to this end I'd also look to look in the direction of Microsoft's DirectQuery mode in SQL Server which supposedly did DAX-to-SQL conversion. If one could use such a conversion plus MDX to start quer…

Not even measures, I'm just wanting to be able to create tables, define relations, etc, with the accompanying sql or m script. I'm hopeful they'll let us do that some day, but I still don't quite believe they've changed their stripes entirely.

Re: Eve Version 0

#195
post #55

Earlier quoted context omitted.

This is a really helpful perspective. For example, I've started referring to myself as a "user" of Python rather than a programmer.

Care to explain a bit your choice of word ? Funny how I often heard about the user / programmer dichotomy. Always just felt like a user in the know.

I'd divide it as essentially "User of Packages" vs. "Writer of Packages", and of course, the dichotomy is not actually a clear one. But the choice was to suggest that there are some people for whom the programming language and its libraries are not an end of itself, and "Just crack it open and write your own thing for X..." is essentially a non-starter.

I think it's useful to distinguish between the two groups, because not only do they have different skill sets, but they have different motivations. For example I will never directly be evaluated on the performance or style of my code in the way a programmer might be - only the paper that code helped me write.

Post reply on HN