January 22, 2022March 10, 2023Computing, Programming Django Development and Staging I have two boxes: dev and production. I need a very simple method for working on the dev machine and then pushing […]
January 19, 2022January 25, 2022Computing, Internet Of Things, Programming Postgres Tricks Log-the-frick-in sudo -u postgres psql dbname # typical root user psql -h localhost -U user -W dbname # default host is unix-domain […]
January 19, 2022January 19, 2022Computing, Programming Why the hell can’t I login to PostgreSQL? Some possible reasons and solutions Wrong host Use the “-h” flag: psql -h localhost -U phisaver –password Wrong syntax Use -U and […]
January 17, 2022January 17, 2022Computing, Programming Periodic Emails with Django Rough notes on meeting these requirements: Using Django Send weekly / daily emails to someone Log results Be robust and simple Packages […]
March 5, 2021June 16, 2021Computing, Programming linux commands Test OpenVPN server on it’s standard UDP port telnet is so 2020 so use nc which does UDP too -v verbose -z […]
November 27, 2020November 27, 2020Computing, Programming Debugging Pi from VSCode There’s a few tutorials and references for debugging a python program on a remote (e.g. pi) computer. I had to fiddle a […]
November 6, 2019February 11, 2022Energy Monitoring, Programming Access Grafana without a login screen Unlike Grafana 5, we can’t use the ‘old’ method of a proxy login to get a cookie for semi-permanent login. This post […]
July 8, 2019September 6, 2019Computing, Internet Of Things, Programming ESP32 Development Environment – Bleeding Edge ESP-IDF v4.1 with cmake There’s a few options to program the esp32: Arduino IDE : good. Heaps of support and tutorials. Some key limitations for ESP32, […]
June 11, 2019June 12, 2019Computing, Internet Of Things, Programming WebApp Development for a Esp32 Arduino Sketch AJAX or websockets will allow nicer development. I’m trying BootStrap to get a tidy interface. Bootply.com and layitout.com enable you to easily […]
February 19, 2019February 19, 2019Programming, Uncategorized VBA Regex Typical Replacement Example Dim objRegExp As Object ‘ RegExp using Microsoft VBScript 5.5 Set objRegExp = CreateObject(vbscript.regexp) Dim res As String res […]