Hi, I'm Wei Yen
I'm a software engineer in Sydney.
I'm currently building StrataChecks, a due-diligence tool for NSW strata buyers, and Selectable, a mobile-friendly Postgres client. I also maintain Eka, a stateful AI agent with a blog.
I like databases, programming languages, maths, and wordplay.
01 / writing
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.