NAME

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

SYNOPSIS

  use Net::Google::SafeBrowsing2::MySQL;

  my $storage = Net::Google::SafeBrowsing2::MySQL->new(host => '127.0.0.1', database => 'GoogleSafeBrowsingv2');
  ...
  $storage->close();

DESCRIPTION

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

CONSTRUCTOR

new()

Create a Net::Google::SafeBrowsing2::MySQL object

  my $storage = Net::Google::SafeBrowsing2::MySQL->new(
      host     => '127.0.0.1', 
      database => 'GoogleSafeBrowsingv2', 
      username => 'foo', 
      password => 'bar'
  );

Arguments

host: Required. MySQL host name
database: Required. MySQL database name to connect to.
username: Required. MySQL username.
password: Required. MySQL password.
port: Optional. MySQL port number to connect to.
keep_all: Optional. Set to 1 to keep old information (such as expiring full hashes) in the database. 0 (delete) by default.

PUBLIC FUNCTIONS

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

close()

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

  $storage->close();

CHANGELOG

0.6: Remove some indexes to speed up INSERTs.
0.5: Keep empty sub chunks. Shorten prefixes greater than 8 bytes (workaround to keep schema tight)
0.4: Add option keep_all to keep expired full hashes. Useful for debugging.
0.3: Use more efficient add_chunk_a and add_chunk_s functions. Change data type for prefixes from VARCHAR to VARBINARY.

AUTHOR

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

COPYRIGHT AND LICENSE

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.