in reply to determining table structure in SQLite database

As well as using DBD::SQLite via DBI's methods, you can use the sqlite3 command line tool: 
sqlite3 <your sqlite database> .schema

[download]

Just substitute the file you've used for the database.

In Section Seekers of Perl Wisdom