> On Sep 1, 2017, at 1:47 PM, Papa <p...@arbolone.ca> wrote: > > Yes, right after opening the database, I want o perform a vacuuming so that > the new tables can be created, writing and/or read.
I don't know how to put this politely, but you seem to be making things up out of thin air. There's nothing anywhere that says you need to run VACUUM to run any other command. And there are no SQL commands that take the path to the database. Instead of making things up, try the `sqlite3` command-line tool. Run some SQL commands in that tool's interactive mode and get a feel for how SQL works. Then when you have working commands, you can bring them into your own program. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users