Moving to PostGres
Hello,
I am looking at moving our company away from MS SQL. Have been looking at
DB2 and it looks to have some good features. Now wondering if POSTGRESQL
could be a viable alternative. I have a few questions though;
1. What is the postgresql equiv to Stored procedures and can they be written
in another langauage such s JAVA?
2. How well is JAva supported for developing DB applications using PG?
3. What are the limitations to PG compared to DB2, Oracle, Sybase ?
Thanks
Ben
In article <XU5o9.11017$vg.28049@news-server.bigpond.net.au>,
Benjamin Stewart <bstewart@NOSPAM.waterwerks.com.au> wrote:
I am looking at moving our company away from MS SQL.
Here's a good place to start:
http://techdocs.postgresql.org/redir.php?link=/techdocs/sqlserver2pgsql.php
"Benjamin Stewart" <bstewart@NOSPAM.waterwerks.com.au> writes:
1. What is the postgresql equiv to Stored procedures and can they be written
in another langauage such s JAVA?
PostgreSQL supports user-defined functions; in 7.3 (currently in beta)
they can return sets of tuples.
You can define functions in Java using http://pljava.sf.net , or in a
variety of other languages (Perl, Python, Tcl, Ruby, C, PL/PgSQL, SQL,
sh, etc.)
2. How well is JAva supported for developing DB applications using
PG?
"Pretty well", I guess. If you have a specific question, ask it.
Cheers,
Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC