On 4/2/17, David Burgess <dburg...@gmail.com> wrote: > I tried optimize. > sqlite> pragma main.optimize; > Error: database schema has changed >
I think that means you ran "PRAGMA optimize" as the very first command on a freshly opened database connection. This should be a no-op. Read the go-bys - you should run "PRAGMA optimize" after running many queries. I will fix the harmless warning in the next release. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users