Skip to content

Instantly share code, notes, and snippets.

View quetz's full-sized avatar

Quet Zal quetz

12 followers · 26 following
View GitHub Profile
@quetz
quetz / postgres_queries_and_commands.sql
Created December 27, 2019 02:59 — forked from rgreenjr/postgres_queries_and_commands.sql
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%'
@quetz
quetz / nginx.conf
Created September 25, 2019 13:36 — forked from plentz/nginx.conf
Best nginx configuration for improved security(and performance). Complete blog post here http://tautt.com/best-nginx-configuration-for-security/
# to generate your dhparam.pem file, run in the terminal
openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048
@quetz
quetz / gist:be6f8d911e7dc01c4d83f3f29da189e7
Created September 15, 2017 03:28
dr-xr-xr-x 25 root wheel 850B Jan 1 1970 bin
lrwxr-xr-x 1 root wheel 57B Jan 1 1970 lib -> /nix/store/hhmlcjdlf4mnw58h61283ghj6p7hpf6c-ghc-8.0.2/lib
lrwxr-xr-x 1 root wheel 60B Jan 1 1970 manifest.nix -> /nix/store/ryycwmjh0haf79wf99fdl1kzsqhg6w76-env-manifest.nix
lrwxr-xr-x 1 root wheel 59B Jan 1 1970 share -> /nix/store/hhmlcjdlf4mnw58h61283ghj6p7hpf6c-ghc-8.0.2/share
@quetz
quetz / norm.c
Created February 17, 2017 18:13
path normalizer, ugly c
char *normalize(char *src) {
char *r = (char *)(malloc(strlen(src)+2));
char *dst = r;
if (*src != '/') {
*dst++ = '/';
}
char *bt = dst;
char *bt2 = dst;
int dot = 0;
while (*src) {