Ernie Jeash Villahermosa KarmaBlackshaw

List of MySQL Basic Use Cases

BULK UPDATE

When updating multiple rows with different values it is much quicker to use a bulk update.

UPDATE people 
SET name = 
  (CASE 
 WHEN id = 1 THEN 'Karl'

Sass Dark/Light Theme Mixin

This is a Sass mixin to handle a 3-way dark mode. It relies on a data-theme attribute on your <html> element with a value of light or dark. If data-theme is absent (i.e. it's neither light nor dark), the system's preferred mode is used.

body {
  // matches data-theme="light" or data-theme="auto" with system instructing light mode
  @include light {
    background: white;
 color: black;

FWIW: I didn't produce the content presented here (the outline from Edmond Lau's book). I've just copy-pasted it from somewhere over the Internet, but I cannot remember what exactly the original source is. I was also not able to find the author's name, so I cannot give him/her the proper credits.

Effective Engineer - Notes

By Edmond Lau
Highly Recommended 👍
http://www.theeffectiveengineer.com/

What's an Effective Engineer?

Enter this in the search box along with your search terms:

Get all gists from the user santisbon.
user:santisbon

Find all gists with a .yml extension.
extension:yml

Find all gists with HTML files.
language:html

When you create a npm package, remember it might be used in a browser or a server, or even a command line utility… For each package you create, please pay attention at what it will be used for:

Is it going to be used as a dependency to a nodejs application that is not bundled? (e.g. command line utilities)
Is it going to be used as a dependency to a nodejs application that is bundled? (e.g. AWS Lambdas)
Is it going to be used as a dependency to a browser application (always bundled)?.

In cases 2) and 3) you want to allow for tree shaking.
In cases 1) and 2) you want to benefit from the "ES6"/"ES next" features supported natively by nodejs.
In case 3) you also want to benefit from the native support of "ES6" from your browser.

FWIW: I (@rondy) am not the creator of the content shared here, which is an excerpt from Edmond Lau's book. I simply copied and pasted it from another location and saved it as a personal note, before it gained popularity on news.ycombinator.com. Unfortunately, I cannot recall the exact origin of the original source, nor was I able to find the author's name, so I am can't provide the appropriate credits.

Effective Engineer - Notes

By Edmond Lau
Highly Recommended 👍
http://www.theeffectiveengineer.com/

	// Boring
	if (isThisAwesome) {
	alert('yes'); // it's not
	}

	// Awesome
	isThisAwesome && alert('yes');

	// Also cool for guarding your code
	var aCoolFunction = undefined;

	// set-up a connection between the client and the server
	var socket = io.connect();

	// let's assume that the client page, once rendered, knows what room it wants to join
	var room = "abc123";

	socket.on('connect', function() {
	// Connected, let's sign-up for to receive messages for this room
	socket.emit('room', room);
	});

	function parseLodash(str){
	return _.attempt(JSON.parse.bind(null, str));
	}