Release of Zeos 8.0.0

[marsupilami79]

The Zeos Team is proud to announce the availability of Zeos 8.0.0 as a stable release. This is the newest stable version of Zeos. It deprecates Zeos 7.2, and any previous version of Zeos. We urge all people still using older versions of Zeos to upgrade. If you have any problems with Zeos 8.0, please get in contact with us on the forums or on the bugtracker.

The most outstanding changes in Zeos 8.0 are

• Support for Delphi NextGen compilers to support Android, iOS and Mac OS X
• Two new bridge drivers for OleDB and ODBC
• A new driver that uses the Firebird interface based API for accessing Firebird versions 2.5 and above
• A special proxy server and an according driver that can be used to access any Zeos supported database using SOAP over HTTP(S) from (mobile) clients.
• Propper support for numeic and decimal fields by using TBCDField and TFMTBCDField
• Nested transactions using savepoints
• Two new components: TZTransaction and TZMemTable
• better overall performance and smaller memory footprint

Besides these improvements Zeos has seen a ton of other additions and improvements. For an overview of the changes in Zeos 8.0 see the release notes.

To download, the new version of Zeos please use this link.

[dseligo]

Nice

When will it be available in the OPM?

[silvestre]

Good news and great components for multiple database access. Thank you very much for your efforts for the community.

The Zeos Team is proud to announce the availability of Zeos 8.0.0 as a stable release. This is the newest stable version of Zeos. It deprecates Zeos 7.2, and any previous version of Zeos. We urge all people still using older versions of Zeos to upgrade. If you have any problems with Zeos 8.0, please get in contact with us on the forums or on the bugtracker.
.../quote]

[paweld]

Thank you.   
But latest FPC 3.2.3 (fixes) support ftSingle.   
in file ZeosLazarus.inc should be (lines 158-166)

Code: Pascal  [Select][+][-]

1.                 {$IF FPC_FULLVERSION>=30203}
2.                   {$DEFINE WITH_FTLONGWORD}                 // ftLongWord is supported
3.                   {$DEFINE WITH_FTBYTE}                     // ftByte is supported
4.                   {$DEFINE WITH_FTEXTENDED}                 // ftExtended is supported
5.                   {$DEFINE WITH_FTSINGLE}                   // ftSingle is supported
6.                   {$IF FPC_FULLVERSION >= 30300}
7.                   {$DEFINE WITH_FTSHORTINT}                 // ftShortInt is supported
8.                   {$IFEND}
9.                 {$IFEND}

[jujibo]

Thank you.   
But latest FPC 3.2.3 (fixes) support ftSingle.   
in file ZeosLazarus.inc should be (lines 158-166)

Code: Pascal  [Select][+][-]

1.                 {$IF FPC_FULLVERSION>=30203}
2.                   {$DEFINE WITH_FTLONGWORD}                 // ftLongWord is supported
3.                   {$DEFINE WITH_FTBYTE}                     // ftByte is supported
4.                   {$DEFINE WITH_FTEXTENDED}                 // ftExtended is supported
5.                   {$DEFINE WITH_FTSINGLE}                   // ftSingle is supported
6.                   {$IF FPC_FULLVERSION >= 30300}
7.                   {$DEFINE WITH_FTSHORTINT}                 // ftShortInt is supported
8.                   {$IFEND}
9.                 {$IFEND}

It's reported:

https://sourceforge.net/p/zeoslib/tickets/588/

[marsupilami79]

Hell jujibo and paweld,

Thank you.   
But latest FPC 3.2.3 (fixes) support ftSingle.   
in file ZeosLazarus.inc should be (lines 158-166)

Code: Pascal  [Select][+][-]

1.                 {$IF FPC_FULLVERSION>=30203}
2.                   {$DEFINE WITH_FTLONGWORD}                 // ftLongWord is supported
3.                   {$DEFINE WITH_FTBYTE}                     // ftByte is supported
4.                   {$DEFINE WITH_FTEXTENDED}                 // ftExtended is supported
5.                   {$DEFINE WITH_FTSINGLE}                   // ftSingle is supported
6.                   {$IF FPC_FULLVERSION >= 30300}
7.                   {$DEFINE WITH_FTSHORTINT}                 // ftShortInt is supported
8.                   {$IFEND}
9.                 {$IFEND}

