Geist Pixel is a bitmap-inspired typeface built on the same foundations as Geist and Geist Mono, reinterpreted through a strict pixel grid. It’s precise, intentional, and unapologetically digital.
How We Fixed YAML Comment Preservation in Ruby (And Why We Sponsored It)
Discourse solved a five-year infrastructure headache by sponsoring psych-pure, a Ruby YAML library that preserves comments through programmatic edits - keeping years of hard-won institutional knowledge intact.
What Does INSERT 0 1 Actually Tell You? | My DBA Notebook
If you’ve ever run an insert statement in a terminal or an IDE, you’ve seen it: the cryptic insert 0 1 message. While it looks like a bit of ancient binary, it’s actually a precise status report from the database engine.
The Anatomy of a Command Tag 🔗In PostgreSQL, every successful command returns a “Command Tag.” For an insertion, the format is: INSERT [oid] [rows]
The “0” (oid1): Historically, Postgres could assign an internal Object ID to every row.
Read efficiency issues in Postgres queries - pgMustard
A lot of the time in database land, our queries are I/O constrained. As such, performance work often involves reducing the number of page reads. Indexes are a prime example, but they don’t solve every issue (a couple of which we’ll now explore).