Bloody CORS and Grafana
Breaking news : see the solution where I asked on community.grafana . Spoiler: add a slash. There's a billion queries about this topic. Here's some notes. I don't understand the information flow. Maybe writing it …
ARTICLES
Software
Multi-Tenant Grafana with DRF
While looking at Grafana Multi-Tenant arrangements, I realised it's problematic to have a multi-tenant SQL database accessed by Grafana. One solution is to use the X-GRAFANA-USER. If we can trust this header it will allow …
Django Object-level Permissions with DRF and Rules
Finding a simple way to limit API users' permissions to certain objects. We want an API via Django, so we use DRF. We want object-level permissions so we use django-rules . There are other options …
VSCode Python Setup++
This is based on this great boilerplate for setting up Python. I've adapted for my use: VSCode Linux on Ubuntu Environment Use direnv and you'll get your enviro variable set based on your cwd. Use …
Winforms Databinding... not confusing at all
So you wanna use WinForms (e.g. natively or in a Word Add-In) in C# / VB? Great, there's good support for databinding controls to objects. And it's fucked until it works, then it's great. General …
Signing Windows Apps
Background: I've created some windows apps (winforms with .Net 4 and a WinWord x64 Add-In). These are packaged up into .msi installers by Advanced Installer. I need to digitally sign them to allow installation with …
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 to production. Environment Use direnv to maintain environment based on directory. Use two …
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 (not tcp to localhost) More detail here. Create read-only user # login to …
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 -W flags for user and password psql -U fred -W > prompts …
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 Based on stars, maintenance, simplicity in 2021 post_office for emails: it may be …
Wordpress Setup (and Migration)
Wordpress: meh. But anyway: # # server1 # scp -r /var/html/www/sitey/ server2:. mysqldump sitey-db-name -u root -p > sitey-sql scp sitey-sql server2:. # # server2 # mv sitey /var/html/www/ # for nginx. owned by user …
InfluxDB v2 (Flux) Setup for Energy and Power Data from Iotawatt
This are my notes on setting up InfluxDBv2 for storing Iotawatt power readings. Specifically I needed to: Transition a live site from InfluxDB1 to InfluxDB2 Setup InfluxDBv2 to use InfluxDBv1 api and auth, so that …