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
   
2001-01-12 02:17:47-05
 		  
  
Pathwalker
click to email

I love PostgreSQL.

Every now and then people talk about how great MySQL is, and I take another look at it.
I don't see how people can use a database without subqueries, transactions, and a point data type.

As an example, a few minutes ago, I wanted to set the default search radius for some images in a remote area to 0.4 degree rather than 0.1 degree.

First I opened a transaction, just to be on the safe side.
Then, I executed update pictures set dist=0.4 where box(location,location) @ box(circle( (select location from pictures where id=273),1));
After checking the number of modified rows, to make sure it seemed right, I ran a query or two to check the changes, and finally ran the commit;

I'd love to see how to do that under MySQL :-)


reply

click to email
discussion/thoughts/hungerf3/house/ofdoom.com