Zeoslib Portal

Hi.
Im using 6.6.5-stable and want to upgrade to lastest stable. I see lastest posted in forum is 6.6.6-stable at dic 2009.
Are there any new patches since then ?
What if i get the svn version at svn://zeos.firmos.at/zeos/6.6-patches/ instead ?

Thanks!

I think the most important parameter for speed is Autocommit. if you set Autocommit := True every insert statement you execute starts its own transaction, so the database need to setup a transaction enviroment for every statement. Setting Autocommit:= False before the bulk insert implies just one tr...

What version of Zeos are you using ?
I was playing with sqlite3 and Zeos 6.6.5 a couple of days ago and i experienced the same with TZQuery. Then i switched and that worked for me.

I'm not sure what you are trying to do, but you can use a TClientDataSet to make a copy in-memory of your dataset.

Hi! I'm trying to use that beta version. i've got found some problems when using the postgres-7 driver and blob fields. Digging into sources i've found in ZPlainPostgresSqlDriver.pas function TZPostgreSQL7PlainDriver.DecodeBYTEA(value: string): string; begin Result:= value; end; it's not decoding no...

maybe this can help:

http://seegernet.koolhost.de/zeosforum/ ... .php?t=298

it removes Required property in columns with default values, then Zeos
uses default values.

I had the same problem on fields with default values. Zeos does not permit a field to be 'nullable' if it's defined as not null. So i did a nasty patch in ZDbcPostgresSqlMetadata, to allow fields with default values (and not null defined) be nullables. ZDbcPostgreSQLMetadata.pas function TZPostgreSQ...

Sorry, i'm answering myself. the 'LIMIT 1' line , does not work in tables without records.
So the problem extends to empty tables in a diferent way.
Any other posible solutions ?

niztor.-

PostgreSQL 7.4.8 Zeos 6.5.1 alpha CVS as of 13/10/2005 My english is terrible, so i'll try to explain this by example. I've got a table defined like CREATE TABLE blah ( nid serial , cod integer , txt char(30) ); 'nid' field is defined as a sequence , now if you insert records with just a dbgrid (and...

First, sorry my english. I've found a bug in zeos's handling of bytea blob fields. It is double decoding blob fields. zeosdbo-6.5.1-alpha_cvs_13-10-2005.zip ZDbcPostgresSqlResultSet.pas: scope function TZPostgreSQLResultSet.GetBlob(ColumnIndex: Integer): IZBlob; var BlobOid: Oid; Stream: TStream; be...