List of unicorn startup companies

https://en.wikipedia.org/wiki/List_of_unicorn_startup_companies I wasn’t aware of that many unicorn startups from china. Turns out there are quite a lot.

June 27, 2018 · 1 min · birdchan

Light bulb colors

June 26, 2018 · 0 min · birdchan

Convert a bare timestamp to local time in PostgreSQL

Very often in old databases a timestamp column does not have the timezone info. This becomes an issue when the business gets bigger and crosses different timezones. [code] select bare_timestamp_field at time zone ‘Asia/Shanghai’ at time zone ‘US/Pacific’ from some_table; [/code] The above sample query assigns the Shanghai timezone to the bare timestamp, then convert the resulting timestamp w/ timezone to the US Pacific PST timestamp. The double ‘at time zone’ parts can be read as: from timezone #1 to timezone #2. This is due to the implicit syntax. A more explicit syntax is the following, which makes more sense similar to type casting. ...

June 25, 2018 · 1 min · birdchan

Big History Project

Nice course with short videos that explains the history of our universe through many fields of study. https://www.bighistoryproject.com/home

June 23, 2018 · 1 min · birdchan

Web 2.0 vs Web 3.0 Comparison Map

ref: https://medium.com/@matteozago/why-the-net-giants-are-worried-about-the-web-3-0-44b2d3620da5

June 2, 2018 · 1 min · birdchan

Dealing with time

Good read about time in general in programming. https://zachholman.com/talk/utc-is-enough-for-everyone-right

May 31, 2018 · 1 min · birdchan

Flexbox

Nice articles about how flexbox works. https://medium.freecodecamp.org/an-animated-guide-to-flexbox-d280cf6afc35 https://medium.freecodecamp.org/even-more-about-how-flexbox-works-explained-in-big-colorful-animated-gifs-a5a74812b053

May 30, 2018 · 1 min · birdchan

The Indoor Generation

May 29, 2018 · 0 min · birdchan

Why children, not childs?

https://www.grammarphobia.com/blog/2016/03/en-plural.html

May 28, 2018 · 1 min · birdchan

Stockdale Paradox

You must never confuse faith that you will prevail in the end—which you can never afford to lose—with the discipline to confront the most brutal facts of your current reality, whatever they might be. -- James Stockdale Ref: https://en.wikipedia.org/wiki/James_Stockdale

May 18, 2018 · 1 min · birdchan