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
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
Looking to download the envoy proxy? Try here – but note it needs glibc 2.18, so no Centos 7.
A quick hack based mainly on someone else’s work:https://github.com/jamespo/commandmisc/blob/master/scripts/peerchain
Put this in your .emacs: (add-hook ‘python-mode-hook ‘(lambda () (electric-indent-local-mode -1))
Add the remote-control section at the bottom of your conf file
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
https://desalvoinc.com/collections/frontpage/products/phineas-case-for-raspberry-pi-4
Install Karabiner, enable the mouse device & import these rules: https://ke-complex-modifications.pqrs.org/#mouse_button
Sadly, Samsung seem to be winding down their SmartThings Zigbee/ZWave home automation setup and it has always been quite painful using devices that weren’t officially supported. I’ve recently migrated my non-SmartThings native devices to Zigbee2MQTT, here’s how I did it: Purchase a SBC, in my case an OrangePi 4 running Armbian/Ubuntu – but a Raspberry …
Continue reading ‘Migrating from SmartThings to Zigbee2MQTT with Home Assistant’ »
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.