all written video podcast

  • The absolute beginners guide to databasemaxxing - Unknown

    The absolute beginners guide to databasemaxxing - Unknown

    2026-03-22
    So, you are interested in getting started learning databases? I get a lot of emails from people asking me how they can begin to learn the vast world of databases, and whether they are far enough along on their programming journey to bother trying to...
  • You can do better - Unknown

    You can do better - Unknown

    2026-03-13
    Lately on X I have noticed a trend of posts that I imagine are probably the natural response to 'LinkedIn-brain' posts, which might be the result of the poor job market right now: "If hard work paid off, the donkey would own the...
  • Rewriting SQLite: Adding a new join algorithm - Unknown

    Rewriting SQLite: Adding a new join algorithm - Unknown

    2025-11-22
    I am not sure that there exists a group of bigger SQLite nerds than those of us at Turso. We use SQLite for everything.. Including for OLAP workloads where we should be using duckdb, or for services which we would love to be totally stateless...
  • Checkpointing performance in Write-Ahead-Logs - Unknown

    Checkpointing performance in Write-Ahead-Logs - Unknown

    2025-08-13
    Making Checkpointing fast Since I began working for turso officially in May of this year (relevant post), I had been spending most of my time learning the inner workings of the cloud platform, and familiarizing myself with the other codebases and...
  • Learn systems, not langauges - Unknown

    Learn systems, not langauges - Unknown

    2025-08-09
    Due to the nature of my story and the attention that it's received, as mentioned in my last post, I frequently get emails from developers, college kids, or other people with troubled pasts that are looking for advice on either how to learn or how...
  • whois pthorpe92.dev - Unknown

    whois pthorpe92.dev - Unknown

    2025-06-19
    Preston Thorpe senior engineer @ Turso building the modern evolution of sqlite formerly: principal engineer @ Unlocked Labs open source: maintainer @ eza maintainer @...
  • Working on databases from prison, How I got here, part 2. - Unknown

    Working on databases from prison, How I got here, part 2. - Unknown

    2025-06-16
    How I got here pt. 2 Posted on turso's blog
  • Calling Rust from cursed Go - Unknown

    Calling Rust from cursed Go - Unknown

    2025-02-26
    The general state of FFI in Go can be expressed well with a story about when I had tried to get mattn/go-sqlite3 drivers to work on a Windows machine a couple years ago around version 1.17, and CGO would not build properly because my $GOPATH or $CC...
  • Magic isn't real - Unknown

    Magic isn't real - Unknown

    2024-10-03
    Any sufficiently advanced technology is indistinguishable from magic. Arthur C. Clarke This quote applies just as much to developers as it does non-tech people, sometimes more. I remember towards the beginning of my programming journey (both the...
  • PHP/Laravel: Why we rewrote our app in Go - Unknown

    PHP/Laravel: Why we rewrote our app in Go - Unknown

    2024-07-14
    (Modern) PHP: Does it really suck? Like many, many developers out there over the age of 30, I basically started my programming journey with PHP (and perl). Circa ~'05, PHP was the go-to language for the web, and Adobe Dreamweaver supported it out...
  • Gratitude - Unknown

    Gratitude - Unknown

    2023-11-13
    How I got here is already far too long of a post, so I must include this for all the credits and gratitude I need to extend to those who made this possible. To my parents: who supported me every single day of the decade+ I have spent behind bars, and...
  • OCaml + Rust: some comparisons - Unknown

    OCaml + Rust: some comparisons - Unknown

    2023-11-12
    Following up on the first impressions post, let's solve a problem in OCaml and compare the Rust solution. In Response to how well received my last post was I thought I would follow up with some comparisons between how I would solve a simple...
  • Hackers guide to the hackernews front page - Unknown

    Hackers guide to the hackernews front page - Unknown

    2023-11-10
    Humorous article, completely unrelated to, and written before, the others ended up actually on the front page. The Goal: To get a post on the front page of the infamous Orange site... The Plan: There are four guaranteed strategies. No one knows...
  • Ocaml: first impressions - Unknown

    Ocaml: first impressions - Unknown

    2023-11-09
    The Why I'm somewhat of a language nerd to begin with, and it was Rust that originally got me interested in the whole functional paradigm. Not due to it's lineage, but the heavy use of chained iterator methods in favor over traditional loops....
  • How I got here - Unknown

    How I got here - Unknown

    2023-11-07
    My story, and how this is all possible Introduction My name is Preston Thorpe, I'm 31 years old and I've spent just under 10 years of my life in Prison (all for non-violent drug crimes.) I am currently incarcerated at Mountain View...