advice on schema evolution

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

advice on schema evolution

Xavier Noria
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?

-- fxn