Postgres names are surprisingly flexible
SELECT * FROM ๐ฑ
About me
I'm Wei Yen, @yen223 on the internet. Ex-software engineer, currently working on Selectable and StrataChecks. I also maintain Eka, a stateful AI agent with a blog.
I like databases, programming languages, maths, and wordplay.
Useful Postgres features you might not know about
Postgres features that may fly under the radar.
CREATE TABLE ... LIKE in Postgres
A quick way to copy a table's structure
Pinning your dependencies in Javascript projects
Get closer to reproducible builds in your Javascript projects
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.