imlucas

-- using default substitutions


select l_returnflag, l_linestatus, sum(l_quantity) as sum_qty, sum(l_extendedprice) as sum_base_price, sum(l_extendedprice * (1 - l_discount)) as sum_disc_price, sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge, avg(l_quantity) as avg_qty, avg(l_extendedprice) as avg_price, avg(l_discount) as avg_disc, count(*) as count_order from lineitem where l_shipdate <= date '1998-12-01' - interval '90' day (3) group by l_returnflag, l_linestatus order by l_returnflag, l_linestatus;



select s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment from part, supplier, partsupp, nation, region where p_partkey = ps_partkey and s_suppkey = ps_suppkey and p_size = 15 and p_type like '%BRASS' and s_nationkey = n_nationkey and n_regionkey = r_regionkey and r_name = 'EUROPE' and ps_supplycost = (select min(ps_supplycost) from partsupp, supplier, nation, region where p_partkey = ps_partkey and s_suppkey = ps_suppkey and s_nationkey = n_nationkey and n_regio

imlucas

MongoDB

• compass.mongodb.com automatic updates
• compassmaps.mongodb.com mapbox proxy (see below)
• stitch.mongodb.com data warehouse stitch app for metrics

Bugsnag

• notify.bugsnag.com
• sessions.bugsnag.com

imlucas

jira-local

Note This data was generated from a local test installation of JIRA on Lucas' laptop. The data contained herein is purely autogenerated through the JIRA installation wizard.

Contents

Outputs

Offline

imlucas

#! /usr/bin/env bash

####
# Configuration
####

# Set me to the path of dart-cli you want to use
export DARTCLI=~/Downloads/dart-cli-1.0.0-alpha.2/bin/dart-cli;

# Specify mysql instance details you want to load up

imlucas

Introduction

Redux is the state management library we’re standardizing on across products. It’s highly performant, has a overhead for producing features, and provides an excellent development experience via the time-travel debugging paradigm. Redux accomplishes all of this by requiring any state transformations are immutable.

Immutable.JS is a library from Facebook which provides a high-level API that guarantees immutability when modifying state.

Further recommended reading on the space:

• https://macwright.org/2015/05/18/practical-undo.html
• https://egghead.io/lessons/javascript-simple-undo-redo-with-immutable-js-data-structures

imlucas

{
  "$schema": "https://vega.github.io/schema/vega-lite/v2.json",
  "data": {
    "url": "data/cars.json",
    "format": {
      "type": "json"
    }
  },
  "selection": {
    "click": {

imlucas

{
  "fields": [
    {
      "name": "_id",
      "path": "_id",
      "count": 1000,
      "types": [
        {
          "name": "ObjectID",
          "bsonType": "ObjectID",

imlucas

All Binaries in Tarball

14 file(s) with total size 187.95MB

┌──────────────┬───────────┐
│ Binary Name  │ File Size │
├──────────────┼───────────┤
│ bsondump     │ 4.52MB    │
├──────────────┼───────────┤

imlucas

centralize listCollections calls:

• doc validation uses dataService.listCollections but should be collection-model.get() to get collection details
• lots of listCollections code in instance-model. move to collection-model.list()
• dataService has a lot of code that should be in models
• add type, options.viewOn, options.pipeline and info.readOnly to collection-model
• make a mongodb-view-model class that extends mongodb-collection-model?

imlucas

pipeline: [] | [stage, ...]

stage: geoNear | group | limit | match | out | project | redact | skip | sort | unwind

geoNear : {$geoNear: {GEO_NEAR_OPTIONS}}

group : {$group : { _id: expression, (out_name: {accumulator: expression})* }} // accumulators are optional
accumulator: $addToSet | $avg | $first | $last | $max | $min | $push | $sum

limit : {$limit: natural_number}