Small. Fast. Reliable.
Choose any three.

This information is obsolete. You are looking at the CVSTrac source management system display for SQLite that was replaced by Fossil on 2009-08-11. The information shown here has not been updated since that cut-over. These pages are retained for historical reference only.

Perl and DBD::SQLite notes

Temporary databases

  my $dbh = DBI->connect('dbi:SQLite:dbname=:memory:');  	# in-memory database
  my $dbh = DBI->connect('dbi:SQLite:'); 			# temporary database file created in /var/tmp

Defining a REGEXP function

  $dbh->func('regexp', 2, sub { return ($_[1] =~ m/$_[0]/) ? 1 : 0; }, 'create_function');