interbase v postgresql

From: Richard Hayward <richard(at)tortoise(dot)demon(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: interbase v postgresql
Date: 2001-10-11 12:22:02
Message-ID: ac3bstoasv17u11hnvd434q7re6lv8c2pd@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have an application on MSSQL and am wanting rewrite it using open
source software.

What would people here consider the strengths and weaknesses of these
two?

The things I need are:

Salability to hundreds of concurrent users.

Stored procedures. This seems to rule out mySQL. Which product has the
fullest procedure language?

I want two types of interface. Access via a browser or via client
software applications.

For web based access, I envisage using perl. Which product has the
most stable modules to connect to perl?

My client apps are written in Delphi. Although I've yet to get serious
with it, I think I can use IB objects to produce thin-client delphi
apps talking to Interbase, needing little to be installed on the
client machines. With postgresql I think I have to use ODBC. Any
reasons why one is better than the other?

For clients connecting across the Internet, traffic would have to be
encrypted. Could I achieve this with either product?

With MSSQL I really like the Trace utility. I can watch the SQL
commands as they arrive at the server. I understand from an earlier
post that this isn't possible with Interbase/Firebird. Can I do that
with postgresql?

Does anyone have opinions on this?
There is a bit of information on the project itself at www.openi.org.

regards
Richard

also posted to borland.public.interbase.general
richard(at)tortoise(dot)demon(dot)co(dot)uk

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alessio Bragadini 2001-10-11 12:49:18 Another episode of the regular MySql-PostgreSQL war on Slashdot
Previous Message Lincoln Yeoh 2001-10-11 10:04:33 Multiple postgresql installations on one machine.