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

Pollen

May 22, 2018 · 0 min · birdchan