Blog

Deep dives into software architecture, infrastructure, and tools I've built or discovered over the years.


5 min read

Execute .sql file with PyMySQL

Most SQL files contain interpreter commands such as DELIMITER that make passing the commands through to pymysql somewhat difficult, this code snippet allows you to separate out the statements in the sql file into a list for sequential execution.

PythonMySQL
Read article

4 min read

Bash Locate (flocate)

A fast locate-like tool that you can carry with you in your dotfiles, that only uses basic binaries available on most systems. Searches through a compressed database of file locations on your hard drive.

BashLinux
Read article

3 min read

Pretty JSON streams

I've been looking at walls of JSON for the last few days, and realized that I really shouldn't be doing that. So I made a script that will continuously indent and output a stream of JSON data formatted and indented properly.

JSONScripting
Read article


Archives & Projects

Many of these posts were rescued from the archives of my original blog. Follow me on GitHub for the source code to these experiments.

© 2026 Adam Lamers
Framework: Svelte_5
Runtime: Cloudflare