I again had little time to work on this, so today I replicated the page showing the information for an individual tournament.
[more...]

I didn’t get much time to work on this today, and forgot about one feeature that took a little more time.
[more...]

The standings page is almost done. I have most of the functionality I want, running into problems only with the “last ten tournaments” standings.
[more...]

It took me less than an hour to go from the finished player page to a working basic version of the standings page (yay Python/Pylons/Genshi!). However, when running all the players (193 in the data set I’m using) against the entire set of results (2787 rows in this data set) it took more than thirty seconds to produce the page.
[more...]

I finished duplicating the functionality of the old player info page tonight. I’m pretty happy with how that went.
[more...]

It turns out that adding multiple WHERE clauses with SQLAlchemy’s SQL Expressions is very easy—you just tack them on using the where() function.
[more...]

Progress hasn’t been significant since yesterday, I haven’t had that much time. Right now I’m at the point of reading in parameters from the query string (easy) and looking for the most efficient way to use SQLAlchemy’s SQL Expressions to construct constraining select statements based on those parameters (not quite so easy for me, given that my lack of knowledge about SQLAlchemy makes ‘most efficient’ a difficult bar to know I’ve reached). Along the way, I got distracted and amalgamated some other people’s answers to get a useful code snippet.
[more...]

Having gone through some hoops trying to get this rather simple step to work, I can now talk to the database and have the results shown in a Genshi template.
[more...]

This isn’t much of an update. Over the last two days I’ve been struggling with installing SQLAlchemy, a database wrapper/object-relational mapper for Python. It’s the default database interface layer in Pylons, and I had been anticipating easy setup and use for the simple side of the database transactions I want to do.
[more...]

So far, this effort has not gone well, and none of that has anything to do with Pylons itself.
[more...]

At work we use the Pylons web framework, and I like it quite a lot, so I’m going to use it for sfmagic.org.
[more...]

While I’m generally averse to complete rewrites, I’m nevertheless going to redo sfmagic.org in Python.
[more...]

I’m way behind on data entry for sfmagic.org, so the first thing I need to do to improve it is to get it up to date. It would help to have a better system for entering the data.
[more...]

Well, today’s post was supposed to be about plans for sfmagic.org, but when I got home (relatively late) I discovered that my desktop machine had died. Again. I hate being on such an unstable platform, which XP has been for me.
[more...]

I’m a little behind schedule for December. I’m still going to try to work on sfmagic.org for this month, moving it over to Python and Pylons, and possibly to PostGreSQL, and moving it to a different server.
[more...]

I finished the second draft nine days behind schedule, which in the overall scheme of things isn’t that bad a slip. It turned out to be extremely difficult to maintain a steady approach to the editing, unlike either the micronovel version or the first 35 episodes of AFBH, two projects of similar duration that I completed successfully (and on time) last year.
[more...]

Yes, done
[more...]

Tomorrow, tomorrow, tomorrow.

I’ll do my best to finish over the next two days.

I was on the top floor of the Chevron Building at 575 Market today, and took some photos.
[more...]

No progress. I’m stalled again. It’s unbelievabley frustrating to be stalled so close to the end. Hopefully I’ll get over it soon. One long burst of activity would finish the damn thing.

I’ve been watching the fourth season of The Wire, and it’s amazing, just like the previous three seasons. Gritty and depressing in parts, but amazing. This season has a significant focus on the public school system in Baltimore, and stands as a scathing critique of that system.
[more...]

Little progress tonight, despite the word count. The chasm between “writing” and “not writing” as states feels like it’s widening, making it harder to go from one ot the other. It was like that at the start, and when I got stalled in the middle. I have to assume that will is what it takes to flip the switch, but an inadequate explanation of the concept of will has always undermined the usefulness of that assumption.
Word count: 72034