[oclug]features of PostgreSQL

[Timothy Brier]

You can use stored procedures from JDBC / ODBC and other connections.
They are called functions in PostgreSQL and they work great.

We use them from delphi / coldfusionmx / php.  We use SQL Server a lot
but our project has convinced us that it will be used a lot less.

We are currenlty using v7.3.1 of PostgreSQL.

Tim.

-----Original Message-----
From: oclug-admin at lists.oclug.on.ca
[mailto:oclug-admin at lists.oclug.on.ca] On Behalf Of Olaf Baumann
Sent: Thursday, January 02, 2003 8:17 PM
To: oclug
Subject: [oclug]features of PostgreSQL


Hi,

  I've got a great opportunity for introducing more open-source tools at
work.  We already have a linux box serving as a CVS repository and a
test environment (yay for us! :-).

  A new project we are undertaking is in need of a database.  We have
narrowed it down to two choices: PostgreSQL or SQL Server.  Currently
the deployment is app and DB on linux or app on linux and DB on windows,
the danger of using SQL Server is that once the DB is running on
windows, the app would probably follow to that platform.

  One feature that is in question for PostgreSQL is stored procedures. 
>From the PostgreSQL documentation, I see that it provides this feature
(but called server-side functions).

  My questions are:

Can we create stored procedures and make use of them through JDBC? 

Can the stored procedures contain transactions and support roll-back? 

Are there any compelling reasons for choosing PostgreSQL over SQL Server
(other than cost or Freedom--neither of which are big concerns for the
decision makers...at least, not yet)?

  Please pardon me if I'm using improper terms, I'm not really a DB guru
by any stretch of the imagination.

thanks,
Olaf


_______________________________________________
oclug mailing list
oclug at lists.oclug.on.ca http://www.oclug.on.ca/mailman/listinfo/oclug