Posts on 2023/12/27

I really appreciated my decision to use sqlite to store my posts, as it allowed me to implement a very straight-forward migration mechanism, when I was adding the BlueSky federation/syndication.

I especially enjoyed the built-in

PRAGMA user_version;

to keep track of which migrations have already been run on a given .db file.

Yesterday, I finished If Then by Jill Lepore. What a book! Meticulously researched and written in a shockingly readable style. Highly recommended to anyone who wants to learn how far back attempts at using computers to influence people’s opinion go! 💙📚