Say you are doing some web development with SQLite in the backend.
You progressively fill the database with the very web interface you
are writing, throwing that data is not desirable in general. But at
the same time the schema evolves with the project, tables are added,
columns are renamed, etc.
How do you deal with this? Any best practices you'd like to share?