On 11 Jan 2016, at 6:25pm, Felipe Gasper <felipe at felipegasper.com> wrote:
> - create SQLite file as a .tmp beside permanent location I think you can omit everything to do with the link. Just do BEGIN IMMEDIATE immediately after you open the database. This should lock other processes out until you have finished creating your schema and INSERTing initial data. There's another way to do it but that depends on whether the schema is the same for every installation. If it is, then include a copy of your 'starter database' with the application, and when you want to create a 'blank' database just copy this file to wherever you store your working database. Simon.