Posted: 16.04.2006, 16:41
I think your definition of "support" and mine are different. When I think of Mysql v5 support, I think of native implementation of prepared procedures, stored procedures, multiple returned rowsets, and triggers. The last time I checked, zeoslib did not support any of that. Yes, you can get basic select and insert statements to work, but not what I would call support of MySQL 5.
That's the reason I was forced to create my own drivers for MySQL 4.1 and 5.0, so that I could take advantages of the database features using Delphi or Free Pascal.
I really think anyone starting a new project specifically targeting Mysql 4.1 or 5.0 and doesn't require other databases (because the drivers don't exist at the moment) should check out Pascal Data Objects (user=guest, password=guest). I wrote it using Zeoslib as a base, but every replaced almost everything. If you follow that link, you'll see full documentation on the API. There is a downloadable zip (r5), but the svn version is more recent (r8). It's LGPL licensed like zeos, and I'm committed to maintaining it from a bug point of view because I'm using it in my own commercial projects, so I will respond quickly to bug reports. PDO supports natively prepared statements, stored procedures, multiple rowsets, column binding, parameter binding, and more.
I'm not trying to hijack zeoslib, I hope the developers continue to improve it. The zeos project has been stagnant, so while they are reviving it, users that specifically require Delphi/Free Pascal and modern MySQL should know there are other options.
John
That's the reason I was forced to create my own drivers for MySQL 4.1 and 5.0, so that I could take advantages of the database features using Delphi or Free Pascal.
I really think anyone starting a new project specifically targeting Mysql 4.1 or 5.0 and doesn't require other databases (because the drivers don't exist at the moment) should check out Pascal Data Objects (user=guest, password=guest). I wrote it using Zeoslib as a base, but every replaced almost everything. If you follow that link, you'll see full documentation on the API. There is a downloadable zip (r5), but the svn version is more recent (r8). It's LGPL licensed like zeos, and I'm committed to maintaining it from a bug point of view because I'm using it in my own commercial projects, so I will respond quickly to bug reports. PDO supports natively prepared statements, stored procedures, multiple rowsets, column binding, parameter binding, and more.
I'm not trying to hijack zeoslib, I hope the developers continue to improve it. The zeos project has been stagnant, so while they are reviving it, users that specifically require Delphi/Free Pascal and modern MySQL should know there are other options.
John