by Unlicensed Unknown user
When last heard from, your intrepid author (c'est moi) concluded that SQLite was not a lightweight replacement for SQL. I reached this conclusion because I had tried The Dummy Table Technique (see Getting Useful Information out of SQL, Part 2, at Clarion Mag, for a complete description of this technique), in fact a number of variations on it, to get totals from a SQLite file:
...
So, let the application CREATE the file (by placing it in the table schematic):
Figure 1: Let the app create the file
...