Normal tables have the 'if not exists' syntax, but virtual tables do not. How can I create a virtual table iff it doesn't exist?
The usual commands to check if a table exists seem to be disabled. I can't execute ".tables" or "show tables". If I could detect that the table already exists, I could avoid attempting to create it. I could just attempt to create it on every page load. This causes an ugly sql error to show up in my console, but it doesn't appear to raise an exception or have any significant effect. I could attempt to create a normal table with the if not exists syntax and check if it is empty of records, and if so it's likely that I need to create the virtual tables. The table I use to check should probably be one devoted to schema versioning, that I can be fairly certain should have at least one row in it. I guess this is doable.
