The random rantings of a concerned programmer.
Archive for August 12th, 2008

(Untitled)

August 12th, 2008 | Category: Random

Regarding yesterday’s data import bullshit, there was one other complication — apparently PyGreSQL, a DB-API 2.0 interface for PostGRES doesn’t really handle the lastrowid cursor attribute well.

Or at least, the spec isn’t very nice about it. Rather than having an attribute which just gets set to None which PyGresSQL (or PostGRES, I don’t know) happily converted to 0, it would be better to make it a member function which raises a warning (or something!) when it’s being molested. Took me a while to figure that out, but it was pretty clear once I took a look at the dumps being produced. Dur dur.

In the meanwhile, I started writing an ncurses-based personal wiki application in C (probably going to back it with an SQLite database, provided the C API doesn’t suck balls). Got wordwrapping implemented yesterday; just need to finish up the wikilink parser (need to output a link map to translate mouse/cursor clicks) and it should be ready to wank on.

And hopefully be much nicer than running MediaWiki or any of the related “minimalistic-but-still-in-PHP-and-you-still-need-a-webserver” spinoffs (or a GTK/Qt/Whatever-based equivalent).

4 comments