MySQL Connector/Python and Windows: kinda works

I didn’t test MySQL Connector/Python on a Microsoft Windows machine, but after somebody did and filed a bug report, I couldn’t resist launching VirtualBox. Fixing the problem with socket.MSG_WAITALL not being available on Windows wasn’t much work. However, adding support for MySQL’s Named Pipe on Windows seems to be a bigger challenge. I couldn’t find docs for win32api anymore on Python’s doc website for win32api, which is referenced everywhere, so I guess somebody needs to give a hint or write a patch.

How to install MySQL Connector/Python

Currently, MySQL Connector/Python is only available through Launchpad. Here’s a small how-to for installing it using the Bazaar bzr client tool. All you need is a machine with Python installed (v2.3 or higher, but not v3.x), and.. well, that’s it! $ bzr checkout lp:~mysql/myconnpy/main myconnpy $ cd myconnpy $ sudo python setup.py install Please check it out. It’s not feature complete yet, and probably can use some code optimizations here and there.

Fixing iPhoto's AlbumData.xml for importing into Google's Picasa

Yesterday I gave Google’s Picasa again a try. Importing my iPhoto library I ran into the now infamous error message: “corrupted AlbumData.xml”. The Apple support website has some tips on how to fix this, but it’s too vague. Luckily there are smart people out there and I stumbled upon a good way in the Picasa help forums to debug your AlbumData.xml using TextWrangler. Install TextWrangler if you haven’t already. Open your iPhoto Library using Finder: right-click (Ctrl-Click) and select ‘Show Package Contents’.

MySQL, Python and MacOS X 10.6 (Snow Leopard)

This has been already mentioned in on a few blogs, but I thought it would be good to post here too. Note: this is not using MacPorts! To get MySQL and Python going on MacOS X 10.6 you need the following: Download MySQL MacOS X 10.5 (x86_64) tar ball. Yes, we download for v10.5 currently. Get a copy of MySQL-python Install the latest XCode tools found on the Snow Leopard CD under option installs or download it.

MacPorts and Mac OS X 10.6 (Snow Leopard)

EDIT: I’m a bit late with upgrading to Snow Leopard (just a few days!) but MacPorts has a package available which should work with Mac OS X 10.6. If you want to use MacPorts on Mac OS X 10.6 (Snow Leopard) and can’t wait for the next release, you best get the latest from the SVN repository (posted on MacRumors): Get the latest XCode first: the one you installed on Leopard might not work.