How ProPublica Illinois Uses GNU Make to Load Data
11–20 of 69 posts
Re: How ProPublica Illinois Uses GNU Make to Load Data
#12Re: How ProPublica Illinois Uses GNU Make to Load Data
#13If you focus on the headline, you'll miss the point. The point is they used open source technology to process public data for reporting once the government stopped updating its own tools.
Re: How ProPublica Illinois Uses GNU Make to Load Data
#14A lot of comments in here are poking fun at how little data it is relative to a commercial data mining operation. The data they process and what they do with it is worth more to society than any number of petabytes crunched to target ads. Processing petty petabytes is not praiseworthy. If you focus on the headline, you'll miss the point. The point is they used open source technology to process public data for reporti…
Re: How ProPublica Illinois Uses GNU Make to Load Data
#15Re: How ProPublica Illinois Uses GNU Make to Load Data
#16Original, https://www.propublica.org/nerds/gnu-make-illinois-campaign-...
Re: How ProPublica Illinois Uses GNU Make to Load Data
#17Was that supposed to say Petabytes? Gigabytes is really not that impressive.
Re: How ProPublica Illinois Uses GNU Make to Load Data
#18IMO, this is a bad use case for make.
Re: How ProPublica Illinois Uses GNU Make to Load Data
#19What do you folks use? Drake, "make for data" https://github.com/Factual/drake seems ok, but doesn't have "batch" jobs, (aka "pattern rules") where you can do every file in a directory matching a pattern.
Others have come up with different swiss army knives but nothing ever sticks for me, it usually ends up as a single Makefile with eg 3 targets that call a bunch of shell scripts.
The whole thing would be configurable to build from scratch, but not well set up to do incremental ETL on a per file basis, after I eg delete some extraneous rows in one file, clean up a column, redownload a folder, or add files to a dataset.
Re: How ProPublica Illinois Uses GNU Make to Load Data
#20A lot of comments in here are poking fun at how little data it is relative to a commercial data mining operation. The data they process and what they do with it is worth more to society than any number of petabytes crunched to target ads. Processing petty petabytes is not praiseworthy. If you focus on the headline, you'll miss the point. The point is they used open source technology to process public data for reporti…
Pettybytes. I like that.