start new:
tmux
start new with session name:
tmux new -s myname
<html> | |
<head> | |
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script> | |
<script type="text/javascript"> | |
var f_page = "wvumountaineers"; // the page name for your fan page, e.g. the 'wvumountaineers' part of http://facebook.com/wvumountaineers | |
var t_page = "westvirginiau"; // the account name for your main twitter account | |
function add_commas(number) { | |
if (number.length > 3) { | |
var mod = number.length % 3; |
========================================== ========================================== | |
TMUX COMMAND WINDOW (TAB) | |
========================================== ========================================== | |
List tmux ls List ^b w | |
New new -s <session> Create ^b c | |
Attach att -t <session> Rename ^b , <name> | |
Rename rename-session -t <old> <new> Last ^b l (lower-L) | |
Kill kill-session -t <session> Close ^b & |
SELECT N.nspname || '.' || C.relname AS "relation", | |
CASE WHEN reltype = 0 | |
THEN pg_size_pretty(pg_total_relation_size(C.oid)) || ' (index)' | |
ELSE pg_size_pretty(pg_total_relation_size(C.oid)) || ' (' || pg_size_pretty(pg_relation_size(C.oid)) || ' data)' | |
END AS "size (data)", | |
COALESCE(T.tablespace, I.tablespace, '') AS "tablespace" | |
FROM pg_class C | |
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) | |
LEFT JOIN pg_tables T ON (T.tablename = C.relname) | |
LEFT JOIN pg_indexes I ON (I.indexname = C.relname) |
// iMacro CheatSheet - Command Reference | |
// http://wiki.imacros.net/Command_Reference | |
// iMacros supports 3 types of variables: | |
// * The macro variables !VAR0 thru !VAR9. They can be used with the SET and ADD command inside a macro. | |
// * Built-in variables. They contain certain values set by iMacros. | |
// * User-defined variables. They are defined in-macro using the SET command. | |
This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.
/* changements heure hiver > été depuis 1981 le dernier dimanche de mars à 1h UTC soit 2h (hiver) / 3h (été) en France */ | |
select april::timestamptz | |
- interval '1 day' * case when extract(dow from april)=0 then 7 else extract(dow from april) end | |
from (select generate_series('1981-04-01 01:00:00+00','2050-04-01 01:00:00+00', interval '1 year') as april) as m; | |
/* changements heure été > hiver de 1981 à 1995 le dernier dimanche de septambre à 1h UTC soit 2h (hiver) / 3h (été) en France */ | |
select sept::timestamptz | |
- interval '1 day' * case when extract(dow from sept)=0 then 7 else extract(dow from sept) end | |
from (select generate_series('1981-10-01 01:00:00+00','1995-10-01 01:00:00+00', interval '1 year') as sept) as m; |
# http://wiki.openstreetmap.org/wiki/Overpass_API/Installation | |
# Ubuntu 16.04 | |
# Intel(R) Xeon(R) CPU W3520 @ 2.67GHz | |
# 16GB RAM | |
# 2To | |
# update && upgrade | |
apt-get update && apt-get -y upgrade |