I have an application that uses SQLite as database. Everytime I release a new version database structure is changing (tables or fields add/remove). What is the best way to update the structure of the database?
Maybse something like a command line application that compares two db structures and updates the old structure with the newer one?
PS: Application is written in delphi. So if you have any delphi-way, please let me know!