The transform_null_equals configuration in Postgres
How to make null = null evaluate to true in Postgres
About me
I'm Wei Yen, @yen223 on the internet. Ex-software engineer, currently working full-time on building Selectable.
I like databases, programming languages, maths, and wordplay.
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.