Trần Nhật Duy duydev

Install Google Fonts

https://fonts.google.com/?selection.family=Open+Sans

cd /usr/share/fonts sudo mkdir googlefonts sudo unzip -d . ~/Downloads/Open_Sans.zip sudo chmod -R --reference=opentype googlefonts

Other people's projects:

My projects (tutorials are on my blog at http://maxoffsky.com):

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

	public static IEnumerable<IEnumerable<T>> Split<T>(this T[] array, int size)
	{
	for (var i = 0; i < (float)array.Length / size; i++)
	{
	yield return array.Skip(i * size).Take(size);
	}
	}