freretuc / setup.sh

Last active April 17, 2017 12:26

Overpass API setup

	# 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

cquest / heure-ete.sql

Last active June 13, 2016 21:01

Dates de changement heure d'hiver / heure d'été

	/* 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;

clhenrick / README.md

Last active March 3, 2025 23:02

PostgreSQL & PostGIS cheatsheet (a work in progress)

PostgreSQL & PostGIS Cheatsheet

This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.

	// 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.

cquest / gist:8331683

Last active January 9, 2021 11:01

postgresql: liste des table/index par taille + infos sur le tablespace utilisé (https://coderwall.com/p/eghbjq)

	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)

afair / tmux.cheat

Last active June 3, 2024 23:26

Tmux Quick Reference & Cheat sheet - 2 column format for less scrolling!

	========================================== ==========================================
	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 &

MohamedAlaa / tmux-cheatsheet.markdown

Last active May 18, 2025 15:01

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname

dmolsen / Facebook + Twitter Fan Count

Created September 27, 2010 15:47

Pulls the Facebook fan count and Twitter follower count for the specified accounts.

	<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;

Pommereau eric-pommereau