NAME

Net::Google::SafeBrowsing2::Sqlite - Sqlite as back-end storage for the Google Safe Browsing v2 database

SYNOPSIS

  use Net::Google::SafeBrowsing2::Sqlite;

  my $storage = Net::Google::SafeBrowsing2::Sqlite->new(file => 'google-v2.db');
  ...
  $storage->close();

DESCRIPTION

This is an implementation of Net::Google::SafeBrowsing2::Storage using Sqlite.

CONSTRUCTOR

new()

Create a Net::Google::SafeBrowsing2::Sqlite object

  my $storage = Net::Google::SafeBrowsing2::Sqlite->new(file => 'google-v2.db');

Arguments

file

Required. File to store the database.

keep_all

Optional. Set to 1 to keep old information (such as expiring full hashes) in the database. 0 (delete) by default.

cache_size

Sqlite cache size. 20000 by default.

PUBLIC FUNCTIONS

close()

Cleanup old full hashes, and close the connection to the database.

  $storage->close();

CHANGELOG

0.9

Keep empty sub chunks. Improve performances (remove sone idexes, use trnsactions).

New cache_size option.

0.8

Index s_chunks_unique was created at the wrong place. Thanks to colinmkeith.

0.7

Add option keep_all to keep expired full hashes. Useful for debugging.

0.6

Use more efficient add_chunk_a and add_chunk_s functions.

0.5

Use base class Net::Google::SafeBrowsing2::DBI.

0.4

Disable journalization. This speeds up updated by about 10x.

0.3

Fix typos in the documentation.

0.2

Add close() function to clean up old full hashes, and to close the connection to the database cleanly.

Add table and function to store and retrieve the Message Authentication Code (MAC) key.

In some environments, the module was trying to re-create existing tables. Fixed (Thank you to Luis Alberto Perez).

SEE ALSO

See Net::Google::SafeBrowsing2 for handling Google Safe Browsing v2.

See Net::Google::SafeBrowsing2::Storage for the list of public functions.

See Net::Google::SafeBrowsing2::MySQL for a back-end using Sqlite.

Google Safe Browsing v2 API: http://code.google.com/apis/safebrowsing/developers_guide_v2.html

AUTHOR

Julien Sobrier, <jsobrier@zscaler.com> or <julien@sobrier.net>

COPYRIGHT AND LICENSE

Copyright (C) 2011 by Julien Sobrier

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or, at your option, any later version of Perl 5 you may have available.