Pinning your dependencies in Javascript projects
Get closer to reproducible builds in your Javascript projects
✍️ Articles
I write about maths, programming, and other things I find interesting.
The transform_null_equals configuration in Postgres
How to make null = null evaluate to true in Postgres
Modelling discriminated unions in Postgres
How to model discriminated unions in SQL
Interesting things I've learned: Roman numerals in Postgres
I have XCIX problems, but Roman numerals ain't one
Interesting things I've learned: Counting nulls and non-nulls in Postgres
The num_nonnulls and num_nulls functions in Postgres
Interesting things I've learned: The FILTER clause in SQL
A useful SQL keyword that I didn't know about until recently.
An unusual Google Keyboard bug
Why backspaces sometimes don't work the way they should.
Useful built-in macOS command-line utilities
macOS comes with a lot of built-in utilities. Here's a list of some that I find interesting.
Avoid capital letters in Postgres names
Because Postgres have counterintuitive rules around case.
Initial thoughts on using Cursor
This article contains my initial thoughts on using Cursor, an AI-powered code editor.
Interesting things I've learned: Oct 2024
This article contains a collection of interesting things I've learned while working on my projects.
Smart constructors
This article explains smart constructors, a design pattern that ensures data validity by validating values during object construction rather than through repeated checks.
A gentle introduction to functors
This article introduces the concept of functors, a fundamental concept in functional programming that allows for mapping over wrapped types.
Set up SSH access for an Ubuntu server
This guide explains how to set up ssh access for an Ubuntu server.
On professional communications
This article discusses the concept of professional communications, emphasizing the importance of empathy and self-awareness in effective communication.
A reflection on my master's course
This article reflects on the my experience of pursuing a Master's degree at ANU.