Contents
IntroductionUpgrading
File Format
Date / Time / Timestamp
General
Introduction
Between version 1.4.198 and version 2.0.0 there have been considerable changes, such that a simple update is not possible.
It would have been nice to write some kind of migration tool, or auto-detect the file and upgrade. Unfortunately, this is purely a volunteer-run project, so this is just the way it has to be.
Upgrading
The official way to upgrade is to do a BACKUP of your existing database
Then create a fresh database
MVStore file format
The MVStore file format we use (i.e. the default) is still mostly the same, but some subtle changes have been made to the undo logs, for the purposes of improving crash safety and also read/write performance.
Date / Time / Timestamp
TODO - Correctness.
General
There are a lot more SQL keywords now. Many SQL statements feature far better support of SQL-Standard behaviour. Some old non-standard SQL syntax support has been removed.