Arthur Hoogervorst schrieb:
Hi,
The company I work for actually uses the Zeos lib/Postgres extensively to track the shipping and sales side for almost 3 years.
We're still running on a 7.2/7.4 Postgres database, because I haven't been convinced yet to either update or upgrade to 8.x.x. I'm curious if others have successfully moved their (production) database successfully to Postgres 8.0.
Regards,
Arthur
On 5/9/05, Philippe Lang <philippe.lang@xxxxxxxxxxxxxx> wrote:
Hi,
I'm testing Delphi 2005 at the moment, with ZEOS Lib (libpq), and I have to say it work fine, as Tony mentioned. I have a few questions:
1) I'm curious: are there a lot of big projects using ZEOS with PG or is that technology still relatively new? I would like to use it a replacement for ODBC, but I have no experience regarding its stability.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hy,
we use zeos too but the older version because of we found many problems in 6.X - Versions. I have fixes up many bugs in zeos 5.4 so it now works fine with postgres. All in all i have to say Zeos works but i'm not really happy with zeos because it seems not clear for if ut has a future.
What versions of Zeoslib do you use? Do you use lo with zeos?
With Zeos 6.X you cannot use Postgresql - search path because 6.X Versions always wrote schema name before table name. 6.X does not support Cursor Fetch.
Components are very inefficient, every time you open a table all configuration / table meta data is fetched. No internal caching or sth like this.
Fields with unknown length are mapped wrong.
and so on-
Has anyone here tried Delphi dbexpress with www.vitavoom.com - dbexpress driver?
Has anyone tried .net - pgsql - driver with Delphi 2005?
All in all my opinion is that there is no really good solution to access Postgres from Delphi.
Are here many Delphi - Developers? Perhaps we should start a project at pgfoundry "PostgreSQL - Access for Delphi". I spend very much time to fix up Zeos-lib. So perhaps we can share.
(Last week i fixes a bug with "--" comment style for example; that style of comments wasnt accepted because ZeosLib deleted all #10#13 and so everything was a single line -> everything after "--" was a comment for PG)
Daniel.
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
