taroyanaka

Postgres Cheatsheet

This is a collection of the most common commands I run while administering Postgres databases. The variables shown between the open and closed tags, "<" and ">", should be replaced with a name you choose. Postgres has multiple shortcut functions, starting with a forward slash, "". Any SQL command that is not a shortcut, must end with a semicolon, ";". You can use the keyboard UP and DOWN keys to scroll the history of previous commands you've run.

Setup

installation, Ubuntu

http://www.postgresql.org/download/linux/ubuntu/ https://help.ubuntu.com/community/PostgreSQL

taroyanaka

DaBi: data binding library that keeps it simple

DaBi (short for Data Binding) is a dead simple yet complete and self-contained DOM-to-JS and JS-to-DOM data binding library in just 25 lines of pure ES5 and 454 bytes when minified.

How to obtain

Download it right here or include it into your HTML:

taroyanaka

import { lensProp, lensPath, view, set, over, toUpper } from "ramda"

const me = {
  firstName: "Sébastien",
  lastName: "Nicolaïdis",
  birthDate: new Date("1979-09-13T15:00Z"),
  age: 38,
  hobbies: ["Rock climbing", "Horse riding", "Chess"],
  parents: {
    brother: {

taroyanaka

import {
  nth,
  slice,
  contains,
  head,
  last,
  tail,
  init,
  length,
  take,

taroyanaka

import { compose, inc, prop, assoc, evolve, always, add } from "ramda"

const nextAge = compose(
  inc,
  prop("age"),
)
console.log("nextAge", nextAge({ age: 21 }))
const celebrateBirthday = person => assoc("age", nextAge(person), person)
const person = { age: 24 }
console.log("celebrateBirthday", celebrateBirthday(person))

taroyanaka

import { assoc, assocPath, dissoc, dissocPath, omit, compose, inc, prop } from "ramda"

const original = {
  a: "Bingo",
  b: {
    c: "Bingo",
    d: "Bingo",
  },
}

taroyanaka

import { cond, always, lte, gte, T, __, identity } from "ramda"

const water = cond([
  [lte(__, 0), temp => `water freezes at ${temp}°C`],
  [gte(__, 100), temp => `water boils at ${temp}°C`],
  [T, temp => `nothing special happens at ${temp}°C`],
])

console.log(water(-222))

taroyanaka

import { ifElse, gte, lt, __, always, identity, when, unless } from "ramda"

// const forever21 = age => (age >= 21 ? 21 : age)
// const forever21 = ifElse(gte(__, 21), always(21), identity)
// const forever21 = unless(lt(__, 21), always(21))
const forever21 = when(gte(__, 21), always(21))

console.log("forever21(24)", forever21(24))
console.log("forever21(16)", forever21(16))

taroyanaka

import { map, filter, partial, partialRight, curry, __, pipe } from "ramda"

const publishedInYear = curry((year, book) => book.year === year)

const titlesForYear = curry((year, books) =>
  pipe(
    filter(publishedInYear(year)),
    map(book => book.title),
  )(books),
)

taroyanaka

import { compose, both, either, gte, prop, equals, __ } from "ramda"

const OUR_COUNTRY = "France"

const wasBornInCountry = compose(
  equals(OUR_COUNTRY),
  prop("birthCountry"),
)
const wasNaturalized = compose(
  Boolean,