Archive for October 6th, 2011

Using SQLite triggers to increment a count

Posted on October 6, 2011. Filed under: Uncategorized | Tags: , , , |

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 )

Liked it here?
Why not try sites on the blogroll...