Preston Thorpe (@pthorpe92) 's Twitter Profile
Preston Thorpe

@pthorpe92

freedom-challenged programmer.
github.com/PThorpe92

ID: 1879585147496083457

calendar_today15-01-2025 17:43:28

6 Tweet

18 Followers

133 Following

Preston Thorpe (@pthorpe92) 's Twitter Profile Photo

Got `sqlancer` testing tool to run in a loop on an ECS task on fargate, with github+slack integration, corruption+WAL inspection tools run on any problematic DB's for the GH issue for analysis. Took ~6hrs. Pre-AI this would take 2-3 days to setup completely, and been a PITA :)

Preston Thorpe (@pthorpe92) 's Twitter Profile Photo

You really can only fix bugs at the rate that you can discover them. This seems obvious, but there's an awkward stage for each project where you're not really able to fully surface many of the important issues, whether its from lack of actual users, or lack of fuzzing/testing

Preston Thorpe (@pthorpe92) 's Twitter Profile Photo

It's amazing, even with how big of a SQLite nerd's those of us at Turso are... Even after reading it's source code endlessly and rewriting it from scratch. We still regularly learn of new syntax, features or quirks we were not aware of.

Preston Thorpe (@pthorpe92) 's Twitter Profile Photo

Using dogfooding pretty much as an excuse to rewrite an internal networking service from Go to Rust... Now our second service that will be using tursodb in production :D

Preston Thorpe (@pthorpe92) 's Twitter Profile Photo

Spent my weekend reading and learning about distributed join algorithms, as my existing knowledge is entirely limited to in-process/single node DBMS... And I will say that the complexity increase in planning those queries seems to be pretty much exactly what you would expect :)

Jens Axboe (@axboe) 's Twitter Profile Photo

In a world of ever increasing AI slop where some people don't even read the code they crank out, this takes you back to proper engineering. Refreshing!

Pekka Enberg (@penberg) 's Twitter Profile Photo

Just shipped AgentFS 0.6.0, now in beta! What's new: 🔧 Full POSIX compatibility for FUSE and NFS 🔐 Local encryption support ⚡ Faster & more reliable 🛠️ New agentfs exec & agentfs migrate commands Full release notes and download link 👇

Preston Thorpe (@pthorpe92) 's Twitter Profile Photo

Damn I already miss the days where submitting/merging a non-trivial PR to an open source project meant that you (generally, at least) knew what you were doing and had deeply studied the code base and understood the problem surface.

Preston Thorpe (@pthorpe92) 's Twitter Profile Photo

My good friend's blog post about his journey learning to program in prison, super proud of him and glad I could be a part of it. ck-7vn.dev/blog/Home