Re: Package support for Postgres - Mailing list pgsql-hackers

From Jean-Michel POURE
Subject Re: Package support for Postgres
Date
Msg-id 4.2.0.58.20011020115438.0165d2c0@pop.freesurf.fr
Whole thread Raw
In response to Re: Package support for Postgres  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
>I think Jean-Michael's comments were right. While I'm not sure if things
>will be as overwhelming as he predicted, packages (even as implimented in
>my patch) will help people develop code libraries for PostgreSQL. And that
>will make PostgreSQL applications easier.

PostgreSQL is a fantastic tool which lacks a few features to become #1. 
IMHO, these features are :> Beginners: ability to drop and reorganize columns. I know this sounds 
stupid for hackers, but this is #1 need when migrating from beginner tools 
such as MySQL or Access. Candidates?> Advanced users: PACKAGE support to create and distribute software 
libraries. CREATE OR REPLACE VIEW, CREATE OR REPLACE TRIGGER, etc... 
PL/pgSQL installation by default with infinite loop protection.> Professionnal user: PostgreSQL does not lack many
things.Maybe 
 
server-side Java would be great in terms of object/inheritence approach. I 
run several databases, one being hosted on a double Pentium Linux box with 
U2W discs. When using triggers, views, rules and PL/pgSQL, applications can 
be optimized so much that you "hardly" reach the hardware limits.> Power users: load balancing, replication,
tablespace.I can't really say.
 

I first discovered PostgreSQL when localizing Oracle8i to French. We asked 
Oracle if I could use their software to help us during the translation 
process. They answered "OK, but you have to pay $xx.xxx because you have a 
double processor box". This was about twice the price we were getting paid. 
That day, I understood Oracle did not care about its users and was only 
interested in fast, short term profit.

Cheers,
Jean-Michel


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Compiling on Solaris with Sun compiler
Next
From: Jean-Michel POURE
Date:
Subject: Re: Packages are needed