trauber trauber

Notes for Sqlite Blog

Create a sqlite timestring with date:

date +'%Y-%m-%d %H:%M'

Read text file into a blob:

Timetrap TSV Formatter

Hacked from csv.rb.

module Timetrap
  module Formatters
    class Tsv
 attr_reader :output

Latest Awk for My Timetrap/Pandoc/LaTeX Invoicing System

Output is YAML for use as Pandoc metadata. The YAML contains LaTeX strings. \quad and \hphantom come in handy for spacing LaTeX item lists in the invoice template I'm using.

# Process tsv generated from timetrap.rb display output

Processing Timetrap Output for Invoicing

Process and Awk Draft

t display --format csv > tmp.csv

QandDShrink a PDF with GS

I imagine mileage may vary on this but I was able to shrink a 15mb PDF to 2.5mb.


$ pdf2ps large.pdf large.ps

$ ps2pdf large.ps small.pdf

Hah! Screenshots in ratpoison.

###Make prtscreen work, as long as in ratpoison mode. "import" is an Imagemagick command.
   bind Print exec import -window root png:$HOME/xwd-$(date +%s)$$.png

This is from https://en.wikibooks.org/wiki/Using_Ratpoison/Example_Config

Remove Photos from Vcards

Good ole ex matches multiple lines very easily.

ex -n test.vcf +'g/PHOTO/,/^$/d' +wq

mutt -e 'set content_type=text/html' -s 'subject' recip@host.com < file.html

Create in ~/.mutt/pass with contents:

set my_pass = "password"

Encrypt the file:


	# Use find and file to crawl for files with mime-type image/jpeg or image/png.
	# Awk isolates file names.
	# rjgpcom gets comments, if any.
	# jo wraps everything up into json for jsongallery.
	#
	# https://jpmens.net/2016/03/05/a-shell-command-to-create-json-jo
	# https://github.com/mariobox/jsongallery