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 |