slitayem

Toc

Keyboard shortcuts

The IPython Notebook has two different keyboard input modes. Edit mode allows you to type code/text into a cell and is indicated by a green cell border. Command mode binds the keyboard to notebook level actions and is indicated by a grey cell border.

MacOS modifier keys:

• ⌘ : Command

slitayem

Python3 Virtualenv Setup

Requirements

• Python 3
• Pip 3

$ brew install python3

slitayem

First install pip for Python2. Download the get-pip.py file from https://bootstrap.pypa.io/get-pip.py
$ cd <download location>
$ sudo -H ./get-pip.py

Use pip to install pip3
$ sudo -H pip install pip3

Installing pip3 also installs Python3
To run Python3
$ python3

slitayem

/* MongoDB cheat sheet */

// replication lag via serverStatus()
db._adminCommand( { serverStatus : 1 , repl ; 2 } )

// stats
db.stats()
db.foo.stats()

// size of BSON of some query

slitayem

Note: Tested on mongodb 3.4.1

Creating Collections, Documents, Indexes

See: MongoDB CRUD Operations

Command	Description
db.createCollection("movies")	Explicitly create a collection

slitayem

MongoDB cheat sheet

Overview

Overview

MongoDB is a document database that provides high performance, high availability, and easy scalability.

• Document Database

slitayem

SQL to MongoDB Mapping Chart

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.

slitayem

Note: This was tested on macOS Sierra Pre-installed

• python
• Homebrew

Install cql & cassandra-driver

pip install cql

slitayem

The Best of the Best Practices (BOBP) Guide for Python

A "Best of the Best Practices" (BOBP) guide to developing in Python.

In General

Values

• "Build tools for others that you want to be built for you." - Kenneth Reitz
• "Simplicity is alway better than functionality." - Pieter Hintjens

slitayem

CREATE OR REPLACE FUNCTION random_int_array(dim integer, min integer, max integer) RETURNS integer[] AS $BODY$
begin
	return (select array_agg(round(random() * (max - min)) + min) from generate_series (0, dim));
end
$BODY$ LANGUAGE plpgsql;

CREATE EXTENSION pgcrypto;

CREATE TABLE test_table as select id, md5(random()::text) || id as name, random_int_array(500000, 100, 10000) as arr, gen_random_uuid() uid from generate_Series(1,3) id
;