Re: SquidGuard patch for IPCop 1.9.19 revision 5535

On Sun, Mar 27, 2011 at 9:37 AM, David W Studeman <[email protected]> wrote:

> [...] The addon
> added libdb to a system that did not contain it whereas libsqlite does exist
> in 2.0 already so again if libsqlite would be possible to use it would be
> one more step of using what is there already.
>

I've already read the source code of SquidGuard 1.4 and 1.5-beta, and
I found out that Berkeley DB was so hardwired into the code, you would
have to rewrite more than about 75% of it to make SquidGuard recognize
SQLite as a storage alternative. There is MySQL support since version
1.4 but only for user authentication, not for the blacklists database.

There's a whole lot of debate on whether SquidGuard should support
blacklists storage other than Berkeley DB (such as SQL databases for
storage). One side believes that Berkeley DB is already "fast enough"
and does not need replacement; the other side believes that supporting
SQL databases will increase SquidGuard's flexibility and ease of
maintenance. See the following links:

http://www.squid-cache.org/mail-archive/squid-users/200303/0062.html
http://www.squid-cache.org/mail-archive/squid-users/200303/0139.html
http://www.squid-cache.org/mail-archive/squid-users/200303/0151.html

But by the way, Berkeley DB 5.x supports an SQL API via SQLite. See also:

http://www.oracle.com/technetwork/database/berkeleydb/overview/index-085366.html

But downloading Berkeley DB 5.x requires registration on the Oracle
website. The registration is free, but might be incompatible with the
"./make.sh prefetch" operation.

------------------------------------------------------------------------------
Enable your software for Intel(R) Active Management Technology to meet the
growing manageability and security demands of your customers. Businesses
are taking advantage of Intel(R) vPro (TM) technology - will your software 
be a part of the solution? Download the Intel(R) Manageability Checker 
today! http://p.sf.net/sfu/intel-dev2devmar