PHP/pg

I Was up until 3am this morning, I’ve got the programming bug I guess! I’ve downloaded a lot more ebooks too. I converted my DVD database to PostgreSQL. It wasn’t actually that difficult, I just changed the following: PHP: mysql_connect to pg_connect mysql_fetch_array to pg_fetch_array mysql_query changed to pg_query SQL: LIMIT x,y changed to LIMIT y OFFSET x NULL changed to DEFAULT on the serial column Schema: auto_increment column changed to serial

X-Men 3

Just watched X-Men 3 at the cinema, it was pretty good, seemed a little rushed – maybe they’ll make an X-Men 3.5 like they had to with 1.5, as they left so much out of the theatrical realease. It was better than X2, and despite being called “The Last Stand”, there could be an X4, especially if you see the bits just before and just after the end credits, Halle Berry alluded to it too.

Upgrading software

I just installed a new version of quickcode, used below. Also did a huge yum update on Solo, which included a new kernel, which means that I then need to install the NVidia drivers, and run vmware-config.pl (rebuild vmmon modules) and vmware-config-mui.pl (generate new SSL cert). Then to build the webcam driver: rm -rf /lib/modules/2.6.11.11.something/kernel/drivers/usb/media/pwc /sbin/rmmod pwc wget http://www.saillard.org/linux/pwc/files/pwc-10.0.12-rc1.tar.bz2 tar -jxvf pwc-10.0.12-rc1.tar.bz2 cd pwc-10.0.12-rc1 make && make install chmod 744 /lib/modules/2.

PostgreSQL

Been playing with PostgreSQL and Python again. I’ve installed pyscopg, pgdb and pg modules, as well as the adodb database wrapper. I must say I am impressed with the number of RPM packages available for Fedora 5 via yum, I’ve only had to install three or four programs manually, and that’s mainly because they were closed-source (Java) or very specialised (Sybase). Just watched episode 22 of Lost series 2, one more episode left….

Friday

Went to the pub at lunchtime today. Other than that I’ve just been rewriting a crappy script that some Scottish kid wrote that’s now broken due to the read-only fileserver. Mother’s Day in France on Sunday. I bet the card I left has been lostput somewhere safe 😉 Gonna finish watching Lost tonight I think, the final episode is in the mail apparently!