Head Down
Wow, It’s been a week. All three of you have probably noticed.
What’s changed…. I still don’t care about the subway series, except that it’s probably going to leave half of New York mad at the other half. The best line I’ve heard about it was on NPR’s Wait Wait, Don’t Tell Me, regarding what a Sox/Cubs series would be called. The “Hell Freezes Over” Series.
I lived in upstate NY for a while, and I do miss it. It’s got bearable summers, real winters, and crisp falls. And they have Bagels. Not bagel shaped bread. There are no bagels west of New York State. It just doesn’t happen.
I’ve been playing with Andre’s Frontier-Postgres database connector. One of the results is the search engine on the navbar. The other is a little hacking of the Userland aggregator.root release to store all the data in the relational database. It appears to work, and that sort of scares me. The front page (such as it is) is here.
4 comments
I’ve been playing with Andre’s Frontier-Postgres database connector. One of the results is the “search” engine on the navbar. The other is a little hacking of the Userland aggregator.root release to store all the data in the relational database.
I assume you are using extensions.PostgreSQL on Mac OS? Have you encountered any networking problems? Is it fast enough for what you are doing?
I assume you are using extensions.PostgreSQL on Mac OS?
Yes, Os9.04, one installation is frontier 6.2, one is 7.0b18. Both seem to work pretty well.
Have you encountered any networking problems?
I’ve encountered one problem that may or may not be network related. I haven’t tracked it down enough to know where the problem lies. (could be my sql, my understanding of what I need to clean up, my lack of error catching, your extension, some installation thing) Basically, If I try to send 100 items to the database in one connection, (something like 500 queries) some of them work, and then at some point they start to fail. This does not seem to happen when I open a connection for each item.
Is it fast enough for what you are doing?
It seems somewhat faster than using xml-rpc to talk to effectively the same code in php locally querying the database. So far it doesn’t appear to be the limiting factor in anything that I’m doing, but I haven’t hammered it as hard as I could.
eric
Basically, If I try to send 100 items to the database in one connection, (something like 500 queries) some of them work, and then at some point they start fail.
Do you get an error message or does it just hang?
Do you get an error message or does it just hang?
It’s not hanging. The operations are inside some try/else brackets that aren’t saving the error.
So it may be throwing an error that I’m blindly ingoring. I need to go through it a little more to actually determine what’s happening.
eric