The State of Open-Source Data Integration and ETL

Good read, so much have changed in just a few years.


USB types are getting very confusing now, next time I will just look for Thunderbolt 4.

Predict your choice

This game Aaronson Oracle can predict your next choice (left key or right key), with a 70% average correct rate. We are not that random after all.


Light bulb colors

Split a zip file in osx

Say you have a big file and you want to zip it up into a few smaller files, (coz email attachment has size limit), here is how you do it.

zip -s 5m

That cmd will create these files with file size capped at 5mb


To get your original file back, install 7zip.

brew install p7zip

Then run the following to extract your original file(s) back

7za x

There are other ways but I found the above the easiest.


Show download history in osx

Open a terminal and run the following command.

sqlite3 ~/Library/Preferences/* 'select LSQuarantineDataURLString from LSQuarantineEvent'

If that’s alarming, you can add the following line to your .bash_profile file to clean up the history from time to time.

sqlite3 ~/Library/Preferences/* 'delete from LSQuarantineEvent'


Flexbox Defense

This is a fun way to learn css flexbox in a tower-defense game.

Shortcut to insert new rows in Google Spreadsheets

First select a whole row, then do Opt Cmd =. That’s option key, command key, and the equal sign key.

I am using Chrome on osx.

There are more shortcuts from this post:


Photoshop in a web browser, pretty amazing!

brew update is stuck

There is no output, no errors, no nothing. It just sits there.

Maybe related to this, who knows?

So I reinstalled brew.

/bin/bash -c "$(curl -fsSL"

But then the install process is stuck at this line

==> /usr/bin/sudo /usr/bin/xcode-select --switch /Library/Developer/CommandLineTools

After some googling, apparently it’s caused by some combination of osx and xcode, see here: So I ran the following to fix the issue. 

sudo xcode-select -s /Applications/

But then after Ctrl-C and reinstall brew, I got stuck at another line, seems like it did a git reset HEAD but stuck right after.

I tried a few other things but nothing could pass that point. Then just random guessing I checked my Software Update, and saw a 5Gb osx update sitting there waiting, I was like, why not?

So update osx, reboot, then magically brew starts working. =)