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
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. |