FreshPorts has a CVS history that dates back to mid 2000 (and that’s just what I could find with a quick search). It started on a MySQL, which isn’t really up to the job. It quickly moved to PostgreSQL, the finest database server out there, and it just happens to be Open Source. […]

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 […]

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 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.

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.

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 […]