martinjevans's blog

DBD::ODBC 1.24 official release now on CPAN

I have uploaded the official 1.24 release of DBD::ODBC to CPAN. Many thanks to everyone who has helped with this whether it was patches or testing. Here are the changes since 1.23: =head2 Changes in DBD::ODBC 1.24 May 14, 2010 Minor change in Makefile.PL to only use NO_META if ExtUtils::MakeMaker is at least at version 6.10. Reported by Chunmei Wu. Minor change to test rt_50852 which had wrong skip count. =head2 Changes in DBD::ODBC 1.23_5 May 6, 2010 Added advice from Jan Dubois (ActiveState) on building DBD::ODBC for ActivePerl (see

DBD::ODBC 1.23_5 released - soon to move to official 1.24 release

I the last few days I released another development release of DBD::ODBC 1.23_5. I've been waiting for smoke testers to attack this release and then I will do an official 1.24 release. Since very few smokers actually run the test code I'm going to look at Test::Database for the next release - if you are a smoker and have Test::Database setup for DBD::ODBC I'd love to hear from you (really). 1.23_5 contains the following changes since 1.23: =head1 CHANGES =head2 Changes in DBD::ODBC 1.23_5 May 6, 2010 Added advice from Jan Dubois (ActiveState) on building DBD::ODBC for

Testing DBI's DBDs

I've maintained DBD::ODBC for some years now but one thing that constantly causes me problems is finding enough testers to be sure a development release is good enough to be released officially. CPAN Testers do a great job (and I joined the clan for a while until the throttling issues last Xmas and now I wait for CPAN Testers 2) but very few (if any) have a data source set up to a real database. Mostly the reports I get are PASS but when I look at them there was no actually data source set up so no real database tests actually ran.

New 1.23_4 development release of DBD::ODBC - faster - please test

I have just uploaded a new development release of DBD::ODBC 1.23_4 to CPAN. This is very much an experimental release but unless I hear any negative reports I will release this as 1.24. If you use DBD::ODBC you SHOULD test this release as it contains some significant changes to speed up prepared statements and as DBD::ODBC has to support a large number of ODBC drivers I have not been able to test the dozens of possibilities myself. If you use the MS SQL Server ODBC Driver or Native Client this change will definitely impact you and for other drivers this should reduce calls to SQLBindParameter.

DBD::ODBC Speedups

In the last few days whilst hanging out on the #dbi IRC channel I saw messages from someone using/developing OTRS (Open source Ticket Request System) with DBD::ODBC.

#dbi channel on IRC

I know that not everyone is in to IRC and I for one have only flirted with it over the years but for the last 6 months or so I've frequented the #dbi channel and there are a number of knowledgeable and helpful people on it but there is a low representation from DBD authors/maintainers.

Humax Foxsat satellite receiver and Belkin F5D7330 Wireless Gateway

I have a Humax Foxsat HD Satellite Receiver I use in the UK.

I saw on channel 999 and at BBC Iplayer on Freesat that the BBC Iplayer is available on beta to humax users with a broadband connection. As a previous Virgin/NTL subscriber the one thing my wife and I miss is being able to watch the IPlayer on the television so this sounded great. The problem is my router is a good distance away from the television but I have a wireless router plugged into the back of a cisco plugged into the back of my NTL modem so wireless seemed just the trick.

Finer Last-Modified times in lighttpd

For various reasons I won't go in to here I needed finer granularity in the Last-Modified and If-Modified-Since HTTPD headers for a project I am working on. Since Linux 2.5.48 the file modification time has a granularity of nanoseconds - here is the quote from the man page:

get_iplayer - download BBC iplayer content

Sometimes something comes along that truly impresses me. get_iplayer is one of those things. As a UK resident who uses iplayer three or four times a week and a Perl fan get_iplayer really caught my interest. The idea that you can list all of the BBCs iplayer content then download whatever you like to watch whenever you like really did interest me. First I tried downloading it from github but it failed to find updates. Then I noticed it was available as an Ubuntu package and installed it. After that a:

DBIx::Log4perl release 0.20 - bugfix and new feature

I've just released v0.20 of DBIx::Log4perl. DBIx::Log4perl is a Perl extension for DBI to selectively log DBI methods, SQL, parameters, result-sets, transactions etc to a Log::Log4perl handle. This release fixes a problem where execute_array tuple status was reported at INFO level instead of DEBUG level and adds the DBIX_L4P_LOG_DELAYBINDPARAM constant which delays logging bind_param methods in DBI until the execute method is called.
Syndicate content