Hi 👋 I'm Mark, and this is my blog where I write about technology projects that interest me.
A little about me: I co-founded an analytics company, Propel , and before that I worked at Twilio on SIM cards and WebRTC. I love synthesizers and DanceDanceRevolution.
If you want to get in touch, you can email me at mark.andrus.roberts@gmail.com .
Otherwise, check out any of these 17 posts…
2024-08-14 How to annotate PostgreSQL ASTs with location information Learn how to annotate PostgreSQL abstract syntax trees (ASTs) with location information using libpg_query and TypeScript. 2024-04-15 How to run a cost-efficient ClickHouse cluster with separated storage & compute Durable block storage is expensive. A hybrid approach with ephemeral local storage and cheap object storage improves price/performance ratio. 2024-02-26 Push & Pull: Reducing DynamoDB spend with CDC & Kinesis We reduced GSI read usage 90% by moving from a pull-based to push-based approach in our sync scheduler. 2023-08-22 De-risking large-scale refactors Ship confidently by leveraging testing, controlled rollout & observability 2023-05-22 How Propel does bug fixes, feature additions & refactors Propel's approach to shipping improvements to production. 2023-05-10 Deployment Notes: How Propel documents changes to production How Propel uses deployment notes to communicate changes internally, improve customer communication, and aid in incident response. 2023-01-10 How Propel migrated to Apollo Server 4 Peek behind the curtain and see how Propel upgraded its GraphQL API to the latest version of Apollo Server. 2017-03-23 Programmable Video Fundamentals A talk I gave at Twilio's SIGNAL Superclass 2016-03-19 Combining ORTC & WebRTC with Twilio's JavaScript SDK How Twilio used Microsoft's Object RTC (ORTC) in its Voice SDK 2012-02-08 Scraping Scraping keys from blogs with the Haskell XML Toolbox (HXT) 2011-08-04 Web Design I designed and built the the website for Femi Memorial Outreach Fund 2011-04-17 Assembly Homework I'm studying Computer Science at the University of Chicago and found this homework interesting 2011-04-08 Pipeline A tool for applying image transformations to sequences of images 2011-02-24 Algorithmic Animation Rendering particle systems with Java & FFmpeg 2011-02-24 iPodLinux iPodLinux allowed you to run Linux on iPod. I wrote a drum machine for it. 2011-02-24 Sonify Updated I updated my program, which processes images through audio filters, to use SDL 2011-02-24 Sonify I wrote a program to process images through audio filters