[squid-users] MS-SQL with squid helpers

[ngtech1ltd at gmail.com]

There is a new mssql driver for linux named:
free_tds

Which is superior to ODBC which perl mostly uses in the DBI library.
It's pretty simple to install free_tds and from my tests it seems like the better choice.
I will try to write an example for session helper using free_tds and ruby.
For me Ruby is the simplest to write, test and use with such simple and tiny projects.
It's not worth writing it in other languages unless there is server component to the service.
It's possible to write more robust server side code which supports threading and parallelism in other languages.
But for most use cases and my experience it's cheaper to use a bit more RAM and CPU compared to writing
a very good server side code.

Amos,
I have also tested MSSQL as a blacklist categories backend and it looks promising.
MySQL would be OK but MSSQL and Oracle takes much more load for specific use cases.

Working on the helper...

Lookup of for the next week Squid-Cache community meetup.

----
Eliezer Croitoru
NgTech, Tech Support
Mobile: +972-5-28704261
Email: ngtech1ltd at gmail.com
Web: https://ngtech.co.il/
My-Tube: https://tube.ngtech.co.il/

-----Original Message-----
From: squid-users <squid-users-bounces at lists.squid-cache.org> On Behalf Of Amos Jeffries
Sent: Thursday, 14 July 2022 11:57
To: squid-users at lists.squid-cache.org
Subject: Re: [squid-users] MS-SQL with squid helpers

On 26/06/22 23:27, ngtech1ltd wrote:
> Hey Everybody,
> 
> I was wondering if someone wrote a set of helpers that works with MS-SQL 
> server database?
> 

(I see you went ahead with this already, just responding for anyone in 
future).

Squid ships with several DB helpers, for both authentication and 
external ACL lookups. They are based on Perl so any database which Perl 
provides a DB interface for can be used with those helpers.


Cheers
Amos
_______________________________________________
squid-users mailing list
squid-users at lists.squid-cache.org
http://lists.squid-cache.org/listinfo/squid-users