Zeoslib Portal

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R3000:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Mark, Michael,
Maybe to publish 7.2.0-alpha (or something else)?

Michal

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R3007:
http://svn.code.sf.net/p/zeoslib/code-0 ... esting-7.2/
compiles and runs on (I have tested):

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Michal

@EgonHugeist,

Zeos7.2-alpha branches_ testing_R3011:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Michael,
With {$DEFINE NO_COLUMN_LIMIT} up to 4% slower and 4% greater memory occupancy compared to R3007 (DXE2 32/64, FB, SQLite)

Michal

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R3012:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Michal

@miab3

With {$DEFINE NO_COLUMN_LIMIT} up to 4% slower and 4% greater memory occupancy compared to R3007 (DXE2 32/64, FB, SQLite)

Thanks for your info. I was playing with that today. 4% greater mem isn't a surprice since a PTypeInfo, PTDynRecInfo will be added by RTL. Also did i compare the the mem-alloction with the current TZRowBuffer. I was starting from the premisse we allocate the whole mem of the array, that was wrong. We really only alloc mem for the Header-Info + Mem we need to localize the Values. We could declare the TZRowBuffer to High(Integer)-SizeOf(Header) and wouldn't use more mem.
Actually i'm adding arrays for the types which are moved outside the RowBuffer: string, dynarrays, lobs to get a faster dealloction running too. So this patch was ... a little idea which should be hance with comments or removed..

Also 4% performnce lost might be possible because of the additional RTL calls to create the PTypeInfo: New(); and _DynArraySetLength call of the RTL. Cool i hadn't the time to make benchamrks. Thank you!

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R3014:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Mark,
[Pascal Hint] ZDbcPostgreSqlStatement.pas(365): H2077 Value assigned to 'TZPostgreSQLStatement.Execute' never used

Michal

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R3016:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Mark,
[Pascal Hint] ZDbcPostgreSqlStatement.pas(365): H2077 Value assigned to 'TZPostgreSQLStatement.Execute' never used

Michal

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R3018:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Michal

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R3021:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Michal

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R3022:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D2006,
- DXE2 32/64 -> C++(32),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Michal

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R3025:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D2006,
- DXE2 32/64 -> C++(32),
- Lazarus 32-bits Windows7-64 /fpc 2.7.1 32-bits (CodeTyphon ver 4.50) (64-bit Win version of Lazarus with ZEOS I was unable to build),

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Michal

@EgonHugeist, @mdaems,

A summary:

Zeos7.1.2-patched_R2996(last fixes):
http://svn.code.sf.net/p/zeoslib/code-0 ... 1-patches/
compiles and runs on (I have tested):

- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus 32/64 on Windows7-64 (CodeTyphon ver 4.40, 4.50 and 4.60 with i386_cgcpu.pas.patch: http://bugs.freepascal.org/view.php?id=25269)

I think you can publish ZEOS 7.1.3-stable.

Zeos7.2-alpha branches_ testing_R3025:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D2006,
- DXE2 32/64 -> C++(32),
- Lazarus 32-bit on Windows7-64(CodeTyphon ver 4.50)

I was unable to build 64-bit Win version of CodeTyphon 4.50 with ZEOS 7.2 and
32/64-bit Win version of CodeTyphon 4.60 with ZEOS 7.2 even with i386_cgcpu.pas.patch.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Merry Christmas and a happy New Year!

Michal

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R3026:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D2006,
- DXE2 32/64 -> C++(32),
- Lazarus 32-bit on Windows7-64(CodeTyphon ver 4.60 with i386_cgcpu.pas.patch: http://bugs.freepascal.org/view.php?id=25269
and after exclusion: exsortzeos, RxSortZeos and RegisterUnit('RxSortZeos', @RxSortZeos.Register); from pl_RX )
I was unable to build 64-bit Win version of CodeTyphon 4.60 with ZEOS 7.2.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Michal

@Miab3 and all others

I was unable to build 64-bit Win version of CodeTyphon 4.60 with ZEOS 7.2.

I know there is something weired i actually can't see. This did happen after adding unit ZFastCode.. AFAIK. Not sure if it would change something if i move all code to ZSysUtils.pas...

We wish a mery christmas and a happy new year too!

@EgonHugeist, @mdaems

Clarified

1.
Zeos7.1-patched_R2996(last fixes):
http://svn.code.sf.net/p/zeoslib/code-0 ... 1-patches/
compiles and runs on (I have tested):

- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus 32/64 on Windows7-64 (CodeTyphon ver 4.40, 4.50 and (4.60 with i386_cgcpu.pas.patch: http://bugs.freepascal.org/view.php?id=25269))

Mark don't you think the version 7.1.3-stable is past due?

2.
Zeos7.2-alpha branches_ testing_R3026:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D2006,
- DXE2 32/64 -> C++(32),
- Lazarus 32/64 on Windows7-64(CodeTyphon ver 4.60 with i386_cgcpu.pas.patch: http://bugs.freepascal.org/view.php?id=25269)


Solution for CodeTyphon.

I forced to rebuild after ZEOS (I deleted the corresponding lib directories):
\codetyphon\typhon\components\lazreport\
\codetyphon\typhon\components\pl_RX\
They should be rebuilt each time the ZEOS changed

Of course I added core/ZFastCode.pas in package.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Merry Christmas and a happy New Year!

Michal