Gavin Ray Blog

Experimenting with SQL:2023 Property-Graph Queries in Postgres 18

Psychedelics as Tools: Reflections After 20+ Compounds and a Decade of Experiments

AI SQL Generation: Overcoming dialect-specific syntax errors

What good are Record Patterns in Java? An example based on Spark's Catalyst Optimizer and it's Tree Rewriting Rules

Building a PostgreSQL Wire Protocol Server using Vanilla, Modern Java 21

Adding Design-by-Contract [[invariant]] conditions to C++, via a GCC plugin

A Day Without a Copilot: Reflections on Copilot-Driven Development

Building a high-performance database buffer pool in Zig using io_uring's new fixed-buffer mode

Panama: Not-so-Foreign Memory. Using MemorySegment as a high-performance ByteBuffer replacement.

Building a Query Expression Language in Kotlin, plus dynamic SQL Generation using jOOQ