Installing PsycoPG2 on OSX
June 7, 2009, 1:15 pm
Filed under: postgres

Today, I’ve been trying to get PsycoPG2 installed on my Macbook so that I can run through some tests and try and improve the user experience on Who’s Playing and hopefully increase it’s usage. I re-installed OSX the other week, and there’s still some little things like this to catch.

First off, I tried installing it via Macports, which worked Ok, but didn’t install it in a directory that the default Apple install of Python could see, it put it in the Macports directory. After a while I couldn’t find any way to change the install dir, so I ran:

python_switch python25

which lost all my other libraries, and the Django framework. Not quite what I wanted really.

python_switch python-apple

Will switch you back to the Apple install.

The easiest thing to do is just to download the latest psycopg2 tarball, and edit the setup.cfg file. I also installed Postgres from the official Mac binary, not from Macports, so I told it to use pg_config from that install. Uncomment the pg_config line and point it to your install of Postgres.


Then run

sudo python install

Job Done.

Update: For Snow Leopard users, you might also see the following error:

Symbol not found: _PQbackendPID

The solution, that I found on Kreegers blog, is to tell Snow Leopard that python needs to run in 32bit mode:

defaults write Prefer-32-Bit -bool yes


The Premier League is Heading for Disaster
June 4, 2009, 8:05 pm
Filed under: football, Premier League, soccer | Tags: , ,

The Premier League is heading for disaster, todays Guardian carries a story about the debts run up by the leagues clubs, it will come as no surprise that the top 4 in the league are also the top 4 in debt.

Chelsea and Manchester United are both £700 million in debt, Arsenal are £416m in debt and Liverpool are £280m in debt. Fulham are a surprising 5th at almost £200m, all these teams are either bankrolled by a millionaire owner or they’ve mortgaged the stadium and other assets and they’re owned by the banks (does that mean we actually own them?)

With this amount of debt, the only way the owners can ever hope to make their money back is to sell them to someone richer, but that can’t go on forever. Hoe many people in the world could afford to buy any of those top 4 clubs, and if they’ve had the business nouce to make that much money, would they think buying a football club in that position was good business?

For the big 4 clubs, the pressure to win is enorous, winning keeps their cash flow positive, the extra cash that the Champions League brings is a must, you only have to look at Leeds and the position they found themselves in not too long ago. What would happen if Arsenal, Chelsea, manchester United or Liverpool failed to finish in the top 4? Well I don’t think it would mean a collapse on the Leeds scale, but 2 seasons in a row? 3?

Whenever teams are under such vast pressure to win, there comes the temptation to cheat.

If you think I’m being over dramatic, you can look to Italy in 2006 when Lazio, Juventus, Milan and Fiorentina were all found guilty of match fixing and either relegated or banned from European competition. It’s not too hard a leap to make to see that kind of thing happening in the Premier League, or even the Championship with the riches up for grabs. It wouldn’t surprise me if we see such allegations in this country in the next 4 or 5 years, and when they do, the Premiership is doomed.