The issues mentioned with Zeos have been fixed, the 6.x branch works very well now and it much faster
thant the 5.x versions.
I use cursors all the time in my functions and return a refcursor which I then fetch.
The latest version of PostgresDAC from microolap also works good, I tried there 1.x stuff but it was designed for PG
7.2
and had no support at all for schemas.
Zeos does seem to be going no where.
I for one would not object to starting something new that just targeted Postgresql and worked with all features
i.e. like canceling a query and asynchronous queries.
The best bet would to just fork Zeos and pull out what is needed, no need to start totally from scratch.
Does anyone have experience writing Tdataset decendents?
The .net driver does work well, but ADO.net does not support always connected sessions, it works in a offline mode
exactly
like tclientdataset.
Even with these small problems I still would never do a GUI database app with C# or Java when I can do it much faster
and
easier with Delphi.
> 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. 6.X isn't speacially for postgres, they try to
> support all bigger databases.
>>
> 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.
>
> Perhaps we should start a project at pgfoundry "PostgreSQL - Access
> for Delphi".
>
--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql 8.x
http://www.amsoftwaredesign.com