in reply to DBD::SQLite dilemma
I'd go for option (3) myself and call
my $rowcount = $dbh->do("SELECT * FROM TABLE");
undefined behaviour (mainly coz I'd like iterators:-)
The benefit is worth the gain - and people should learn how to use COUNT().
In Section
Meditations