Hacker News Reader

Had this exact same idea but I wonder how does it handle deletes.

Is it actually going to release deleted unused space or would be a manual defragmentation after some deletes.

The db size generally won't shrink under default settings, but the space will be reused.

Set the auto_vacuum pragma before creating any tables?