Samuel Karani samuelkarani

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.

	var request = require('request');
	var unzip = require('unzip');
	var csv2 = require('csv2');

	request.get('http://s3.amazonaws.com/alexa-static/top-1m.csv.zip')
	.pipe(unzip.Parse())
	.on('entry', function (entry) {
	entry.pipe(csv2()).on('data', console.log);
	})
	;

	#!/bin/bash

	# https://gist.github.com/robwierzbowski/5430952/
	# Create and push to a new github repo from the command line.
	# Grabs sensible defaults from the containing folder and `.gitconfig`.
	# Refinements welcome.

	# Gather constant vars
	CURRENTDIR=${PWD##*/}
	GITHUBUSER=$(git config github.user)

	//note: month is 0 based, just like Dates in js
	function getWeeksInMonth(year, month) {
	const weeks = [],
	firstDate = new Date(year, month, 1),
	lastDate = new Date(year, month + 1, 0),
	numDays = lastDate.getDate();

	let dayOfWeekCounter = firstDate.getDay();

	for (let date = 1; date <= numDays; date++) {

	{
	"type": "MultiPolygon",
	"coordinates":
	[
	[
	[
	[ -123.123779, 48.227039 ], // contig. u.s.
	[ -123.318787, 49.000042 ],
	[ -121.742592, 49.000267 ],
	[ -95.157394, 49.000493 ],

	[
	{name: 'Afghanistan', code: 'AF'},
	{name: 'Åland Islands', code: 'AX'},
	{name: 'Albania', code: 'AL'},
	{name: 'Algeria', code: 'DZ'},
	{name: 'American Samoa', code: 'AS'},
	{name: 'AndorrA', code: 'AD'},
	{name: 'Angola', code: 'AO'},
	{name: 'Anguilla', code: 'AI'},
	{name: 'Antarctica', code: 'AQ'},

	<html>
	<body>
	<video id="v" width="300" height="300"></video>
	<input id="b" type="button" disabled="true" value="Take Picture"></input>
	<canvas id="c" style="display:none;" width="300" height="300"></canvas>
	</body>
	<script>
	navigator.getUserMedia({video: true}, function(stream) {
	var video = document.getElementById("v");
	var canvas = document.getElementById("c");