**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');