I want to use postresql for this app, but...

From: Derek Shaw <derek(at)bisi(dot)ca>
To: pgsql-odbc <pgsql-odbc(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: I want to use postresql for this app, but...
Date: 2004-02-05 19:33:47
Message-ID: 40229A9B.1070304@bisi.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general pgsql-odbc

I am working with a window-manufacturing firm (the real thing!). One of
the reasons we are about to choose one of the vertical-market
applications is that they claim ODBC compliance, and "Using other ODBC
compliant database engines should not present a problem but may require
some additional testing..." This is in stark contrast to all the other
vendors who require MSSQL on the back end (or an AS400), and the usual
windoziness about why you'd want to do anything else.

When I asked about using PostgreSQL this is the reply I received:
----
I discussed PostureSQL with Paul and his technical director sent me the
following comment:
/ PostgreSQL// is open source and so far they have not agreed on a blob
field properly we use blob fields for the item bitmap, old conservatory
data and meta files for graphics. An ODBC driver is available and
describes how to fudge a blob field but it says that it does not clean
them up properly when updating. I suggest moving to MySQL which
is also open source ??///
They estimate about one day additional time to make necessary changes
and to test for MySQL. Let me know what you think.
----
These folks develop using MSAccess and MSSQL.

Can anyone shed any light on how serious this problem is, and whether it
is ever likely to be resolved so that I could use PostgreSQL?

TIA!

PS - the vertical market software is Caliburn v8 at
http://www.caliburn-software.com/

--
Derek Shaw
BIS Business Information Systems Inc.
Victoria, BC.
voice: 250-885-2021 fax: 250-386-4060
PGP Public Key ID: 0xD3783198

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Mark Harrison 2004-02-05 23:09:36 Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
Previous Message Shridhar Daithankar 2004-02-05 12:15:38 Fwd: Re: [LIH]Bank / Financial Institutes Using Linux

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Lebedev 2004-02-05 19:34:24 Re: dblink: rollback transaction
Previous Message mallah 2004-02-05 19:30:51 Re: Functions in CHECK constraint not getting dumped before

Browse pgsql-odbc by date

  From Date Subject
Next Message Paul Thomas 2004-02-06 11:27:05 Re: I want to use postresql for this app, but...
Previous Message Jon Willeke 2004-02-04 23:41:35 experimental Watcom support