Wei Yen's personal blog https://weiyen.net SELECT * FROM 😱 https://weiyen.net/articles/postgres-names-are-surprisingly-flexible https://weiyen.net/articles/postgres-names-are-surprisingly-flexible Wed, 04 Dec 2024 00:00:00 GMT Postgres features that may fly under the radar. https://weiyen.net/articles/interesting-postgres-features https://weiyen.net/articles/interesting-postgres-features Mon, 02 Dec 2024 00:00:00 GMT A quick way to copy a table's structure https://weiyen.net/articles/til-postgres-create-table-like https://weiyen.net/articles/til-postgres-create-table-like Fri, 29 Nov 2024 00:00:00 GMT Get closer to reproducible builds in your Javascript projects https://weiyen.net/articles/pinning-dependencies-javascript https://weiyen.net/articles/pinning-dependencies-javascript Thu, 21 Nov 2024 00:00:00 GMT How to make null = null evaluate to true in Postgres https://weiyen.net/articles/til-transform-null-equals https://weiyen.net/articles/til-transform-null-equals Sun, 17 Nov 2024 00:00:00 GMT How to model discriminated unions in SQL https://weiyen.net/articles/modelling-discriminated-unions-in-postgres https://weiyen.net/articles/modelling-discriminated-unions-in-postgres Sat, 16 Nov 2024 00:00:00 GMT I have XCIX problems, but Roman numerals ain't one https://weiyen.net/articles/til-roman-numerals-in-postgres https://weiyen.net/articles/til-roman-numerals-in-postgres Fri, 15 Nov 2024 00:00:00 GMT The num_nonnulls and num_nulls functions in Postgres https://weiyen.net/articles/til-counting-nulls-in-postgres https://weiyen.net/articles/til-counting-nulls-in-postgres Thu, 14 Nov 2024 00:00:00 GMT A useful SQL keyword that I didn't know about until recently. https://weiyen.net/articles/til-filter-clause https://weiyen.net/articles/til-filter-clause Sun, 10 Nov 2024 00:00:00 GMT Why backspaces sometimes don't work the way they should. https://weiyen.net/articles/an-unusual-google-keyboard-bug https://weiyen.net/articles/an-unusual-google-keyboard-bug Fri, 08 Nov 2024 00:00:00 GMT macOS comes with a lot of built-in utilities. Here's a list of some that I find interesting. https://weiyen.net/articles/useful-macos-cmd-line-utilities https://weiyen.net/articles/useful-macos-cmd-line-utilities Wed, 06 Nov 2024 00:00:00 GMT Because Postgres have counterintuitive rules around case. https://weiyen.net/articles/avoid-capital-letters-in-postgres-names https://weiyen.net/articles/avoid-capital-letters-in-postgres-names Sun, 03 Nov 2024 00:00:00 GMT This article contains my initial thoughts on using Cursor, an AI-powered code editor. https://weiyen.net/articles/initial-thoughts-on-using-cursor https://weiyen.net/articles/initial-thoughts-on-using-cursor Thu, 31 Oct 2024 00:00:00 GMT This article contains a collection of interesting things I've learned while working on my projects. https://weiyen.net/articles/interesting-things-i-learned-oct-2024 https://weiyen.net/articles/interesting-things-i-learned-oct-2024 Wed, 30 Oct 2024 00:00:00 GMT This article explains smart constructors, a design pattern that ensures data validity by validating values during object construction rather than through repeated checks. https://weiyen.net/articles/smart-constructors https://weiyen.net/articles/smart-constructors Wed, 23 Aug 2017 00:00:00 GMT This article introduces the concept of functors, a fundamental concept in functional programming that allows for mapping over wrapped types. https://weiyen.net/articles/a-gentle-introduction-to-functors https://weiyen.net/articles/a-gentle-introduction-to-functors Tue, 22 Aug 2017 00:00:00 GMT This guide explains how to set up ssh access for an Ubuntu server. https://weiyen.net/articles/set-up-ubuntu-server https://weiyen.net/articles/set-up-ubuntu-server Sun, 24 May 2015 00:00:00 GMT This article discusses the concept of professional communications, emphasizing the importance of empathy and self-awareness in effective communication. https://weiyen.net/articles/on-professional-communications https://weiyen.net/articles/on-professional-communications Wed, 20 May 2015 00:00:00 GMT This article reflects on the my experience of pursuing a Master's degree at ANU. https://weiyen.net/articles/a-reflection-on-my-masters-course https://weiyen.net/articles/a-reflection-on-my-masters-course Sun, 17 May 2015 00:00:00 GMT