Skip to content

Instantly share code, notes, and snippets.

View dspinellis's full-sized avatar

Diomidis Spinellis dspinellis

1.6k followers · 36 following
View GitHub Profile
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active May 12, 2025 02:24
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 December 28, 2024 13:59
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
MightyPork / usb_hid_keys.h
Last active May 9, 2025 20:57
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
*/
@mroderick
mroderick / how-to-add-image-to-gist.md
Created January 31, 2017 14:59 — forked from remarkablemark/how-to-add-image-to-gist.md
How to add an image to a gist

How to add an image to a gist

  1. Create a gist if you haven't already.
  2. Clone your gist: 
    # make sure to replace `<hash>` with your gist's hash
git clone https://gist.github.com/<hash>.git # with https
git clone [email protected]:<hash>.git     # or with ssh
@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,