martinjevans's blog

DBD::ODBC 1.31 release

I have just uploaded DBD::ODBC 1.31 to pause. This is the culmination of 7 development releases and I thought it was time to do an official release. Due to personal issues I am unlikely to be doing another update to DBD::ODBC in the near future but if you find issues please report them on RT and I'll try my best. The changes since 1.29 are below. There are significant changes since the last official release and a few changes in behaviour. If you didn't test a development release and it now goes wrong I'm sorry but after 7 development releases you had your chance.

Is my new Nikon D3100 broken? too dark warnings in bright light

I've recently stepped up from a bridge camera (a Panasonic Lumix) to a Nikon D3100 DSLR. I like the camera in general but one issue is bothering me a lot and it is the exposure metering and a too dark warning.

Switching to Data::Dump from Data::Dumper for some projects

Like many people I've used the Perl module Data::Dumper for years and been reasonably happy with the output. Generally I want the output rolled up into the smallest (line-wise) output and Data::Dumper allows this. However, I use Math::FixedPrecision quite a bit in this project and as it is a blessed object the fixed precision numbers of 2 come out ridiculously verbose and almost unreadable.

DBD::ODBC 1.30_6 is released - please test

I've just released DBD::ODBC 1.30_6 to CPAN. This is the culmination of 3 months of changes through 1.30_1 to 1.30_6 and also contains a few changes in behaviour (you are warned). It is unlikely that I will get much chance to do anything with DBD::ODBC for the next few months so I really need feedback before this becomes 1.31. Here is a list of changes since 1.29:
  1. Changes in DBD::ODBC 1.30_6 June 4, 2011
    • [BUG FIXES]

The Perl Community, thank you

I've been using Perl on and off for over 15 years. In the last 10 years of so I've been using Perl a lot in my work and play. I don't have a huge list of modules I look after but I maintain a couple of modules and contribute to many. What never ceases to amaze me is the Perl community. By that I mean the huge group of people working tirelessly to improve the Perl core, write Perl modules and applications, organise conferences and workshops, test Perl and CPAN, report issues, support Perl on IRC, the many mailing lists and web sites and give freely their knowledge and expertise to others. Thank you.

Building DBD::ODBC against unixODBC on 64 bit platforms

A word of warning. The build process for DBD::ODBC against unixODBC on 64 bit platforms may not produce a workable solution perhaps even segfaulting. The short reason is that few Linux distributions/packages of unixODBC are up to date and few distribute unixODBC's odbc_config which DBD::ODBC needs to ascertain the compiler defines required to build a DBI driver which matches unixODBC. The long answer which which includes a workaround follows.

Some background:

New 1.30_1 development release of DBD::ODBC

I've just uploaded DBD::ODBC 1.30_1 to CPAN.

If you use Windows or a Unicode build of DBD::ODBC on non-Windows platforms you should really test this release as it contains a change in behaviour for Unicode. This release also contains a small but perhaps significant change to the silent rolling back of a transactions when disconnect was called when AutoCommit was disabled. The complete changes since 1.29 are below. Again, many thanks to all the people RTing issues and providing feedback/testing.

More things that don't work with MS Native Client driver

I'm mostly blogging this as a reminder that I've received even more code using Perl and DBD::ODBC via the MS native client driver (not the MS SQL Server ODBC driver which works) which fails in strange ways. This code came to me via Rafael Kitover (@Caelum) and was a cut down demonstration of something dbic does/did? The first example is:

Facebook authentication with Perl - problem and resolution

Recently I've been required to look at writing a Facebook application. I don't use Facebook and have little interest in it myself. I looked around for a quick start with Perl and Facebook and came across Facebook Authentication with Perl and Facebook::Graph which looked interesting to follow and work through.

Putting aside the problems I had getting something set up on our system that allowed Facebook to post back to us I was left with the error:

Syndicate content