Having just released DBD::SQLite 1.10 to CPAN I'm about to upload 1.11 to update it. After some interesting discussion on the SQLite mailing list about blobs and how DBD::SQLite handles them it turns out there's a simple way for me to support blobs without needing for users to resort to the current contortions. So now blobs will just work transparently (with a caveat in the docs about string lengths using the SQL length() function when you don't insert explicitly as a blob).
The other thing that has happened to me lately is a huge amount of frustration with my internet connection. I thought this was a problem with Bell, as they are having major problems at their end (presumably due to over subscription - but I don't really know). However after finally doing some debugging today I discovered what was wrong...
It seemed odd to me that Heather hadn't been complaining of any problems. So I wondered if the problem was localised. Pinging my DSL modem I discovered I was getting about 70% packet loss. Very strange. I tried to reboot everything - my computer, the modem, and the Airport Express. No help. So I puzzled for a bit over this. What had changed?
Well a week or so ago I bought myself a really cheap USB2 hub. Really cheap in that it isn't a powered device (though it has a power socket - it doesn't require power). You probably know what is coming now.
Turns out this little USB device must have been taking power from the airport card, and although the signal strength looked just fine on the screen, it must have been causing it to fail in mysterious ways.
I've unplugged it now, and I'll try and find power for it, but for now all is well.
Re:Great work on the BLOBs! Next...
Matts on 2005-12-03T13:42:03
You'd have to use a separate database:-)
I don't understand why sequences can't get rolled back though. Perhaps this is something to discuss on the sqlite list?
Now I just need to try and get a similiar patch into DBD::mysql as well...
-Dom