Welcome to things Brie learned!

The structure for this site is based on Simon Willison's TIL project. I forked his work and then added Tailwind, Flowbite, Wickedblocks and lots of emoji. The source for these snippets can be found in the bbbbbrie/til repository. You may also enjoy my blog.

Search TIL snippets

Browse by topic: ansible 1 · archivebox 1 · aws 2 · css 1 · csv 2 · curl 1 · datasette 5 · emoji 1 · fossil 3 · git 1 · github 1 · gitlab 2 · gitleaks 1 · graphql 4 · gunicorn 1 · http 2 · imagemagick 1 · javascript 1 · jq 1 · k8s 5 · ldap 1 · linux 2 · rsync 1 · saml 1 · sql 1 · sqlite 1 · ssh 1 · vim 1

Recent TILs

aws SaaS Providers using AWS PrivateLink - 2023-11-15

AWS PrivateLink | Establish connectivity between VPCs and AWS services without exposing data to the internet …


graphql HOWTO Generate the GitLab GraphQL Schema - 2023-10-15

(This assumes some familiarity with feature development for GitLab.)


http Up and running with Burp Suite alternative: Hetty - 2023-10-14

Hetty is an HTTP toolkit for security research.


archivebox Turn off the Wayback Machine Archive Method in archivebox - 2023-09-25

I ❤️ ArchiveBox. It's an open source self-hosted Web archiving solution. I use it for managing my 🔖 bookmarks, a task that I care a lot about. …


rsync Ask rsync to respect .gitignore - 2023-09-10

It is possible to ask rsync to respect .gitignore when transferring data with the --filter switch. …


git Find current git signing key + scope with git config - 2023-07-29

I switched back to an old laptop and was having trouble with git commit complaining about the passphrase I was using. It was the correct passphrase -- for a different key. I spent a little time with git config to record a few queries for how to find the current git signing key. …


ansible Generate sample ansible.cfg config file - 2023-05-13

I wanted to quiet Ansible's Interpreter Discovery warning in a barebones project that had no ansible.cfg file. The docs suggested: …


vim HOWTO Use Vim to open a file right at the line number you specify - 2023-05-10

Sometimes, you want to open a file right at the exact line you want to edit. …


linux Specify the time zone to use with the date command - 2023-05-10

Populate $TZ correctly and date will tell you the time in a different time zone. …


imagemagick ImageMagick: Make image background transparent - 2023-04-22

Over the years, I have come to love the flexibility and power of ImageMagick. I have very few ImageMagick incantations memorized but I know when it can help and there are examples galore. In this TIL, I record the ImageMagick incantation I borrowed from this forum post to make an image have a transparent background for an important purpose. …


graphql Observe query complexity with GitLab's GraphQL API - 2023-04-15

We can use the queryComplexity query to get some information about the complexity of the query that is being executed. You would add this to your query to include the informaiton about the complexity: …


k8s Recover GKE kubeconfig - 2023-03-31

I found myself needing to teach kubectl how to connect to a particular GKE cluster -- fast. ⚡️ …


k8s --- - 2023-03-31

I found myself needing to teach kubectl how to connect to a particular GKE cluster -- fast. ⚡️ …


emoji Insert emoji on macOS -- without a mouse or extra software - 2023-03-18

I was very excited to learn that macOS supports adding emoji without the use of a mouse or a third-party app. It's awkward but it works: …


fossil HOWTO (actually) log out of the Fossil UI - 2023-03-18

(Fossil is a free and open source, simple, high-reliability, distributed software configuration management system with some cool features like a built-in Web interface. Learn more.) …


sql Frequency analysis in SQL - 2023-03-14

I pipe stuff to an incantation of uniq -c | sort fairly often. For example, to take a look at what folders have Markdown files, I use: …


gitlab Create scoped project labels via GraphQL - 2023-03-12

Since we are making changes, this will require a GraphQL mutation. You can follow along at gitlab.com/-/graphql-explorer. …


gitlab GraphQL hello, world with Query.echo - 2023-03-11

To follow along, browse to gitlab.com/-/graphql-explorer when you are already logged into GitLab. …


fossil Explore fossil SQLite database with Datasette - 2023-03-11

Since Fossil is backed by an SQLite database, we can use tools like Datasette to explore and interact with the fossil data. …


fossil Use fossil to automatically push to git - 2023-03-11

The Fossil docs have a guide on mirroring a Fossil repository with GitHub. First things first: fossil offers SQLite-based distributed version control and a bunch of other cool features. I followed the guide to get the git export functionality working. I build on the guide by: …


csv Simple CSV to SQLite Recipe - 2023-03-04

I do this often enough that I want to have it written down for easy reference. …


k8s Using Kompose to generate Kubernetes manifests for Python Flask apps - 2023-02-22

This sounds like a place where kompose can shine. ☀️ …


gitleaks Tell gitleaks to ignore a secret - 2023-01-02

Imagine you have a file with a line like this: …


github Accessing a secret in a GitHub Action - 2023-01-02

I'm setting up git scraping to keep track of how many songs I have scrobbed on last.fm. I forked this project and started modifying .github/workflows/scrape.yml to meet my needs. The last.fm docs for user.getInfo say that api_key is Required. How can I store my API key as a secret and access it in scrape.yml? The docs have a section on accessing the secret in bash. In the end, the line that uses the secret looks like this: …


http TIL about Cloudflare Radar - 2022-12-31

The Cloudflare Radar dashboard has some interesting data about traffic volume, activity, trends and comparisons. It's a really interesting site with an API available. For traffic seen by Cloudflare, they show cool things like: …


ssh Verify your SSH key passphrase - 2022-12-30

I was working through The New Stack's guide to signing git commits with SSH keys and I needed to make sure that the passphrase I was using was the right one. I wanted an elegant way to check this and I found: …


datasette Configure datasette to automatically assign an available port - 2022-12-27

Getting a working Datasette Web interface with something as simple as datasette whatever.db is awesome! …


graphql View Security Scanners enabled in a given project via the GitLab GraphAL API - 2022-12-26

In response, I get: …


graphql Get GraphQL Snippets via GitLab GraphQL API - 2022-12-26

Here is how to get started retrieving the public snippets for a particular user: …


datasette Web UI for searching code with datasette and ripgrep - 2022-12-23

This one is lightning fast. …