Why won't SQLite give back my disk space?

I found a 77GB database file that only had 145MB of real data. Here is why SQLite hoards space and how I finally forced it to let go. I thought I had plenty of space, but a single libSQL file was hoarding 77GB of "nothing."