Skip to content

Instantly share code, notes, and snippets.

View sebawebber's full-sized avatar
🏠
Working from home

Sebastian Webber sebawebber

🏠
Working from home
110 followers · 18 following
View GitHub Profile
@sebawebber
sebawebber / README.md
Last active February 19, 2019 02:36
go animal race

Race

small experiment on our go meetup.

tty-min

@sebawebber
sebawebber / pg-notify-parallel.go
Last active July 23, 2026 18:27
postgres listen/notifiy with golang and `go-pg`
package main
import (
"log"
"time"
"github.com/go-pg/pg"
)
const maxWorkers = 5
@sebawebber
sebawebber / ftpd.mtail
Last active January 4, 2019 20:48
mtail prog to parse vsftpd logs in xferlog format
hidden text FILENAME
counter log_ftp_files_processed_count by username, remote_host, transfer_type, direction
counter log_ftp_files_deleted_count by username, remote_host, transfer_type
counter log_ftp_files_incomplete_transfers_count by username, remote_host, transfer_type
FILENAME = getfilename()
## example file
### Fri Jan 4 12:55:27 2019 1 1.2.3.4 224 /path/to/file.CSV b _ o r user_name ftp 0 * c
@sebawebber
sebawebber / main.go
Created November 7, 2018 16:36
exemplo interface e testes #golang
package main
import (
"fmt"
)
type contrato interface {
Insert() string
}
@sebawebber
sebawebber / docker-compose.yml
Last active October 10, 2021 11:49
basic docker-compose for grafana and prometheus
version: '3.1'
volumes:
prometheus_data: {}
grafana_data: {}
services:
prometheus:
image: prom/prometheus
volumes:
@sebawebber
sebawebber / 0-update-test.sql
Last active May 9, 2018 20:35
update tests - to validate a pRest implementation
-- tuning used: https://www.pgconfig.org/#/tuning?total_ram=10&max_connections=100&environment_name=WEB&pg_version=10&os_type=Unix&arch=x86-64&drive_type=SSD&share_link=true
-- mbp pro 15", 500gb ssd, 16gb ram, i7 2,9ghz processor
\timing on
\pset null ~
\set max_rows 1000
DROP TABLE IF EXISTS load_test;
create table load_test (id serial primary key, name text, birth_date date, age int);
@sebawebber
sebawebber / compare-pg-lsn.rb
Last active March 20, 2018 13:52
Compare PostgreSQL LSN in ruby
# select pg_xlog_location_diff('951A/EA0F8000', '9518/1ECB6000');
# super_db=# select pg_xlog_location_diff('951A/EA0F8000', '9518/1ECB6000');
# pg_xlog_location_diff
# -----------------------
# 12000174080
# (1 row)
# super_db=# select pg_xlogfile_name('951A/EA0F8000'), pg_xlogfile_name('9518/1ECB6000');
# -[ RECORD 1 ]----+-------------------------
# pg_xlogfile_name | 000000030000951A000000EA
@sebawebber
sebawebber / create-ec2-instance-playbook.yml
Last active May 13, 2022 11:37
Create a EC2 instance with ansible-playbook
---
- hosts: localhost
connection: local
vars:
gather_facts: False
vars:
keypair: "my-keypair-name"
instance_type: m4.large
security_group:
- "vpc-group-1"
@sebawebber
sebawebber / teste.txt
Created April 1, 2017 00:28
teste com o search_path
sebastian=# create schema esquema_a;
CREATE SCHEMA
sebastian=# create schema esquema_b;
CREATE SCHEMA
sebastian=# create schema esquema_c;
CREATE SCHEMA
sebastian=# create schema esquema_d;
CREATE SCHEMA
sebastian=# create schema esquema_e;
CREATE SCHEMA
@sebawebber
sebawebber / vagrantfile.rb
Last active February 14, 2017 16:31
Ubuntu 16.04 vagrantfile with postgresql 9.5
# -*- mode: ruby -*-
# vi: set ft=ruby :
Vagrant.configure(2) do |config|
config.vm.box = "ubuntu/xenial64"
$script = <<SCRIPT
sudo echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -c | awk '{print $2}')-pgdg main" > /etc/apt/sources.list.d/pgdg.list