durango

CODING STANDARDS

This is a list of the various code style guides I've printed out and (try to) abide by. There are endless style guides on the internet, these are just the ones I use wherever possible.

---

Frontend

durango

Mozilla Public License, version 2.0

1. Definitions

1.1. "Contributor"

     means each individual or legal entity that creates, contributes to the
     creation of, or owns Covered Software.

1.2. "Contributor Version"

durango

// node.js 0.5 Diffie-Hellman example                                           
var assert = require("assert");
var crypto = require("crypto");

// the prime is shared by everyone                                              
var server = crypto.createDiffieHellman(512);
var prime = server.getPrime();


// sharing secret key on a pair                                                 

durango

Presto Specific

• Don’t SELECT *, Specify explicit column names (columnar store)
• Avoid large JOINs (filter each table first)
  • In PRESTO tables are joined in the order they are listed!!
  • Join small tables earlier in the plan and leave larger fact tables to the end
  • Avoid cross joins or 1 to many joins as these can degrade performance
• Order by and group by take time
  • only use order by in subqueries if it is really necessary
• When using GROUP BY, order the columns by the highest cardinality (that is, most number of unique values) to the lowest.

durango

/*
    Copyright (c) 2016 Micha Mettke

    This software is provided 'as-is', without any express or implied
    warranty.  In no event will the authors be held liable for any damages
    arising from the use of this software.

    Permission is granted to anyone to use this software for any purpose,
    including commercial applications, and to alter it and redistribute it
    freely, subject to the following restrictions:

durango

Go Cheat Sheet

Index

1. Basic Syntax
2. Operators

• Arithmetic
• Comparison
• Logical
• Other

3. Declarations

durango

Go Cheat Sheet

Index

1. Basic Syntax
2. Operators

• Arithmetic
• Comparison
• Logical
• Other

3. Declarations

durango

var express = require('express'),
	passport = require('passport'),
	LocalStrategy = require('passport-local').Strategy,
	connect = require('connect'),
	http = require('http'),
	path = require('path'),
	util = require('util'),
	fs = require('fs'),
	redis = require('redis'),
	cookie = require('cookie'),

durango

WAL-G PITR

This gist summarises a way to simulate point-in-time recovery (PITR) using WAL-G. Most of the material is adapted from Creston's tutorial.

Setup

First we initialize a database cluster

pg_ctl init -D cluster

durango

import React, { useReducer, useEffect, useRef } from 'react';
import firebase from 'firebase/app';
import equal from 'deep-equal';

function filterKeys(raw, allowed) {
  if (!raw) {
    return raw;
  }
  let s = new Set(allowed);
  return Object.keys(raw)