Why PostgreSQL had to go
Personal Finance Intelligence (PFI) is a local-first budgeting app for Windows: a WinUI 3 shell, a FastAPI backend and Next.js screens, with no account and no cloud. Up to version 0.3 it ran its own private PostgreSQL server inside the user's data folder.
That worked, but it was the wrong tool for a single-user desktop app. The Microsoft Store build tripped over PostgreSQL's files, PostgreSQL could not run from the Store's read-only install folder without copying its binaries elsewhere first, and the app carried a whole database server for one user. Version 0.4 moved everyone to a single SQLite file; 0.5 removed PostgreSQL, which made the app about a third smaller to download and 155 MB smaller on disk.
The hard part was not SQLite. It was moving real people's money records from one database to another on their own PCs, with nobody there to fix it if it went wrong.
The rules
Three rules decided every design choice:
Never lose a cent.…