Skip to content

Instantly share code, notes, and snippets.

View vredens's full-sized avatar

JB Ribeiro vredens

  • EerieSoft
  • Aveiro
View GitHub Profile
@vredens
vredens / main.go
Created October 21, 2021 09:06
Go struct memory packing
// taken from https://play.golang.org/p/MBXg4UBOerp
package main
import (
"fmt"
"reflect"
)
type struct1 struct {
field1 bool
@vredens
vredens / postgres_queries_and_commands.sql
Last active July 26, 2018 15:18 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), 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%'
@vredens
vredens / jq-tail
Created June 15, 2018 21:10
jq script aimed at log tailing with support for non-json lines and allow adding ad-hoc filters
#!/bin/bash
# Usage:
# > tail -F mylog.log 2>&1 | jq-tail
# > tail -F mylog.log 2>&1 | jq-tail '[ .timestamp, .message, .error ]'
if [ -z "$1" ]; then
jq -R -c '[., fromjson?] | if .[1] == null then ">>>>>>> " + .[0] else .[1] end'
else
jq -R -c '[., fromjson?] | if .[1] == null then ">>>>>>> " + .[0] else (.[1] | '"$@"' ) end'
@vredens
vredens / keybase.md
Created February 27, 2018 20:55
keybase.md

Keybase proof

I hereby claim:

  • I am vredens on github.
  • I am vredens (https://keybase.io/vredens) on keybase.
  • I have a public key ASDk4MeR5gWX_LKCNqMWvTuD0ZA9e1SvK7aW2F3Ovn3qIAo

To claim this, I am signing this object:

@vredens
vredens / .bash_ext
Last active January 31, 2019 14:06
My bash scripts
# enable perlbrew if it is installed
[ -f ~/perl5/perlbrew/etc/bashrc ] && source ~/perl5/perlbrew/etc/bashrc
# Java
export JAVA_HOME=/opt/java
# dynamic PATH
i=0
__paths=()
__paths[((i++))]=/sbin
@vredens
vredens / .bashrc
Last active July 28, 2017 21:13
Dynamic GOPATH when changing directory (cd alias)
export OGOPATH=$GOPATH
function __gopath_find {
cd "$@"
tmp=$(pwd)
while [[ ! -z "$tmp" && "$tmp" != "/" ]]; do
if [ -d $tmp/src ]; then
if [ -z "$OGOPATH" ]; then
export OGOPATH=$GOPATH
fi
export GOPATH=$OGOPATH:$tmp
#!/bin/bash
# This script is what I run when installing a new Debian VM for work which typically means running docker.
# It installs
# - docker
# - dev tools such as git, geany, htop, mcrypt, vim
# - TODO
# https://golang.org/dl/
function query_user {