cldellow’s twitter archive
When Twitter changed hands in 2022, I decided I didn’t want to actively contribute to it: I stopped posted and made my tweets private.
Colin Dellow
Random thoughts, mostly about technical topics.
Latest posts
My Next Make: Sewing Pattern Database
Jenn and some friends had been maintaining a database of sewing patterns scattered across some Google docs and Shopify metafields. She took the time to polish it up and release it as an online sewing pattern database.
SyncWith: get your API data into Google Sheets
It’s crazy how much of the day-to-day job of a knowledge worker revolves around copying and pasting.
Ubuntu 20.04 on the Lenovo IdeaPad Gaming 3 15ARH05 (82EY006YUS)
Every 4 years, I upgrade my laptop.
Running Datasette on AWS Lambda
I love software tools that (a) are opinionated and (b) get out of the developer’s way. These seem like principles that are in tension with each other, but they don’t have to be.
Lawlytics Organic SEO: OK, I’m curious
I recently built a backlink database specifically for law firms.
Serverless on Amazon: Is 2019 the Last Year I’ll Have to Deal With VMs?
The last few months have seen me flirt with Amazon API Gateway and AWS Lambda, aka “serverless computing”. I come from a traditional ops background. I’m very comfortable running my own VMs, nginx load balancers, Varnish caches, etc. That stack delivers amazing performance at a great price point, but it also comes with significant ops burden. I had a few projects I wanted to build, but the thought…
s3patch
When Jenn and I were travelling in Europe, we often tinkered with some side projects. These required uploading large files regularly. The files were 99% unchanged from upload to upload. For example, a ZIP file with a node.js app, or a JAR file with a Scala app, where the bulk was made up of third-party dependencies that never changed.
Big Data: Spark
This is a copy of an internal training session I organized on Spark, with confidential information redacted.
Big Data: Hive/Presto/Parquet
This is a copy of an internal training session I organized on Hive, Presto and Parquet, with confidential information redacted.