Thread: Request from eWeek for 7.3 comments
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 pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Hi Lisa, I'm the Lead Programmer for a company that specialises in online weight loss programs in Australia and the USA. We started off using MySQL but turned to PostgreSQL when it became obvious that MySQL lacked many necessary features required for a maximum power and data integrity. We have followed PostgreSQL through from 7.0 and will upgrade to 7.3 when it comes out. Each new version has added an incredible amount of new features. You only have to compare the release notes of Postgres against other databases to see how fast Postgres is being developed. Postgres has a reputation (deserved or not) of being hard to use. In 7.3 a lot of work has been done to 'fill in the gaps'. eg. In 7.3 you are able to drop columns from tables and change the NOT NULL status of a column easily. Foreign keys are smarter and are easier to drop and manipulate. On the other hand, PostgreSQL 7.3 will be great for academic environments. With the addition of SQL schemas, administrators can now create separate workspaces for all their users. Permissions have been greatly improved to match. Why pay for an Oracle license or get your students to use MS Access when PostgreSQL 7.3 will do the job? Lastly, Postgres 7.3 will be great for power users. With functions that can return record sets and prepared queries, more and more enterprises will see PostgreSQL as a viable backend for their operation. I haven't even scratched the surface of what's new in 7.3 and why everyone should be excited! As always, each new version of PostgreSQL is faster, more secure and more stable than ever before. That's why I love PostgreSQL! Chris ----- Original Message ----- From: "Bruce Momjian" <pgman@candle.pha.pa.us> To: "PostgreSQL-general" <pgsql-general@postgresql.org>; "PostgreSQL-development" <pgsql-hackers@postgresql.org> Sent: Tuesday, November 26, 2002 3:20 PM Subject: [HACKERS] Request from eWeek for 7.3 comments > 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.
I am the maintainer and lead developer for Bricolage, an enterprise-class open-source content management system built on a PostgreSQL database. The Bricolage developers really look forward to 7.3's new features, which, like every release of PostgreSQL, set a new standard against which other databases measure themselves. 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 david@wheeler.net ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e Jabber: Theory@jabber.org 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 > pgman@candle.pha.pa.us | (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 > majordomo@postgresql.org) > >
Hello, Command Prompt, Inc. looks forward to the open source release of PostgreSQL 7.3 as we are testing our commercial version of Mammoth PostgreSQL 7.3. The updated release of the core PostgreSQL code base has added many of the much needed, and left behind feature such as drop column. The new features, coupled with the additional features added by Mammoth PostgreSQL such as pre-forked connections, stream level compression and Mammoth LXP (the PostgreSQL Application server), PostgreSQL is set to take center stage from products such as MySQL for delivering enterprise class applications to the database market. Sincerely, Joshua D. Drake Co-Founder Command Prompt, Inc. Co-Author Practical PostgreSQL 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. > > >