interbase v postgresql
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@tortoise.demon.co.uk
I can't address the issues you list here; but the
following may matter to you:
Interbase can import fixed-width text files, but not
delimited files.
Since I'm importing and remodelling data from
delimited files on a regular basis, this issue was
important to me. Converting delimited files to
fixed-width is not how I want to spend my time.
Best of luck,
Andrew
--- Richard Hayward <richard@tortoise.demon.co.uk>
wrote: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
Richardalso posted to borland.public.interbase.general
richard@tortoise.demon.co.uk---------------------------(end of
broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org
__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com