This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "title": "I am a mediocre developer", | |
| "author": "Nikita Sobolev", | |
| "date": "Mar 13 '18", | |
| "tags": [ | |
| "#meta", | |
| "#career", | |
| "#beginners", | |
| "#productivity" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # arrayDataTypesCheck - check input array data types for every element | |
| # Chuck Norris API | |
| # Loop through nested objects | |
| # Mixin - Object.assign | |
| # Promises (in the dark), thank you Pat Benatar | |
| # Reduce - Using reduce to filter | |
| # Regex - Common | |
| # Rest Operator | |
| # Show more or less, pure JS | |
| # Spread Operator (Okay, Okay, let's keep the juvenile humor down to a minimum). |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH session_attributiON AS | |
| (SELECT *, | |
| CASE WHEN session_id = LAST_VALUE(session_id) | |
| OVER (partitiON by user_id order by session_start_tstamp ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) THEN 1 | |
| ELSE 0 | |
| END AS LAST_click_attrib_pct, | |
| CASE WHEN session_id = FIRST_VALUE(session_id) | |
| OVER (partitiON by user_id order by session_start_tstamp ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) THEN 1 | |
| ELSE 0 | |
| END AS first_click_attrib_pct, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| " _ _ " | |
| " _ /|| . . ||\ _ " | |
| " ( } \||D ' ' ' C||/ { % " | |
| " | /\__,=_[_] ' . . ' [_]_=,__/\ |" | |
| " |_\_ |----| |----| _/_|" | |
| " | |/ | | | | \| |" | |
| " | /_ | | | | _\ |" | |
| It is all fun and games until someone gets hacked! |
NewerOlder