I think. Ran into a snag yesterday regarding the size of postgres queries when I attempted to convert all my old ramblings over. The 16k limit was too small for some of my longer spiels.

So I spent a few hours searching mailing lists and documentation, learned about the large object system, wasted some time in denial, trying to find another way in which I could just stick to my simple insert and select statements, and finally decided I would just have to give in. Then I had to find the documentation for the perl interface to this junk. (And since it's not strictly part of the "pure" DBI functionality, I've more or less bound myself to postgres. Oh well. Worse injustices have been known to occur.)

I discussed it with bouncing a while. He believed the large object system to be more elegant anyway. I find myself in grudging agreement, but it's still a hassle to program when you're used to simple, direct queries. Oh well. It won't be too bad with the wrappers I've written.

After figuring (most of) it out, and having gotten oids into some usable routines in my database module, it was 2300, and I knew I needed sleep, so I decided to put off further enhancements until today.

This morning, I woke up, rebuild my database using the modified schema, performed some minor modifications on my conversion program to use the functions, and ran. Presto. I love it when things work. All my old ramblings are now in the new pg database. (I'll have to run it again for this one, though.)

Next: the movielog, then the links. Then I'll have to convince all these little modules I've been writing for the last 2+ months to work together as some sort of cohesive web page. Woohoo. I think something will be up by tonight.