Notes on software development

July 07, 2024 A reawakening of systems programming meetups
July 01, 2024 A write-ahead log is not a universal part of durability
June 17, 2024 The limitations of LLMs, or why are we doing RAG?
June 14, 2024 Confusion is a muse
May 30, 2024 How I run a software book club
May 16, 2024 Implementing MVCC and major SQL transaction isolation levels
April 10, 2024 What makes a great technical blog
April 05, 2024 A paper reading club at work; databases and distributed systems research
March 27, 2024 Finding memory leaks in Postgres C code
March 15, 2024 Zig, Rust, and other languages
March 11, 2024 First month on a database team
February 08, 2024 An intuition for distributed consensus in OLTP systems
January 09, 2024 Writing a minimal in-memory storage engine for MySQL/MariaDB
December 27, 2023 Make your own way
November 19, 2023 Exploring a Postgres query plan
November 01, 2023 Writing a storage engine for Postgres: an in-memory Table Access Method
October 19, 2023 io_uring basics: Writing a file to disk
October 05, 2023 Go database driver overhead on insert-heavy workloads
October 01, 2023 Intercepting and modifying Linux system calls with ptrace
September 21, 2023 How do databases execute expressions?
September 04, 2023 Eight years of organizing tech meetups
August 15, 2023 Thinking about functional programming
July 11, 2023 We put a distributed database in the browser – and made a game of it
June 19, 2023 Metaprogramming in Zig and parsing CSS
May 25, 2023 Implementing the Raft distributed consensus protocol in Go
May 16, 2023 Two books I recommend to developers
May 16, 2023 My favorite software subreddits
March 21, 2023 Errors and Zig
February 18, 2023 Notes from Neal Gabler's Walt Disney
January 30, 2023 Lessons learned streaming building a Scheme-like interpreter in Go
January 23, 2023 An effective product manager
January 12, 2023 The year in books: 2022
January 05, 2023 Favorite compiler and interpreter resources
January 04, 2023 General book recommendations
January 01, 2023 In response to a frontend developer asking about database development
December 01, 2022 Is it worth writing about?
November 23, 2022 A Programmer-Friendly I/O Abstraction Over io_uring and kqueue
November 13, 2022 Writing a SQL database, take two: Zig and RocksDB
October 30, 2022 A minimal RocksDB example with Zig
October 12, 2022 A database without dynamic memory allocation
September 17, 2022 A minimal distributed key-value database with Hashicorp's Raft library
August 23, 2022 What's the big deal about key-value databases like FoundationDB and RocksDB?
August 21, 2022 SQLite has pretty limited builtin functions
July 25, 2022 Container scheduling strategies for integration testing 14 different databases in Github Actions
July 10, 2022 Implementing a simple jq clone in Go, and basics of Go memory profiling
June 10, 2022 One year as a solo dev building open-source data tools without funding
May 17, 2022 Let's build a distributed Postgres proof of concept
May 12, 2022 SQLite in Go, with and without cgo
April 26, 2022 HTML event handler attributes: down the rabbit hole
April 17, 2022 Interview With Phil of DataStation
April 11, 2022 Surveying SQL parser libraries in a few high-level languages
March 28, 2022 Writing a document database from scratch in Go: Lucene-like filters and indexes
March 03, 2022 Speeding up Go's builtin JSON encoder up to 55% for large arrays of objects
February 20, 2022 SMTP protocol basics from scratch in Go: receiving email from Gmail
February 08, 2022 The world of PostgreSQL wire compatibility
January 31, 2022 How to recommend books, or, stop recommending SICP
January 23, 2022 Bootloader basics
January 11, 2022 dsq: Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
January 06, 2022 Analyzing large JSON files via partial JSON parsing
January 05, 2022 The year in books: 11 to recommend in 2021
December 28, 2021 Writing a minimal Lua implementation with a virtual machine from scratch in Rust
December 16, 2021 Running SQL Server in a container on Github Actions
November 23, 2021 Implementing zip archiving in Golang: unzipping
November 13, 2021 Benchmarking esbuild, swc, tsc, and babel for React/JSX projects
October 31, 2021 Building a fast SCSS-like rule expander for CSS using fuzzy parsing
October 29, 2021 Exploring PL/pgSQL part two: implementing a Forth-like interpreter
October 24, 2021 Exploring PL/pgSQL: Strings, arrays, recursion, and parsing JSON
October 18, 2021 Experimenting with column- and row-oriented datastructures
October 13, 2021 Notes on running Electron
September 21, 2021 Enumerating and analyzing 40+ non-V8 JavaScript implementations
August 26, 2021 Writing a simple JSON library from scratch: a tour through modern C++
August 21, 2021 Parser generators vs. handwritten parsers: surveying major language implementations in 2021
August 05, 2021 Practical? Common Lisp on the JVM: A quick intro to ABCL for modern web apps
July 15, 2021 Writing an efficient object previewer for JavaScript
July 08, 2021 React without webpack: fast path to a working app from scratch
June 25, 2021 Controlled HTML select element in React has weird default UX
June 22, 2021 Leaders, you need to share organization success stories more frequently
June 17, 2021 Languages you can run in the browser, part 1: Python, JavaScript, SQLite
June 04, 2021 Coolest hard-tech companies in NYC 2021
May 23, 2021 Writing a Jinja-inspired template library in Python
April 04, 2021 Learning a new codebase: hacking on nginx
March 07, 2021 How to get better at recursion
January 23, 2021 Extending gosql to supporting LIMIT and OFFSET
December 27, 2020 The year in books: 20 to recommend in 2020
December 20, 2020 Static analysis with semgrep: practical examples using Docker
November 26, 2020 Emulating linux/AMD64 userland: interpreting an ELF binary
November 11, 2020 The impact of management teams as a decision-making group, in startups and enterprise
October 25, 2020 Standard ML in 2020
September 07, 2020 The case for comments in code
August 16, 2020 Writing a simple Python compiler: 1. hello, fibonacci
July 25, 2020 A single-node Kubernetes cluster without virtualization or a container registry
June 14, 2020 Generating a full-stack application from a database
June 06, 2020 Generating a REST API from a database
May 16, 2020 RFCs and asynchronous-first culture
May 10, 2020 Writing a SQL database from scratch in Go: 4. a database/sql driver
May 01, 2020 Writing a SQL database from scratch in Go: 3. indexes
April 12, 2020 Writing a SQL database from scratch in Go: 2. binary expressions and WHERE filters
April 04, 2020 Studying foreign languages with inbox zero
March 18, 2020 Reviewing the Surface Book 2
March 06, 2020 Writing a SQL database from scratch in Go: 1. SELECT, INSERT, CREATE and a REPL
February 01, 2020 A minimal REST API in Java
December 08, 2019 Writing a lisp compiler from scratch in JavaScript: 6. an x86 upgrade
November 30, 2019 Confusion and disengagement in meetings
October 12, 2019 Interpreting Go
September 30, 2019 Administering Kubernetes is hard
August 31, 2019 Unit testing C code with gtest
July 20, 2019 Writing an x86 emulator from scratch in JavaScript: 2. system calls
June 22, 2019 Writing a lisp compiler from scratch in JavaScript: 6. LLVM system calls
May 21, 2019 Writing an x86 emulator from scratch in JavaScript: 1. a stack and register machine
May 14, 2019 Tail call elimination
May 04, 2019 Writing a lisp compiler from scratch in JavaScript: 4. LLVM conditionals and compiling fibonacci
April 30, 2019 Responsibility and ownership
April 14, 2019 Interpreting TypeScript
April 06, 2019 Writing a web server from scratch: 1. HTTP and sockets
March 27, 2019 Writing a simple JSON path parser
March 10, 2019 Writing a lisp compiler from scratch in JavaScript: 3. LLVM
February 26, 2019 AOT-compilation of Javascript with V8
January 22, 2019 Transparency and communication on small teams
January 20, 2019 Windows
January 20, 2019 Writing a lisp compiler from scratch in JavaScript: 2. user-defined functions and variables
December 27, 2018 Make small changes and solve the problems you have
November 20, 2018 Writing a lisp compiler from scratch in JavaScript: 1. lisp to assembly
October 20, 2018 On NYC, Tokyo and Seoul
September 26, 2018 Why (and how) to read books
September 02, 2018 Compiling dynamic programming languages
August 04, 2018 btest: a language agnostic test runner
May 18, 2018 Writing to be read
May 06, 2018 Writing a simple JSON parser
April 28, 2018 Finishing up a FreeBSD experiment
March 25, 2018 Book Review: ANSI Common Lisp
March 05, 2018 Starting a minimal Common Lisp project
January 20, 2018 Interview with the D Language Blog: BSDScheme
January 10, 2018 First few hurdles writing a Scheme interpreter
March 11, 2017 Deploying FreeBSD on Linode unattended in minutes
December 29, 2016 Walking through a basic Racket web service