I got into trouble yesterday. Or rather, FreshPorts got into trouble because of me. It all centered around a new category called net perl5. I first notice the problem when I received an SQL error message: ERROR: null value in column “last_update” violates not-null constraint CONTEXT: SQL statement “INSERT INTO category_stats ( SELECT categories.id AS […]
Tabs instead of space got me into trouble Read More »
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 problem? The code
Python listening now in production Read More »
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.
Adding stubs for listening – data driven Read More »
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.
Data driven listening Read More »
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.
More on Python Listen Read More »
Cydex suggested this one. Visit this commit and look at the the links to Makefile, distinfo, and pkg-plist. They each now contain a bookmark (e.g. #rev1.44). In addition, and something you may not have noticed, the icon to the left of the File name contains a link to the annotated version of that file revision.
Better links into CVS Read More »
On August 9, Mark Linimon was talking about having users rank ports. The goal being to approximate a list of ‘key’ ports. I suggested allowing people to nominate their top N ports. And only N. They can change their selection at any time. It would be like a vote or poll, but you get to
Vote for your TOP n ports Read More »
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 polish
Python, PostgreSQL, and LISTEN Read More »
Last night I discovered a caching bug related to vuxml processing. I fixed it. Today I realized the same issue affects processing of MOVED and UPDATING. Coded both of them today as well. Anyone got a MOVED or UPDATING commit just waiting to happen? ;) Ideally, I’d be able to find somewhere in the database
MOVED & UPDATING need cache removal code Read More »
Today I discovered and fixed two problems with VUXML processing. The cronjob that processed VUXML changes was commented out. The last time it had run was July 9th. Uncommenting the entry fixed that issue. The VUXML processing did not clear the cache. I wrote and testing that code just now. It’ll run in BETA for