The fixes_3_2 branch of FPC isn't supported by Zeos stable versions. If you want to use a moving target please use the Zeos 8.0-fixes branch as a minimum. I added a fix for the ftSingle-problem there.

Best regards,

Jan

[paweld]

@jujibo - Thank you
@marsupilami79 - From the file it looks like it is supported, because all I did was move define FTSINGLE from version 30300 to 30203 (2 lines above)

[marcov]

(afaik fixes also supports shortint, but maybe only since last December. Nearly all database fixes were merged then, and as far as database goes, current fixes state will probably be 3.2.4 as there are only a handful of unmerged fixes: (most related to dotted unit names, which won't be merged)
http://www.stack.nl/~marcov/mergelogs32/fcl-db.html


)

[jujibo]

Hell jujibo and paweld,

Do you mean "Hello" 

The fixes_3_2 branch of FPC isn't supported by Zeos stable versions. If you want to use a moving target please use the Zeos 8.0-fixes branch as a minimum. I added a fix for the ftSingle-problem there.

Best regards,

Jan

Thanks

[marsupilami79]

Hello

Do you mean "Hello" 

Yes - I meant exactly that

(afaik fixes also supports shortint, but maybe only since last December. Nearly all database fixes were merged then, and as far as database goes, current fixes state will probably be 3.2.4 as there are only a handful of unmerged fixes: (most related to dotted unit names, which won't be merged)
http://www.stack.nl/~marcov/mergelogs32/fcl-db.html

Yes - that was the reason. We just don't do tests with the fixes branch on a regular basis, so we didn't see the problem. Once FPC 3.2.4 is released (i hope, that will be soon), we will check what needs to be done and release an updated version of Zeos.

When will it be available in the OPM?

I requested the inclusion of Zeos 8 in OPM some minutes ago. But in most cases the upgrade will require additional work because there are incompatibilities between Zeos 7.2 and Zeos 8.

[marcov]

I requested the inclusion of Zeos 8 in OPM some minutes ago. But in most cases the upgrade will require additional work because there are incompatibilities between Zeos 7.2 and Zeos 8.

Is there a list of that somewhere? 

I have to migrate a postgresql server to a newer distro before June, and that means a postgresql version update. Better update the app too, to latest and greatest.

[dseligo]

I requested the inclusion of Zeos 8 in OPM some minutes ago. But in most cases the upgrade will require additional work because there are incompatibilities between Zeos 7.2 and Zeos 8.

Great.

Is there some document with changes between 7.2 and 8 or are there plans to make (to ease transition between the two versions)?

[marsupilami79]

Basically the list of (big) changes is in the release notes.

When it comes to incompatibilities, the following come to my mind:

• We removed the AutoEncodeStrings property from TZConnection. This will lead to problems when loading DFM / LFM files that were made with Zeos 7.2. There is a switch in the zeos.inc, that recreates a property with that name but the property has no meaning for Zeos 8. It is only there, so old DFM / LFM files can be loaded.
• If you have persistent fields (fields stored in DFM/LFM files) there almost certainly will be problems. Zeos 8 now supports TZBCDField and TFMTBCDField. Numeric and Decimal columns will be mapped to these fields now and not to TFloadField anymore. Also other field type assignments may have changed. There is a changed field type assignment for MySQL boolean fields. See to the release notes for that.
• Zeos now uses its own Param type TZParam instead of TParam by default. That probably will lead to problems when type casting and when storing Params in LFM/DFM files. There is a define (in ZClasses?) that allows to distinguish between Zeos 8 and older Zeos versions in the ZClasses unit, I think.
• Some MySQL options have been renamed. That also is described in the release notes
  

This list isn't final. There may be other problems too.

Another announcement: OPM will now distribute Zeos 8 instead of Zeos 7.2

[marcov]

Thanks for the heads up. I use a lot of persistent fields to control the grid layout, but only one as a float field it seems, which symbolises hours spent on a project.

[BSaidus]

Hi @all.
Thank you @marsupilami79 for your effort on zeos components.
I wonder if this release support DEFACTO the encryption on SQLITE database.
I mean the use of https://github.com/utelle/SQLite3MultipleCiphers.
On the 7.2.14 I remember, I did some modification on the code driver for SQLITE.

Thank you.