Finding the last N rows of a database table in SQL
Sometimes I stumble across cool things while solving other problems. Although, often what I think is a neat trick is just my lack of experience in the given ...
Recent posts
Putting book part information into page headers in LaTeX
A recent question on the LaTeX subreddit prompted me to learn more about headings in two-sided LaTeX documents and how to control their content.
Announcing Algorithm::CurveFit version 1.06
After having blogged about a bug (and its fix) in Algorithm::CurveFit, as well as giving a talk about it at the 2024 London Perl and Raku Workshop, I’ve fina...
Calculating the volume of a cup via rotational solids
As part of tutoring physics and maths to high school students, I sometimes write up deep-dive explanations of questions arising during lessons. This post dis...
Table subset searching with a list and DBIx::Class
When searching for a subset of rows in a database table by using a list of entries in one of its columns, one can use the WHERE column_name IN list syntax in...