dspinellis’s gists

rgreenjr / postgres_queries_and_commands.sql

Last active November 17, 2024 13:10

Useful PostgreSQL Queries and Commands

	-- 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%'

killercup / pandoc.css

Created July 3, 2013 11:31

Add this to your Pandoc HTML documents using `--css pandoc.css` to make them look more awesome. (Tested with Markdown and LaTeX.)

	/*
	* I add this to html files generated with pandoc.
	*/

	html {
	font-size: 100%;
	overflow-y: scroll;
	-webkit-text-size-adjust: 100%;
	-ms-text-size-adjust: 100%;
	}

TomDemeranville / doi-prefix-publishers.csv

Created January 29, 2014 23:09 — forked from hubgit/doi-prefix-publishers.csv

prefix	publisher	journals	dois
10.12679		0	0
10.7579	123Doc Education	0	0
10.3731	21st Century COE Program (Toplogical Science and Technology)	1	40
10.5775	A. I. Rosu Cultural Scientific Foundation Fundatia cultural-stiintifica A. I. Rosu	1	80
10.4037	AACN Publishing	2	766
10.1306	AAPG/Datapages	4	21817
10.3183	AB Svensk Papperstidning	1	1550
10.5769	ABEAT - Associacao Brasileira de Especialistas em Alta Tecnologia	1	57
10.7597	ACOPIOS - Revista Iberica de Mineralogia	1	9

fragoulis / unaccent.rules

Last active June 10, 2022 11:19

Postgres unaccent rules for greek characters

dennmtr / athens-radio.m3u

Last active November 16, 2024 20:14

Athens Radio Playlist

	#EXTM3U
	# TECSUN PL-505 ~ Location: 37.975288, 23.625487
	#EXTINF:0,087.50 ~ Κρήτη FM - 087.50 ~ Κρήτη FM
	http://s3.onweb.gr:8878
	#EXTINF:0,087.70 ~ En Lefko - 087.70 ~ En Lefko
	https://stream.radiojar.com/enlefko877
	#EXTINF:0,088.00 ~ Μέντα - 088.00 ~ Μέντα
	https://stream.radiojar.com/menta.aac
	# 088.30 ~ ? - 088.30 ~ ?
	#EXTINF:0,088.60 ~ Kids Radio - 088.60 ~ Kids Radio

MightyPork / usb_hid_keys.h

Last active November 12, 2024 03:32

USB HID Keyboard scan codes

	/**
	* USB HID Keyboard scan codes as per USB spec 1.11
	* plus some additional codes
	*
	* Created by MightyPork, 2016
	* Public domain
	*
	* Adapted from:
	* https://source.android.com/devices/input/keyboard-devices.html
	*/

gousiosg / unix-compatible.sh

Last active November 20, 2017 10:17

How compatible is your Unix with the original one?

	#!/usr/bin/env bash

	TEMPFILE=/tmp/unixcount
	exist=0
	notexist=0

	echo 0 0 > $TEMPFILE

	curl "https://raw.githubusercontent.com/dspinellis/unix-v4man/master/man0/ptxx"\|
	grep "(I)"\|

iodic / exclude-directory-from-git-diff.sh

Created March 28, 2018 09:41

Exclude a directory from git diff

git diff -- . ':!directory_name'

ndandoulakis / dealing-with-nesting-SoC.java

Last active November 10, 2018 16:44

	/**
	* Building Maintainable Software - Ten Guidelines for Future Proof Code
	* https://www.amazon.com/Building-Maintainable-Software-Java-Future-Proof/dp/1491953527
	*
	* Write Simple Units of Code - Dealing with Nesting, page 36.
	*
	* I like the example on page 36 because it's simple and just enough to demonstrate how hard is
	* to write straightforward code, or how easy is to increase the Accidental Complexity of the code.
	*
	* There are 4 implementations of the same functionality. The first one is the original code,

johnjreiser / AmazonLinux-InstallPostGIS.sh

Last active April 29, 2024 14:55

Script to install PostgreSQL 13 and PostGIS 3.2 on fresh Amazon Linux 2

	#!/bin/bash
	# Script to install PostgreSQL and PostGIS on a fresh Amazon Linux instance

	# Installing from source:
	# - GEOS
	# GEOS 3.10+ requires CMake 3+, not readily available on Amazon Linux 2.
	GEOSVER=3.9.2
	GEOSURL=http://download.osgeo.org/geos/geos-${GEOSVER}.tar.bz2

	# - PROJ (GDAL requires 6+; 6.2.1 is the last to use SQLite 3.7; 6.2 had build issues, so 6.1.1)

Diomidis Spinellis dspinellis