sohooo

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• PostgreSQL is the worlds’ best database
• Hacker News discussion

Background and Cron Jobs

• https://github.com/citusdata/pg_cron

sohooo

#!/bin/bash
# Jenkins Configuraitons Directory
cd $JENKINS_HOME

# Add general configurations, job configurations, and user content
git add -- *.xml jobs/*/*.xml userContent/* ansible/*

# only add user configurations if they exist
if [ -d users ]; then
    user_configs=`ls users/*/config.xml`

sohooo

# .dotvim files
git clone http://github.com/sohooo/dotvim2.git ~/.dotvim
vim -u ~/.dotvim/vimrc -c PlugInstall

# colorized cat
wget -c https://github.com/owenthereal/ccat/releases/download/v1.1.0/linux-amd64-1.1.0.tar.gz -O - | tar -xz
mkdir -p ~/.local/bin
cp -v ~/linux-amd64-1.1.0/ccat ~/.local/bin

# install lens

sohooo

inoremap <silent> <Bar>   <Bar><Esc>:call <SID>align()<CR>a

function! s:align()
  let p = '^\s*|\s.*\s|\s*$'
  if exists(':Tabularize') && getline('.') =~# '^\s*|' && (getline(line('.')-1) =~# p || getline(line('.')+1) =~# p)
    let column = strlen(substitute(getline('.')[0:col('.')],'[^|]','','g'))
    let position = strlen(matchstr(getline('.')[0:col('.')],'.*|\s*\zs.*'))
    Tabularize/|/l1
    normal! 0
    call search(repeat('[^|]*|',column).'\s\{-\}'.repeat('.',position),'ce',line('.'))

sohooo

# building Ruby versions on Vagrant box
#
# https://github.com/rbenv/ruby-build
#
# booting vagrant box
cd ~/Code/boxes/centos7
vagrant up
vagrant ssh

# install ruby-build

sohooo

# useful defaults settings

# delete Timemachine local backups
# https://github.com/mathiasbynens/dotfiles/issues/842
tmutil listlocalsnapshots 
tmutil deletelocalsnapshots 2019-02-16-080424

# delete all snapshots
for snapshot in $(tmutil listlocalsnapshots /); do
  timestamp=$(echo $snapshot | cut -d. -f4)

sohooo

#!/usr/bin/env ruby

# organize-av-files - Organizes files playable by mplayer
# into 'saves', 'deletes', and 'undecideds' subdirectories.
#
# stored at:
# https://gist.github.com/keithrbennett/4d9953e66ea35e2c52abae52650ebb1b


require 'date'

sohooo

# EasyColors
if [ ${libout_color:-1} -eq 1 ]; then
  DEF_COLOR="\x1b[0m"
  BLUE="\x1b[34;01m"
  CYAN="\x1b[36;01m"
  GREEN="\x1b[32;01m"
  RED="\x1b[31;01m"
  GRAY="\x1b[37;01m"
  YELLOW="\x1b[33;01m"
fi

sohooo

require 'sequel'
DB = Sequel.connect(:adapter=>'odbc',:driver=>'SQL Server Native Client 10.0',:server=>'localhost',:port=>1433, :uid=>'myuser',:pwd=>'mypass',:db_type=>'mssql')

DB.fetch("SELECT * FROM artist") do |row|
  puts row
end

sohooo

require 'sequel'
DB = Sequel.connect(:adapter=>'odbc',:driver=>'SQL Server Native Client 10.0',:server=>'localhost',:port=>1433, :uid=>'myuser',:pwd=>'mypass',:db_type=>'mssql')

DB.fetch("SELECT * FROM artist") do |row|
  puts row
end