RGNagel

RGNagel

#ifndef _LINUX_LIST_H
#define _LINUX_LIST_H

#include <stdio.h>

#define offsetof(TYPE, MEMBER) ((size_t) &((TYPE *)0)->MEMBER)

/**
 * container_of - cast a member of a structure out to the containing structure
 * @ptr:	the pointer to the member.

RGNagel

Name	Register #	Usage	Preserved on call
$zero	0	The constant value 0	NA
$v0 - $v1	2 - 3	Values for results and expression evaluation	F
$a0 - $a3	4 - 7	Arguments	F
$t0 - $t7	8 - 15	Temporaries	F
$s0 - $s7	16 - 23	Saved	T
$t8 - $t9	24 - 25	More temporaries	F
$gp	28	Global pointer	T
$sp	29	Stack pointer	T

RGNagel

; Global settings
[redshift]
temp-day=6500K
temp-night=5000
transition=1
;gamma=0.8:0.7:0.8
gamma=1.000:1.000:1.000
location-provider=geoclue
;location-provider=manual
adjustment-method=vidmode

RGNagel

#GNU Screen Cheat Sheet

##Basics

• ctrl a c -> cre­ate new win­dow
• ctrl a A -> set win­dow name
• ctrl a w -> show all win­dow
• ctrl a 1|2|3|… -> switch to win­dow n
• ctrl a " -> choose win­dow
• ctrl a ctrl a -> switch between win­dow
• ctrl a d -> detach win­dow

RGNagel

PostgreSQL & PL/pgSQL Stored Functions Cheatsheet

Boiler-plate stored function

CREATE OR REPLACE FUNCTION public.sp_user_ins_status(status smallint)
  RETURNS integer
  LANGUAGE plpgsql
AS $function$

RGNagel

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

RGNagel

#!/bin/bash
#####################################################
# Name: Bash CheatSheet for Mac OSX
# 
# A little overlook of the Bash basics
#
# Usage:
#
# Author: J. Le Coupanec
# Date: 2014/11/04