articles
Essays & longer thoughts
- Postgres names are surprisingly flexible2024·dec 4Postgres names are surprisingly flexibleSELECT * FROM 😱
- Useful Postgres features you might not know about2024·dec 2Useful Postgres features you might not know aboutPostgres features that may fly under the radar.
- CREATE TABLE ... LIKE in Postgres2024·nov 29CREATE TABLE ... LIKE in PostgresA quick way to copy a table's structure
- Pinning your dependencies in Javascript projects2024·nov 21Pinning your dependencies in Javascript projectsGet closer to reproducible builds in your Javascript projects
- The transform_null_equals configuration in Postgres2024·nov 17The transform_null_equals configuration in PostgresHow to make null = null evaluate to true in Postgres
- Modelling discriminated unions in Postgres2024·nov 16Modelling discriminated unions in PostgresHow to model discriminated unions in SQL
- Interesting things I've learned: Roman numerals in Postgres2024·nov 15Interesting things I've learned: Roman numerals in PostgresI have XCIX problems, but Roman numerals ain't one
- Interesting things I've learned: Counting nulls and non-nulls in Postgres2024·nov 14Interesting things I've learned: Counting nulls and non-nulls in PostgresThe num_nonnulls and num_nulls functions in Postgres
- Interesting things I've learned: The FILTER clause in SQL2024·nov 10Interesting things I've learned: The FILTER clause in SQLA useful SQL keyword that I didn't know about until recently.
- An unusual Google Keyboard bug2024·nov 8An unusual Google Keyboard bugWhy backspaces sometimes don't work the way they should.
- Useful built-in macOS command-line utilities2024·nov 6Useful built-in macOS command-line utilitiesmacOS comes with a lot of built-in utilities. Here's a list of some that I find interesting.
- Avoid capital letters in Postgres names2024·nov 3Avoid capital letters in Postgres namesBecause Postgres have counterintuitive rules around case.
- Initial thoughts on using Cursor2024·oct 31Initial thoughts on using CursorThis article contains my initial thoughts on using Cursor, an AI-powered code editor.
- Interesting things I've learned: Oct 20242024·oct 30Interesting things I've learned: Oct 2024This article contains a collection of interesting things I've learned while working on my projects.
- Smart constructors2017·aug 23Smart constructorsThis 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 functors2017·aug 22A gentle introduction to functorsThis 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 server2015·may 24Set up SSH access for an Ubuntu serverThis guide explains how to set up ssh access for an Ubuntu server.
- On professional communications2015·may 20On professional communicationsThis article discusses the concept of professional communications, emphasizing the importance of empathy and self-awareness in effective communication.
- A reflection on my master's course2015·may 17A reflection on my master's courseThis article reflects on the my experience of pursuing a Master's degree at ANU.