Particularly important for Bricolage are the ability to drop columns and the new support for prepared SQL statements. Every major release of Bricolage requires changes to the database, often including the removal or change of a table column. Now that PostgreSQL can drop columns, future Bricolage upgrades can change database columns without leaving deprecated columns in the database.
Furthermore, Bricolage runs in an Apache/mod_perl environment where many of the same database queries are executed many times over. The new support for prepared statements in PostgreSQL 7.3 will greatly enhance performance by reducing the number of times each of those SQL statements is prepared by PostgreSQL to once per Apache process -- for the lifetime of the process.
These enhancements in PostgreSQL are great because they'll improve not just the database, but all applications that are built upon it. The speed with which PostgreSQL continues to develop and provide trickle-down benefits to the applications that depend upon it is simply second-to-none.
Regards,
David
PS: eWeek has covered Bricolage here:
http://www.eweek.com/article2/0,3959,652977,00.asp
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber: [EMAIL PROTECTED]
On Tuesday, November 26, 2002, at 03:20 PM, Bruce Momjian wrote:
I just spoke with Lisa Vaas from eWeek. She is writing an article on
the upcoming PostgreSQL 7.3 release. (The release of 7.3 is scheduled
for tomorrow.)
She would like comments from users about the upcoming 7.3 features,
listed at:
http://developer.postgresql.org/docs/postgres/release.html#RELEASE-7-3
If you are interested, please reply to this email with any comments you
might have. I have directed replies to her email address. She would
like comments within the next few hours, until midnight EST.
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
