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.