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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
