For some reason my hosting only seems to work updating my SQLite database when it is set in WAL mode.
So using "DB Browser for SQLite" I edited the Pragma Journal Mode to WAL and everything seems to work....My database is now 1Mb but the accompanying WAL ...