Interesting things I've learned: Roman numerals in Postgres
I have XCIX problems, but Roman numerals ain't one
About me
I'm Wei Yen, @yen223 on the internet. Ex-software engineer, currently working full-time on building Selectable.
I love maths, coffee, and all things programming.
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.