martinjevans's blog

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.

Common problems calling procedures in MS SQL Server via DBD::ODBC

Recently I've had a spate of issues reported in dbi-users mailing list and direct to me wrt calling procedures in MS SQL Server. I thought it might be worth covering some of the more common ones here.

How to protect my laptop when it is stolen

I've had a laptop stolen! It was a long time ago, I'd paid thousands for it (over £3000, it was a long time ago when laptops were a lot more expensive than now) and I was gutted. To make matters worse I'd not put a BIOS password on it and also this is when I discovered my mis-sold insurance policy only covered £1200. Thank you Skipton Building Society - not. I took it in to work to show a colleague Linux on it and made the mistake of leaving it in my bosses car whilst we went for a drink before going home. Someone got in to the underground car park, broke the window and made off with it - thief - sorry for your window boss. If I'd installed a BIOS password then at least I would have had the small comfort that although not impossible to get around, it would have made matters difficult.

New 0.19 release of DBIx::Log4perl

Recently I updated DBIx::Log4perl to handle DBI's clone method. This proved a little troublesome as clone is marked as "likely to change" and I'm not sure any other DBIx's have added clone. The problem I had was that clone does not call connect and all the code I had to add DBIX::Log4perl's attributes into the dbh was in connect.

DBD::ODBC and date/time/datetime/timestamp

Over the last few months I've been receiving an increasing number of emails from people experiencing problems inserting date/time/datetime/timestamp values into MS SQL Server specifically although not exclusively. There are a number of MS SQL Server ODBC drivers but the ones I see the most (in no particular order) are a) MS SQL Server ODBC Driver b) MS SQL Server Native Client driver c) Easysoft's SQL Server ODBC Driver and d) freeTDS. I hope to write a more expansive tutorial on this in the near future but until then I hope this blog post will help.
Syndicate content