Blog
Tag Search
2026
- 2026-01-22 Generated Columns: Dealing with Functions on Indexed Columns (MariaDB)
- 2026-01-18 Summary Tables in MariaDB: A case study
2025
- 2025-12-28 Deploying Mariadb into a Docker container
- 2025-12-23 Displaying a histogram with awk
- 2025-12-07 Using FORCE INDEX: When Low Cardinality Statistics Mislead the Optimizer (MariaDB)
- 2025-12-04 MariaDB: What is an Index Condition Pushdown, and how it can affect locking
- 2025-11-20 Understanding B+trees (by looking at the implementation)
- 2025-11-08 Secondary Indexes in MariaDB
- 2025-11-01 Understanding Block Nested Loop Joins in MariaDB
- 2025-10-26 MariaDB connection usage metrics
- 2025-10-18 Pivoting tables in MariaDB (and awk)
- 2025-10-09 Practical patterns for large deletes in MariaDB
- 2025-10-05 Git: purging binary blobs from a git repo
- 2025-09-07 set -euo pipefail to make your bash scripts safer .. or not
- 2025-08-12 Python: Visualising data with Matplotlib (Kronig-Penney model)
- 2025-08-04 Python: Distributing a custom extension
- 2025-08-03 Python: Creating and Importing a custom extension
- 2025-07-28 Using PHP Closures to access private methods
- 2025-06-13 Sourcing bash script variables from SQL
- 2025-05-31 Beginner’s guide to database backups with ZFS
- 2025-05-28 bash getopts: manage command line options in your scripts
- 2025-05-21 Gentle Introduction to sed
- 2025-04-24 Intermediate awk: Counting Pattern Matches in Logs with Regex
- 2025-04-21 Intermediate awk: Log Slicing and Label-Based Extraction
- 2025-04-18 Setting up maxscale
2023
- 2023-12-03 Git: Understanding HEAD
- 2023-11-25 Dealing with too many connections error in MariaDB
- 2023-04-06 Beginner’s intro to awk (part 2 - practical examples)
- 2023-04-05 Beginner’s intro to awk (part 1 - the basics)
2022
- 2022-12-10 File descriptor leaks: how to spot and diagnose them
- 2022-11-23 Accessing a web service running on linux VM from host browser
- 2022-11-19 Adding and setting a custom resolution using xrandr
- 2022-11-14 Window splits in vim for test-driven work (for PHPUnit and SugarCRM)
- 2022-11-07 Vim: Customizing Comment Formatting (part 2 - converting line to block comments)
- 2022-11-06 Vim: Customizing Comment Formatting (part 1 - converting block to line comments)
- 2022-11-05 About this blog…