27 October 2026

Website update

With everything in the world reporting security issues last week (php vulnerability, nodejs vulnerability, an SSL key that was the number 4), I decided to upgrade my website.

  • Python 3.6 → 3.13
  • Django 1.11 → 6.1 😱
  • MariaDB → SQLite

I started this blog with MySQL (which I pronounce like “my sequel”) and continued with MariaDB when I moved to OpalStack for web hosting. However, when a database is a couple megabytes and I’m the only person writing to it, SQLite does very well.

A quick performance test showed a 5–16 ms improvement, shaving off roughly 10–30% of server time depending on how much the endpoint relied on database calls.

That being said RIP Maria and My… which brings me to my favorite database joke…

So, I’m writing a series of books on databases.

My first one was on Postgres…

but now I’m working on MySQL.

21 June 2025

Ziggy

A movie in Split, Croatia, during a rainstorm: https://youtube.com/shorts/x8fLQ5gEk8E?si=4ShzgKD6RS34CEG_

Tips on working with URLs in Python and how to correctly inverse parse_qs with urlencode. read full post…
Tips on how to workaround an issue with the Chrome QuotaManager that is affecting some folks in Chrome 99. read full post…

27 February 2022

Browser tab hygiene

My approach to maintaining proper browser tab hygiene and not getting overwhelmed by too many tabs. read full post…

Peter Coles

Peter Coles

is a software engineer who lives in NYC, is working on GoFullPage 📸, and occasionally blogs here.
more »

github · soundcloud · rss