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@xxxxxxxxx Web: https://ngtech.co.il/ My-Tube: https://tube.ngtech.co.il/ -----Original Message----- From: squid-users <squid-users-bounces@xxxxxxxxxxxxxxxxxxxxx> On Behalf Of Amos Jeffries Sent: Thursday, 14 July 2022 11:57 To: squid-users@xxxxxxxxxxxxxxxxxxxxx Subject: Re: 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@xxxxxxxxxxxxxxxxxxxxx http://lists.squid-cache.org/listinfo/squid-users _______________________________________________ squid-users mailing list squid-users@xxxxxxxxxxxxxxxxxxxxx http://lists.squid-cache.org/listinfo/squid-users
