Preston Thorpe

About:

Preston Thorpe is a principal engineer and open source enthusiast passionate about education, technology, and criminal justice reform.

Website:

pthorpe92.dev

Specializations:

Principal Engineer Open Source Maintainer Software Developer

Interests:

Rust Go CLI/TUI Databases Cloud/infra Developer tools Systems programming Open source community Teaching FOSS Privacy Security Criminal justice/prison reform

Incoming Links:

Guilherme Ananias

Subscribe to RSS:

Link

2025-11-22 • sqlite database turso olap hash joins

The blog post discusses the limitations of SQLite in production environments, particularly for OLAP workloads, and explores the implementation of hash joins in tursodb to improve performance. It highlights issues such as exclusive...

2025-11-22 • sqlite database turso olap hash joins

2025-08-13 • performance database turso asynchronous i/o checkpoint

The author discusses their experience working on performance improvements for the turso cloud platform's database, specifically focusing on the Write-Ahead Log (WAL) and checkpointing processes. They detail the challenges faced wi...

2025-08-09 • programming software development system programming engineering career programming advice

The author shares insights and advice for individuals looking to enter the tech field, particularly in programming. They recount their personal journey from having no coding experience to becoming a proficient programmer. Key poin...

2026-03-13 • work ethic personal development team management and development software engineering

Hard work and taking initiative in the workplace can significantly enhance team dynamics and job security for developers.

2025-02-26 • go language ffi cgo limbo

The text discusses the general state of FFI in Go, particularly focusing on the issues with CGO. The author shares their experience with trying to get mattn/go-sqlite3 drivers to work on a Windows machine and the challenges faced....

2024-11-02 • technology open source privacy security education foss criminal justice reform criminal justice

Preston Thorpe is a principal engineer at Unlocked Labs, currently building an S.I.S. and education platform for incarcerated students. He is also involved in open source projects and is an advocate for FOSS, privacy, security, an...

2024-10-03 • programming learning software development go language zig programming language compile time

The text discusses the feeling of being overwhelmed when learning to program and how to overcome it. It emphasizes the importance of understanding the fundamentals and learning about different parts of the stack, even if they are ...

2025-06-16 •

...

2024-07-14 • laravel php go language vue.js go programming django rust programming game server ory

The author discusses their experience with PHP and Laravel, highlighting the good and bad aspects of the language and framework. They also compare PHP to Go, expressing a preference for Go over PHP for more complex applications.

2023-11-13 • success gratitude addiction mentorship

The author expresses gratitude to their parents, colleagues, and mentors for supporting them through their journey of overcoming addiction and incarceration, and for providing opportunities for personal and professional growth.

2023-11-12 • programming ocaml comparison

The post is a comparison between solving a simple problem in OCaml and Rust. The author discusses the process of solving the problem in both languages, the challenges faced, and the differences in syntax and features. The post als...

2023-11-10 • internet technology personal website political satire

The text is a humorous article about strategies to get a post on the front page of a website. It outlines four guaranteed strategies, each with a humorous twist and absurdity. The author uses satire and humor to entertain the read...

2023-11-09 • ocaml functional programming artem's lab

The author discusses their interest in the Rust programming language and how it led them to explore functional programming. They express their fascination with the language and their intention to learn OCaml. The author shares the...

2023-11-07 • software development remote work criminal justice reform

Preston Thorpe, a software developer, spent 10 years in prison for non-violent drug crimes. He was arrested at 20 and spent time in solitary confinement. He was transferred to Maine, where he focused on self-improvement, learning ...