Hacker News Reader

seamusabshereon QSV got too busy, so Claude modernized XSV

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.

seamusabshereon Amazon RDS now supports PostgreSQL 9.6.1

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...

seamusabshereon Ask HN: Who is hiring? (November 2015)

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

seamusabshereon Clarifications about Redis and Memcached

I cache with redis:

https://github.com/seamusabshere/lock_and_cache

(and lock too, with Redis Redlock)

seamusabshereon Micro heaters cut 87% off my electric heat bill

best. hn. ever.

seamusabshereon plantuner: Postgres hints, from author of JSONB and GiST/GIN

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

seamusabshereon Ask HN: what features do you want in a geocoder?

* 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)

seamusabshereon BayesDB - a Bayesian database table

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

seamusabshereon BayesDB - a Bayesian database table

can we get that in postgresql 9.3.3 ok tks bye

seamusabshereon Ask HN: What open source project is your pride and joy?

love it

seamusabshereon Ask HN: What open source project is your pride and joy?

thank you for sharing!

seamusabshereon Ask HN: What open source project is your pride and joy?

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.

seamusabshereon Ask HN: What open source project is your pride and joy?

don't be shy

seamusabshereon [Earth Day] greendreams: a compendium of environmental APIs

5 examples, nice

seamusabshereon What it takes to build great machine learning products

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...).