Once it was said...
   
2001-01-12 01:16:28-05
 
 
  
Database Upgrade

Well, I just finished upgrading the database driving this server from PostgreSQL 7.0.2 to PostgreSQL 7.1.0 Beta 3.

The maid advantage for this upgrade was the Tuple-Toaster, which should allow comments and message postings of unlimited length 1

This should also allow me to store images inside the database, rather that just storing references to external files. since cimg can take data from a database field, I'm looking forward to playing with this.

The upgrade also helps with the GIS functions, and R-Tree indices I've been using for imgdb - under the old version, the box(location,location) @ box(circle(center,radius)) searches were leaking a little memory. Not much with each one, but they were being called 4-5 times per page view.

Next on the upgrade list, I think I'll take a look at Roxen 2.2 alpha...


reply

And you replied...
Name:
E-mail:
Web: