Datetime arithmetic in sqlite
To find out the # of minutes since a datetime in a sqlite table (example column jobend), do the below: select jobend, cast(((julianday(current_timestamp)-julianday(jobend))*1440) as int) as mins_passed from job Credits
Archive of posts filed under the Uncategorized category.
Downloading envoy for linux
Looking to download the envoy proxy? Try here – but note it needs glibc 2.18, so no Centos 7.
View TLS peerchain in Python 3
A quick hack based mainly on someone else’s work:https://github.com/jamespo/commandmisc/blob/master/scripts/peerchain
Stop emacs paste from indenting, eg in python-mode
Put this in your .emacs: (add-hook ‘python-mode-hook ‘(lambda () (electric-indent-local-mode -1))
unbound-control not working?
Add the remote-control section at the bottom of your conf file
Access your UTM VM over ssh
Go to Network Section for the Guest & create a new Port Forward from guest port 22 to host port 22022 (or whatever port you have free) Save & start up the VM Open terminal and ssh to your local forwarded port
Beautiful heatsink for the Raspberry Pi
https://desalvoinc.com/collections/frontpage/products/phineas-case-for-raspberry-pi-4
Memory Upgrades from Mr Memory
Very pleased with my recent order from Mr Memory. The DIMM they sent me didn’t work but the return & replacement process was free & efficient.
Split long output into 2 columns
With unsurprisingly, the UNIX “columns” command (will need to install autogen package). du -hc –max-depth=1 . | columns
Ceefax is back!
https://zxnet.co.uk/teletext/viewer/?channel=2&page=100