in reply to DBD::SQLite will connect and CREATE, but not INSERT...sort of

This doesn't solve your problem, but if you're just using DBD::SQLite for a basic ORM and you don't plan on using DBIC or CDBI or something similar to mange the ORM bits, just use DBM::Deep. It even has transactions. :-)

As for the specific issue, I remember having to do silly things when running DBM::Deep tests on OSX. Specifically, when calling tempfile(), I had to flock( $fh, LOCK_UN ) prior to returning it because tempfile() on OSX returns a flocked filehandle. This may be related, depending on how DBD::SQLite handles temp files.

My criteria for good software:
  1. Does it work?
  2. Can someone else come in, make a change, and be reasonably certain no bugs were introduced?
  • Comment on Re: DBD::SQLite will connect and CREATE, but not INSERT...sort of

In Section Seekers of Perl Wisdom