I am using DBD::SQLite in a perl script and am very happy with it. I would like to add the capability to check at script start if the database exists, and if not, create it and the same with the one table the script requires. I looked at perldoc DBD:SQLite and perldoc DBI but if the answer was there I missed it. Any hints?

Check for the file that represents the database. I guess that was to obvious for me to think of. OK, so the next step would be to create the database from within the script if it does not already exist. As far as I can tell, the way to create a SQLite database is to call the sqlite3.exe [DBNAME] from the command line. I could use a system call from within the script (system("sqlite3 [DBNAME]";) but how would I send .quit to stop the utility? Is there something else obvious I'm missing?