Tanguy ⧓ Herrmann dolanor

It seems that it does not matter what timezone is on the server as long as you have the time set right for the current timezone, know the timezone of the datetime columns that you store, and are aware of the issues with daylight savings time.

On the other hand if you have control of the timezones of the servers you work with then you can have everything set to UTC internally and never worry about timezones and DST.

Here are some notes I collected of how to work with timezones as a form of cheatsheet for myself and others which might influence what timezone the person will choose for his/her server and how he/she will store date and time.

MySQL Timezone Cheatsheet

WARNING: If you're reading this in 2021 or later, you're likely better served by reading:

(This gist was created in 2013 and targeted the legacy GOPATH mode.)

$ ssh -A vm
$ git config --global url."[email protected]:".insteadOf "https://github.com/"

	package main

	import (
	"bufio"
	"fmt"
	"net/url"
	"os"
	"regexp"
	"sort"
	"strconv"

	- What do Etcd, Consul, and Zookeeper do?
	- Service Registration:
	- Host, port number, and sometimes authentication credentials, protocols, versions
	numbers, and/or environment details.
	- Service Discovery:
	- Ability for client application to query the central registry to learn of service location.
	- Consistent and durable general-purpose K/V store across distributed system.
	- Some solutions support this better than others.
	- Based on Paxos or some derivative (i.e. Raft) algorithm to quickly converge to a consistent state.
	- Centralized locking can be based on this K/V store.

	#! /usr/bin/env python2
	# Requires: PIL, colormath
	#
	# Improved algorithm now automatically crops the image and uses much
	# better color matching

	from PIL import Image, ImageChops
	from colormath.color_conversions import convert_color
	from colormath.color_objects import LabColor
	from colormath.color_objects import sRGBColor as RGBColor

	body {
	-webkit-font-smoothing:antialiased;
	font:normal .8764em/1.5em HelveticaNeue-Light,Helvetica,Arial,sans-serif;
	margin:0;
	}

	html > body {
	font-size:1em;
	padding:1em;
	}

	from bottle import route, run, request, static_file
	import subprocess

	"""
	Get DEVICE_ID by running script and connecting to the url with your mobile device


	python unlock.py
	Bottle v0.11.2 server starting up (using WSGIRefServer())...
	Listening on http://192.168.77.102:8888/

	[alias]
	wip = for-each-ref --sort='authordate:iso8601' --format=' %(color:green)%(authordate:relative)%09%(color:white)%(refname:short)' refs/heads

	#!bash.exe
	export SSH_AUTH_SOCK=/tmp/.ssh-socket
	echo ;
	echo Starting connection with ssh-agent...
	ssh-add -l 2>&1 >/dev/null
	if [ $? = 2 ]; then
	rm -f /tmp/.ssh-script /tmp/.ssh-agent-pid /tmp/.ssh-socket
	# Exit status 2 means couldn't connect to ssh-agent; start one now
	echo Creating new ssh-agent...
	ssh-agent -a $SSH_AUTH_SOCK > /tmp/.ssh-script