This is my .vimrc
, I find it benefitial to use this where I do development to normalise my editor across different operating systems, and to enable some useful untapped features to make Vim feel a bit less prehistoric.
my Vim
Migrate Static Site to Digital Ocean Web App Platform
Digital Ocean released a new App Platform for running serverless apps with support in their free-tier for static sites. There are two approaches to hosting a static site on the App Platform, either include the build process in the repo and allow App Platform to build your site, or use a branch/repo with only the HTML output.
Read more →Remote PostgreSQL using local PgAdmin inside Docker
PostgreSQL management is a never-ending rabbit hole and in my case I just want to create a user, a database and set up some ownership.. without resorting to SQL or complex configuration frameworks.
Read more →SSH port forwarding
The following command connects to our server and forwards a specific port on our local machine to the server. In this case we forward port 5432
which belongs to PostgreSQL, so when we connect to localhost:5432
on the desktop, the connection is forwarded through the secure tunnel to the server.
OAuth with Mastodon & Pleroma
Mastodon & Pleroma are federated social networks, in order to pull statistics I needed to use OAuth2.
Read more →Supercomputers in media
I thought it would be fun to gather together all the amazing looking fictional supercomputers!
Read more →Dynamically load fonts
Windows 10 Revamp
My notes on wiping Windows 10, which configuration options to watch out for and a list of useful programs. The whole process of wiping, installing and provisioning with a basic set of programs can be complete in an hour with a fast Solid-State Drive and modern hardware.
Read more →BeatSaber mods (Custom songs & Third-Person)
More fun with BeatSaber! Mods provide more stats, effects and even allow a third-person mode for streaming.
Read more →Windows Terminal - Change default profile
Mattermost - Self-Hosted Slack
Mattermost is an accurate clone of Slack, providing open-source self-hosted team chat. Mattermost Inc produces client apps for most platforms, the back-end is written in Go so I imagine even a single instance should scale rather well.
Read more →Useful Unixisms
Here’s a list of useful piped commands or just commands for which I need a refresher on which arguments to use. For example, using Awk to print between two known lines, or seleting a line in sed are good examples of infrequently used commands which are really useful.
Read more →Pixelfed - self-hosted & federated photo hosting
Github CLI headless install
Package Management for .deb & .rpm for Debian, Ubuntu & Red Hat, CentOS, Suse
A smattering of useful commands for dealing with package managers!
Read more →Run for every updated file
Using inotifywait
to watch for file changes recursively in the current directory. I use $CHECK
to ignore unwanted directories and filetypes.
Telegraf & OhmGraphite on Windows 10
Download the Telegraf client from influxdata.com, extract the telegraf directory to a sensible place and edit telegraf.conf
.
TimescaleDB SQL in Grafana
Grafana supports SQL through MySQL/MariaDB, PostgreSQL & SQL Server. Additionally Grafana supports the PostgreSQL extension TimescaleDB, this database is the best fit of all the SQL databases for Grafana since it is built specifically for large-scale time-series datasets.
Read more →SFTP instead of SCP
SCP suffered from weak input validation for decades until CVE-2019-6111, the maintainers recommended using SFTP until patched versions can be deployed. I, like many others, were reminded SFTP existed!
Read more →