todgru

SELECT pg_size_pretty (
     pg_total_relation_size ('"camelCaseTableName"')
);
    
SELECT pg_size_pretty (
    pg_database_size ('lowercaseddbname')
);

todgru

Remote, Office not Required https://basecamp.com/books/remote

1. If I can't see them, how do I know they're working?

(pg 54) People have amazing ability to live down to low expectations, or live up to high expectations. If there are trust issues with employees, then the employer made poor hiring decision. Employer/Employee trust is fundamental.

2. People’s homes are full of distractions

(pg 58) being easily distracted from work could mean the work is not well defined or the task is menial, pointless. Might be a chance that if someone feels like this, others on the team might feel the same.

todgru

Vpn-ception

Ideally, I like to run one vpn. I have OpenVPN/PiVPN working just fine.

On the PiVPN server, I'd like to run a VPN client to my work office.

It's difficult to get Cisco VPN client and Tunnelblick clients running side-by-side on the same machine, ie my local dev machine, without a seeming hack(see below).

I have it working locally.

• Cisco AnyConnect Client connect to work VPN. Only specific resources are made available. All other traffic is routed as normal.

todgru

• after image is flashed using Etcher, cd /Volumes/boot.
• Then add ssh file to root. touch ssh.
• connect network cable between os x computer and raspberry pi. boot the raspberry pi.
• wait a minute.
• then ssh pi@raspberrypi.local

That's it. No need for a screen, keyboard or any other device to get into the pi. :)

todgru

trim an mp3

I record mp3s from a few streams. Sometimes the recordings do not stop on schedule. This command allows me to trim or trucate the mp3 file.

ffmpeg -i infile.mp3 -vn -acodec copy -ss 00:00:00 -t 01:00:34 outfile.mp3

installation on ubuntu 14.04

todgru

paclink-unix

install ax25 https://gist.github.com/todgru/b2e742fea3991c6c242c5ea17b4cfaaf

apt-get install postfix postfix libdb-dev libglib2.0-0 zlib1g-dev libncurses5-dev libdb5.3-dev libgmime-2.6-dev -y
git clone https://github.com/nwdigitalradio/paclink-unix
cd paclink-unix/
./autogen.sh --enable-postfix

todgru

ax25

from here: https://github.com/ve7fet/linuxax25

each install had a list of dependencies.

• ax25apps
• ax25tools
• libax25

todgru

https://movr0.com/2016/08/19/convert-raspberry-pi-123-to-f2fs/

todgru

Jellyfin setup on Raspberry Pi 3 Debian 9(stretch)

Jellyfin is the open source version of Emby.

install docker

wget -nv -O- https://get.docker.com/ | sh

todgru

SSL Cert

https://certbot.eff.org/lets-encrypt/debianother-nginx.html

This worked. For renewing the cert automatically, I used this in crontab:

23 0,12 * * * ./opt/certbot/certbot-auto renew --nginx