Performing group_concat queries over distinct values, with a custom delimiter, with SQLite (2 mins read).
How to avoid SQLite's DISTINCT aggregates must have exactly one argument error when performing a group_concat(distinct ...) with a custom delimiter.
Updating apk add definitions in Dockerfiles (3 mins read).
How to use Renovate's Custom Regex manager to extract apk add definitions in a Dockerfile, to allow managing (un)pinned packages.
Creating single-purpose RSS feeds with Hugo (2 mins read).
How to create a new RSS feed in Hugo for a single page's updates.
by 
Jamie Tanna
.
#blogumentation
#hugo.
Creating a test harness for validating Renovate Custom Datasource configuration (4 mins read).
How to set up a test harness to make it eaiser to modify scary looking JSONata transformations in your Renovate configuration.
Go 1.24's omitzero is another one of the best additions to the ecosystem in years (4 mins read).
Why I'm very excited about the JSON tag, omitzero, landing in Go 1.24.
by Jamie Tanna
.
#blogumentation
#go.
Go 1.24's go tool is one of the best additions to the ecosystem in years (8 mins read).
Why I'm very excited about go tool landing in Go 1.24.
by Jamie Tanna
.
#blogumentation
#go.
Getting access to rich-text data from the clipboard (on Linux) (1 mins read).
How to use xclip to retrieve rich-text output from the clipboard.
Why is zsh no longer storing history? (1 mins read).
Spoiler: you may be missing both HISTSIZE and SAVEHIST variables.
by Jamie Tanna
.
#blogumentation
#zsh.
Accessing private Go modules in a Docker container (3 mins read).
How to use a Personal Access Token or SSH to access a private Go module, from a Docker container.
by Jamie Tanna
.
#blogumentation
#go
#docker.
Getting all comments from a given user on a GitHub Discussion (2 mins read).
How to use the GitHub GraphQL API to retrieve all comments from top-level or reply comments on a GitHub Discussion.
What level of access do I have on that GitHub repository? (2 mins read).
How to check, via the GitHub API, what access a given user has on a repository.
Blocking 'Similar' and 'Because you like ...' suggestions on reddit with uBlock Origin (1 mins read).
How to use uBlock Origin to remove reddit's suggestions in your home feed.
Some useful SQL(ite) tips I've learned (5 mins read).
A collection of SQLite snippets I've picked up recently to improve my queries.
Gotcha: PersistentPostRunE only runs on successful commands in Cobra (3 mins read).
A possible gotcha when using Cobra to perform cleanup in a PersistentPostRunE.
by Jamie Tanna
.
#blogumentation
#go.
Creating a Neovim plugin for my standup updates (3 mins read).
Documenting some of my thoughts about writing a (Python) Neovim plugin.
Creating a private mirror of the Renovate docs (5 mins read).
How to set up a copy of Renovate's documentation, pinned to an older version, for your organisation.
Lessons learned adding OpenTelemetry to a (Cobra) command-line Go tool (10 mins read).
Some reflections on what I've found good and not so good about instrumenting a command-line tool with OpenTelemetry.
by Jamie Tanna
.
#blogumentation
#go
#command-line
#opentelemetry
#dependency-management-data.
Summarising the skipReasons for Renovate data exports (2 mins read).
How to work out what skipReasons you have for your Renovate package data.
by Jamie Tanna
.
#blogumentation
#renovate
#dependency-management-data.
How to diff two datetimes (1 mins read).
How to get the number of seconds, minutes, and a human-readable time comparison between two datetimes.
by Jamie Tanna
.
#blogumentation.
Why has Firefox 133 lost all my tabs? (2 mins read).
Recounting an issue I'm seeing with Firefox 133 where it creates a new profile, and how to resolve it.
Converting a Reveal.js slide deck to PDF (1 mins read).
How to convert a Reveal.js slide deck to a PDF, using Decktape.
Getting symlinks to work with a git clone on Mac (2 mins read).
How to restore symlinks in a previously cloned repository, where core.symlinks=false.
by Jamie Tanna
.
#blogumentation
#git
#mac.
Using a separate Go module for your tools.go (2 mins read).
How to use the tools.go pattern to source-track your Go tool dependencies, but without polluting your top-level go.mod.
by Jamie Tanna
.
#blogumentation
#go.
Utilising Renovate's local platform to test more easily (4 mins read).
How to use Renovate's local platform for validating configuration changes more easily.
Nested teams in GitHub don't give you the control you think they do (2 mins read).
Some pain points when using nested teams on GitHub.
Forcing pacman to perform post-upgrade tasks if it's failed part way through (2 mins read).
How I ended up recovering from my Arch Linux upgrade crashing part way through the post-upgrade hooks.
Gotcha: SXHKD doesn't like comments (in bindings) (1 mins read).
Why your SXHKD bindings may be silently ignored
by Jamie Tanna
.
#blogumentation
#sxhkd.
How to get the next window created set to floating in BSPWM (1 mins read).
How to tell BSPWM that the next window created should be floating.
by Jamie Tanna
.
#blogumentation
#bspwm.
Why isn't Hugo regenerating my SCSS files? (1 mins read).
How to ensure you're using the right Hugo version to build SCSS files.
by Jamie Tanna
.
#blogumentation
#hugo.
Why can't I use a comma with gcloud? (1 mins read).
How to resolve commas being ignored when interacting with gcloud, and how to escape them.
Using Spotless to auto-format Gradle Verification Metadata (3 mins read).
How to use Spotless to allow manual changes to the Gradle Verification Metadata to be auto-formatted as if Gradle generated it.
Common issues faced with execing an executable on Linux (2 mins read).
Some common issues you may face, with esoteric error messages, and how to fix them.
by Jamie Tanna
.
#blogumentation
#shell
#command-line
#linux.
Migrating Renovate bots, while keeping existing PRs updated (2 mins read).
How to migrate between two Renovate bot accounts, in the case you want to do a 'big bang rollout'.
Manually triggering a Buildkite pipeline for a fork (1 mins read).
How to trigger a Buildkite pipeline to run on a fork, if you have access to trigger a build.
Dynamically querying EndOfLife.date data for internal packages with Open Policy Agent and Dependency Management Data (3 mins read).
How you can retrieve End-of-Life data via EndOfLife.date using Dependency Management Data's Policies functionality.
by Jamie Tanna
.
#dependency-management-data
#blogumentation
#open-policy-agent.
Creating a test harness for validating Renovate regex manager rules (4 mins read).
How to set up a test harness to make it eaiser to modify scary looking regexes in your Renovate configuration.
Modifying the response body of an httputil.ReverseProxy response (2 mins read).
How to modify the response from a httputil.ReverseProxy before it goes back to the caller.
by Jamie Tanna
.
#blogumentation
#go.
Performing cross-database queries with SQLite (2 mins read).
How to query multiple database files with SQLite.
Using Go's database/sql to query an arbitrary columns of unknown type(s) (3 mins read).
How you can query an unknown number of columns, of unknown types, with Go's SQL package.
by Jamie Tanna
.
#blogumentation
#go.
My workflow for writing SQL(ite) queries (2024 edition) (4 mins read).
Writing about my recent workflow for writing, executing, and sharing SQL queries with others.
by Jamie Tanna
.
#blogumentation
#sql
#sqlite
#neovim
#datasette
#lsp.
Calculating the GitHub API's sha representation of a local file (2 mins read).
How to locally calculate the same sha of a given file, so you can compare it against the GitHub API's representation.
by Jamie Tanna
.
#blogumentation
#github
#go.
Making it easier to schedule cross-timezones, with the tz CLI (3 mins read).
Writing a command-line tool with Charm's Go libraries to compare the suitability of meetings across timezones.
by Jamie Tanna
.
#blogumentation
#command-line
#go
#charm
#elastic
#remote-work.
Installing Google Cloud CLI components on Arch Linux (2 mins read).
How to install gcloud components using pacman, instead of using the officially supported method.
by Jamie Tanna
.
#blogumentation
#arch-linux
#google-cloud
#serverless.
Lessons learned self-hosting Renovate (13 mins read).
What I've learned operating Renovate as a self-hosted app on GitHub Actions, GitLab CI, and the Mend Renovate Community Edition, and some tips for getting started
Automating the syncing of files between repos with GitHub Actions (2 mins read).
Creating a GitHub Action workflow to periodically update vendored files which are out-of-sync between GitHub repos.
Querying your organisation's Renovate configuration using SQL(ite) (3 mins read).
A new tool, renovate-config-sqlite to pull Renovate configuration into an SQLite database.
Why I recommend Renovate over any other dependency update tools (10 mins read).
Explaining why Renovate is going to be my solution to keeping up-to-date with dependencies and it's not likely to change any time soon.
by Jamie Tanna
.
#blogumentation
#renovate
#dependabot
#snyk.
What routes is my http.ServeMux listening for? (2 mins read).
How to fairly quickly list the routes that your http.ServeMux is handling, pre- and post-Go 1.22.
by Jamie Tanna
.
#blogumentation
#go.
Why is Go 1.22's enhanced routing not working for me? (2 mins read).
Why you may be receiving 404 page not found errors when using Go's new enhanced routing in Go 1.22.
by Jamie Tanna
.
#blogumentation
#go.
Gotcha: Don't try and authenticate to URLs generated by GitHub Actions Artifacts v4 (3 mins read).
Why you may be receiving errors when trying to authenticate to download GitHub Actions Artifacts using the v4 Actions.
You're currently viewing page 1 of 11, of 509 posts.