Thread: Request from eWeek for 7.3 comments

Request from eWeek for 7.3 comments

From
Bruce Momjian
Date:
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

Re: Request from eWeek for 7.3 comments

From
"Christopher Kings-Lynne"
Date:
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.



Re: Request from eWeek for 7.3 comments

From
David Wheeler
Date:
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)
>
>


Re: [GENERAL] Request from eWeek for 7.3 comments

From
"Joshua D. Drake"
Date:
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.
>
>
>