Omkar Manjrekar manjrekarom

SQL to MongoDB Mapping Chart¶

In addition to the charts that follow, you might want to consider the Frequently Asked Questions section for a selection of common questions about MongoDB.

Executables¶

The following table presents the MySQL/Oracle executables and the corresponding MongoDB executables.

Octave CheatSheet

GNU Octave is a high-level interpreted language, primarily intended for numerical computations.
(via GNU Octave)

Hint: I also mad an octave docset for Dash: https://github.com/obstschale/octave-docset

Basics

MySQL

Getting started

CSS units

Recommendations of unit types per media type:

Media	Recommended	Occasional use	Infrequent use	Not recommended
Screen	em, rem, %	px	ch, ex, vw, vh, vmin, vmax	cm, mm, in, pt, pc
Print	em, rem, %	cm, mm, in, pt, pc	ch, ex	px, vw, vh, vmin, vmax

Relative units

Moved to https://blog.kartones.net/page/curl-cheatsheet/

Nice answer on stackoverflow to the question of when to use one or the other content-types for POSTing data, viz. application/x-www-form-urlencoded and multipart/form-data.

“The moral of the story is, if you have binary (non-alphanumeric) data (or a significantly sized payload) to transmit, use multipart/form-data. Otherwise, use application/x-www-form-urlencoded.”

Matt Bridges' answer in full:

The MIME types you mention are the two Content-Type headers for HTTP POST requests that user-agents (browsers) must support. The purpose of both of those types of requests is to send a list of name/value pairs to the server. Depending on the type and amount of data being transmitted, one of the methods will be more efficient than the other. To understand why, you have to look at what each is doing

System Design Cheatsheet

Picking the right architecture = Picking the right battles + Managing trade-offs

Basic Steps

Clarify and agree on the scope of the system

User cases (description of sequences of events that, taken together, lead to a system doing something useful)
- Who is going to use it?
- How are they going to use it?

	<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
	"http://www.w3.org/TR/html4/strict.dtd">
	<html>
	<head>
	<title>PhoneGap Back Button Example</title>

	<script type="text/javascript" charset="utf-8" src="phonegap.0.9.5.js"></script>
	<script type="text/javascript" charset="utf-8">

	// Call onDeviceReady when PhoneGap is loaded.

	// Getting a file through XMLHttpRequest as an arraybuffer and creating a Blob
	var rhinoStorage = localStorage.getItem("rhino"),
	rhino = document.getElementById("rhino");
	if (rhinoStorage) {
	// Reuse existing Data URL from localStorage
	rhino.setAttribute("src", rhinoStorage);
	}
	else {
	// Create XHR, Blob and FileReader objects
	var xhr = new XMLHttpRequest(),

	// Invoice markup
	// Author: Max Kostinevich
	// BETA (no styles)
	// http://pdfmake.org/playground.html
	// playground requires you to assign document definition to a variable called dd

	// CodeSandbox Example: https://codesandbox.io/s/pdfmake-invoice-oj81y


	var dd = {