---
name: "Net::Google::SafeBrowsing2::Sqlite"
section: "3pm"
platform: "linux"
package: "libnet-google-safebrowsing2-perl"
version: "1.07-6"
release: "Debian 10 (Buster)"
platforms: ["linux"]
url: "https://new.carta.tech/Net::Google::SafeBrowsing2::Sqlite"
---

# Net::Google::SafeBrowsing2::Sqlite(3pm)

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

## 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.

## 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\.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).

- 0\.3

  Fix typos in the documentation.

- 0\.4

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

- 0\.5

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

- 0\.6

  Use more efficient add\_chunk\_a and add\_chunk\_s functions.

- 0\.7

  Add option keep\_all to keep expired full hashes. Useful for debugging.

- 0\.8

  Index s\_chunks\_unique was created at the wrong place. Thanks to colinmkeith.

## 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.