Perl

The Perl programming language

DBD::ODBC 1.23_1 development release

I released a new development release of DBD::ODBC the other day. Here is an extract from the change log:

Changes in DBD::ODBC today

Noel Burton-Krahn posted a patch for UTF-8 encoded data in Aster (based on Postgres) today. This prompted me to complete a number of small changes I had in the fire and incorporate his changes.

Some tidying up in DBD::ODBC

I've got a little behind in the work that has been gathering for DBD::ODBC lately so a few days ago I rt'ed a list of jobs in the hope that would stir me into action.

Are you using cygwin and unixODBC?

If you are using cygwin and unixODBC I'd like to know. I am about to make a change to DBD::ODBC which might stop it detecting unixODBC under cygwin so would appreciate talking to anyone who uses this configuration.

Faster way to serialize a Perl hash

As anyone who reads my blog knows we've been profiling a large amount of Perl code recently. A daemon process receives jobs to run and in most cases (a few are run immediately) places them on a queue in the database. For a queued job we are really interested in the turnaround time i.e., the time from seeing an incoming request, decoding it (it is in JSON), checking it, inserting the request into the database and returning a unique job ID; obviously this determines how quickly we can queue jobs.

benchmarking and profiling Perl and SQL

It is often said don't optimize too early. I try very hard to keep to that, and I do mean very hard. In the project I am working on now we have a basically working implementation (although some functionality is still to code, it is on the edges - this probably counts as too early - oh dear). We have a rather complicated setup which I don't have the time to go into here but at its simplest it is the age old client-server relationship and involves a lot of database (Oracle via DBD::Oracle) access. The client in this case is really a daemon process receiving work to process and either processing it or passing it on to another server to be queued and worked on later.

DBIx::Log4perl rt 50134 'identifier quote wrong'

David Gasson reported identifier quote wrong in DBIx::Log4perl. Since he identified the problem, provided working examples and even highlighted the change to fix the problem I applied it and released 0.16 immediately.

DBD::ODBC 1.22_3 released

I uploaded DBD::ODBC 1.22_3 to CPAN yesterday.

rt48304

New rt for DBD::ODBC at DBD::ODBC - [Microsoft][SQL Server Native Client 10.0][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. The SQL Server native client driver has proved to be a bit buggy and this /may/ be another one - we'll have to wait and see. DBD::ODBC already has a number of workarounds for issues in the MS SQL Server ODBC Driver and Native Client Driver.
Syndicate content