Archive for October 6th, 2011
Using SQLite triggers to increment a count
I want to apply tags to urls and keep a count of how many times each tag has been used. Here’s some code that does just that: use DBI; use Text::Table; my $FILENAME = ‘play.sqlite’; unlink $FILENAME; my $dsn = “dbi:SQLite:database=$FILENAME”; my $dbh = DBI->connect($dsn) or die; $dbh->do($_) or die “$DBI::errstr for $_” for split […]
Read Full Post | Make a Comment ( None so far )