Skip to content

Instantly share code, notes, and snippets.

View dspinellis's full-sized avatar

Diomidis Spinellis dspinellis

1.5k followers · 35 following
View GitHub Profile
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active July 5, 2024 04:29
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
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
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
fragoulis / unaccent.rules
Last active June 10, 2022 11:19
Postgres unaccent rules for greek characters
À A
Á A
 A
à A
Ä A
Å A
Æ A
à a
á a
â a
@dennmtr
dennmtr / athens-radio.m3u
Last active July 2, 2024 08:08
Athens Radio Playlist
#EXTM3U
#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
#EXTINF:0,088.60 ~ Kids Radio - 088.60 ~ Kids Radio
https://stream.radiojar.com/64p6ktzntg0uv
#EXTINF:0,088.90 ~ Hit - 088.90 ~ Hit
@MightyPork
MightyPork / usb_hid_keys.h
Last active July 5, 2024 22:07
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
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
iodic / exclude-directory-from-git-diff.sh
Created March 28, 2018 09:41
Exclude a directory from git diff
git diff -- . ':!directory_name'
@ndandoulakis
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
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)