In this post we'll build a basic jq clone in Go. It will only be able to pull a single path out of each object it reads. It won't be able to do filters, mapping, etc.
Source: Implementing a simple jq clone in Go, and basics of Go memory profiling, an article by Phil Eaton.
A perennial question in the database world: should you prefer to keep application logic closer to the database itself, in stored procedures and triggers, or above the database in your application code?
Postgres 15 beta 2 was released recently! I enjoy Beta season... reviewing and testing new features is a fun diversion from daily tasks. This post takes a look at an improvement to
UNIQUEconstraints on columns withNULLvalues. While the nuances of unique constraints are not as flashy as making sorts faster (that's exciting!), improving the database developer's control over data quality is always a good benefit.
Source: Postgres 15 improves UNIQUE and NULL, an article by Ryan Lambert.