Trouble inserting data into an sqlite3 database

[xoft]

SQLite doesn't need the column types, it can store any data in any column, it's just the later interpretation that is affected by saying types.

Could you try making a few more insert statements, see if any of those get through? I have a feeling that either the last statement doesn't get through, or only the first statement gets through. Also, can you print the results of each stmt:step() and stmt:finalize()?

print("stepping...")
print(stmt:step())
print("finalizing...")
print(stmt:finalize())

(Note that the stmt:step() must be the only thing in the print statement, so that multiple return values are reported properly)