A collection of thoughts and experiments that at one point occupied my time, some still do. These are the things happening in my idle cycles.
I saw a "100-million-row challenge in PHP" posted today and it reminded me of the last time I saw something like this. While I don't know PHP I thought I might treat it as an exercise for using SQLite to keep me in practice with a few different SQLite functions. It turns out there is definitely a point where SQLite may not be a good fit!
read more...I've recently been interested in whether PostgreSQL's row security policies could be a good fit for a few different projects. Before committing too strongly to using them someplace important I figured I'd try them out to understand the potential implications to query performance and ergonomics.
read more...I wrote the other day about a series of design choices that I aim for when starting a new project. In so doing I lured myself into testing out a thought that has been rolling around my head for a while: what is the smallest spring boot application that can fit such an architecture?
read more...Some incomplete notes on provisioning web stuff in a way that allows for fast feedback without leaving me hamstrung with technical debt at the level of project infrastructure.
read more...Unsurprisingly, I've been lax in maintaining things around here. Debian 13 was released quite a while ago and it has been a couple of years since I did any big updates on the server. My previous experience was good so I didn't spend long planning for this one.
read more...I was reading about the drunken bishop algorithm for fingerprint visualization in openssh. I thought it might be a lark to implement it in emacs lisp.
read more...Just a quick note on configuring an automatic network mounted file system.
read more...A few notes on an interesting software design I've been noodling on. I'm still trying to untangle how to foster organic growth in software systems.
read more...Lately I've been thinking about database design and the implications for query performance. I have found myself repeatedly arguing against architectural complexity in favor of "just let the database do that" and I thought it was probably a good idea to further develop an intuition for performance against some hard numbers.
read more...I've been munging configuration data for a bunch of hardware devices and it has me thinking on ways to improve some of that workflow. These are just a few notes on what has proven useful or interesting as I continue to explore my options.
read more...