seamusabshere

xsv was a revelation when it came out 10 years ago. It's a rust-based CSV tool. Lately people are recommended to use QSV, also rust-based, but incredibly (too much) feature rich. I worked with Claude to modernize XSV and add a few key features like --compress and --flexible... and also upgrade the underlying rust csv lib, whose 2018 version was known to hang on certain weird input.

i wrote about why i thought citus was the best a week ago: http://blog.faraday.io/3-reasons-citus-is-best-non-heroku-po...

Faraday - Burlington, VT (Vermont) - ONSITE

Backend engineer

Help build the next generation of marketing with Node, Ruby, Postgres 9.4+, PostGIS 2.1+, Docker, ECS, Vault, and other cutting edge tech.

cto@faraday.io

I cache with redis:

https://github.com/seamusabshere/lock_and_cache

(and lock too, with Redis Redlock)

best. hn. ever.

Recommended by Oleg Bartunov in http://www.postgresql.org/message-id/CAF4Au4y93AV2dKuQ2ABJbs...

* API client with batching and parallelization built in (100 queries in a single request, multiple requests run in parallel, etc.)

* robustness in the face of bad street suffixes (for example, in Burlington, VT, you may find data with "CR" meaning "CIRCLE" instead of the official USPS "CREEK")

* fuzzy street name matching (PAKCER -> PACKER)

* accurate geocoding in rural United States

* fuzzy international place matching (like "ST PANCRAS ST STATION" in London)

thanks for the tip! it was worth the karma i lost for my attempt at humor...

can we get that in postgresql 9.3.3 ok tks bye

love it

thank you for sharing!

ok, i'll go first: i love https://github.com/seamusabshere/upsert because it seems like a new idea and https://github.com/seamusabshere/fuzzy_match because it feels like i've combined string similarity and array enumeration to make something truly useful.

don't be shy

5 examples, nice

My for-profit company (Brighter Planet) often gets product ideas from our data scientists; it's exactly what Dr. Haghighi is talking about.

For example: trying to model environmental impact of Bill Gates's 66,000 sq ft house during a hackathon -> discovery that we need fuzzy set analysis (https://github.com/seamusabshere/fuzzy_infer) -> new, marketable capabilities in our hotel modelling product (https://github.com/brighterplanet/lodging/blob/master/lib/lo...).