logoalt Hacker News

myroon5yesterday at 7:43 PM1 replyview on HN

At AWS, a team asked for help maintaining a bespoke internal Java service that diff'd json for manual reviews.. replaced it with a jq one-liner


Replies

MathMonkeyManyesterday at 8:59 PM

A former coworker was evaluating the cleanliness and structure of some non-free GeoIP data that took the form of several large CSV files. He was writing nested loops in Go that parsed the CSV and evaluated the predicates that interested him, and it was arduous and not going as quickly as he would like.

I told him to slurp it all into a sqlite database and to express his data integrity questions as SQL queries.

It was still a pain in the ass for him, but leveraging that tool made things go a lot better.