Re: interbase v postgresql

From: Andrew Gould <andrewgould(at)yahoo(dot)com>
To: Richard Hayward <richard(at)tortoise(dot)demon(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org
Subject: Re: interbase v postgresql
Date: 2001-10-15 17:14:58
Message-ID: 20011015171458.34032.qmail@web13408.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)tortoise(dot)demon(dot)co(dot)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
> Richard
>
> also posted to borland.public.interbase.general
> richard(at)tortoise(dot)demon(dot)co(dot)uk
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo(at)postgresql(dot)org

__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John P. Looney 2001-10-15 17:29:08 Re: Embedded postgres ?
Previous Message Barry Lind 2001-10-15 16:37:41 Re: JDBC question: Which class is returned?