Archive for the 'PostgreSQL' Category

FreshPorts downtime

Saturday, November 4th, 2006

Earlier this week, we had a bit of a crisis. The colo which provides bandwidth and servers to FreshPorts (and all the other websites I run), was unexpectedly shutdown. BChosting sold their Vancouver facilities to Netluxe, who, by all accounts, shut down the ops center without notifying customers. Well, I wasn’t notified. […]

Improved Watch List sorting

Sunday, October 15th, 2006

Christian Ullrich found a problem with the Watch List updating pages. Over the past few weeks, we’ve been working on fixing it. I’ve been coding. He’s been verifying. Today we fixed it. The changes should go into production soon (if they aren’t already).
The other thing he mentioned was sorting by last […]

Improving the search - pagination

Friday, October 13th, 2006

I’ve spoken about pagination before. Use the search to see where. I’ve started adding pagination to the Search page. I’ll be using Pager form PEAR again.

Python listening now in production

Monday, September 11th, 2006

The Python listening script is now in production. With a few luser-type problems along the way. Specifically: I have discovered, quite recently, that having the same name for both the NOTIFY command and the LISTEN command is kind of a good strategy when you actually want your listener to be notified. The […]

Adding stubs for listening - data driven

Saturday, September 2nd, 2006

Following on from the previous post, I found myself with a few hours to myself tonight. The estrogen in the house went out as a group so I managed to do a bit more coding on the FreshPorts listening daemon.

Data driven listening

Saturday, August 26th, 2006

Data driven applications are a good concept to keep in mind when design an application, especially when that application needs to have new bits added to it on a regular basis. My idea for using Python to listen for FreshPorts events is a case in point.

More on Python Listen

Saturday, August 26th, 2006

Today I started playing with Python again. My goal is to create a listening “daemon” to process PostgreSQL events. I wrote about my initial proof of concept at the start of the month. Today, it’s time to look at using this for real.

Python, PostgreSQL, and LISTEN

Tuesday, August 1st, 2006

PostgreSQL is my database of choice. Any who has worked with commercial databases will find more in common with PostgreSQL than any other open source database.
I moved to PostgreSQL for the transactions, the stored procecdures, and the relational integrity Sure, other databases have begun to catch up, but they still don’t have the […]