https://ntfy.sh/ is also worth mentioning in this space.
Readit Newsspeq commented on Show HN: An open-source notification infrastructure github.com/novuhq/... · Posted by u/opensh
speq commented on Joining CSV Data Without SQL: An IP Geolocation Use Case brimdata.io/blog/join-geo... · Posted by u/jameskerr
I have done some similar, simpler data wrangling with xsv (https://github.com/BurntSushi/xsv) and jq. It could process my 800M rows in a couple of minutes (plus the time to read it out from the database =)
qsv has more features nowadays:
speq commented on Zero-Downtime Hetzner Deploys with Ansible scratchdb.com/blog/ansibl... · Posted by u/memset
Hetzner looks so good and I wanted to move my storage there, but as I tried to create an account I was requested to upload the picture of an ID. I said OK, I mean, they're just trying to guard against some edge cases. However, then they just sent an email that my account is closed and this is final. No answer to my mails either.
As a result, I'm obviously very reluctant to believe the praise about them as I found this incredibly rude. There ought to be a better way to do this. I realize that this is only tangentially related to their technology, but still.
For manipulating CSV from the terminal, check out https://github.com/BurntSushi/xsv
There's a fork with new features: https://github.com/jqnatividad/qsv
I was a lurker, but your post has inspired me to create an account. Thank you for reminding us that people can be good.
I'm sure there's an optimal sequence of keypresses that tests all 10000 codes in something like 30,000 keypresses rather than the naive 40,000.
https://en.wikipedia.org/wiki/De_Bruijn_sequence
It seems that you can do it in 10003 key presses. Calculation for this this exact example is in the Wikipedia page.