The router finally arrived, but it’s knackered, so has to be replaced in a few days (after 20e worth of phonecalls and Pip’s time). In the meantime I’ve been using my Netgear.

I’ve found that not only do Free give you a fixed IP for free, they also give you reverse DNS, which most web hosts don’t even give you. So I’ve setup an A record in my DNS, so I can access my router from wherever I am without having to use something like DynDNS.

It’s been quite a while – almost a month since my last update.

Lots has been going on in France and my new house. I’ve got most of my stuff unpacked and in place, tidied the loft and nextdoor. Got satellite TV installed in two rooms, got ADSL and phone installed, new TV/hifi etc. Pip will be bringing my Xbox over when she goes to England next month.

We’ve carpetted and wallpapered the landing, stripped the wallpaper in my room ready for wallpapering, built a cupboard, got my computers installed on nice desks, run CAT6 network cable around the place, painted doors and mirrors and God knows what else – we may even be replacing the backdoor soon!

I got fed up with waiting for my ADSL modem to arrive from Free so plugged in my own router, and it works. I’m getting 2.4Mbps/163Kbps.

So I should be making more blog posts now.

I’ve just installed psychopg2, the new PostregreSQL driver for Python. For some reason the bundled setup.cfg has debugging turned on, so needs editting before compilation.

It’s syntax seems much the same as version one:

#!/usr/bin/env python

# import module
import psycopg2

# connect to database
dbconn = psycopg2.connect("host=localhost \
                            dbname=pgtest \
                            user=postgres \
                            password=password")

# create cursor
dbcur = dbconn.cursor()

# execute query
dbcur.execute("SELECT * FROM t_contacts")

# output results as list
print dbcur.fetchall()

I’ve packed my clothes and bought some shoes – a pair of cheap trainers and a nice pair of steel-toecapped shoes, which are not too booty but actually quite tidy.

I can’t find a freezer bag anywhere, or those blue things you put in the freezer, not in Sainsburys, Co-Op or Tesco!

My ebuyer stuff is on it’s way, so will get to me tomorrow via Citylink. I shall pack the car tomorrow night, I’ve got to check the oil/water/air as well when I get petrol.