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
MySQL v5
Moderators: gto, cipto_kh, EgonHugeist, mdaems
-
mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
Hi John,
Indeed, it would have been better to have the full support for all this stuff. If we only had the time and experience to do it.
That's why I wrote 'basic'. The features ZEOSlib provides for other databases should now also be available for mysql 5. Unfortunately not more, but also not less. I think that's also the main difference between the two products. ZEOS = simple and quite database independent. PDO = everything targeted on the Mysql database. Do you think we can manage to get the two closer together again?
Mark
Indeed, it would have been better to have the full support for all this stuff. If we only had the time and experience to do it.
That's why I wrote 'basic'. The features ZEOSlib provides for other databases should now also be available for mysql 5. Unfortunately not more, but also not less. I think that's also the main difference between the two products. ZEOS = simple and quite database independent. PDO = everything targeted on the Mysql database. Do you think we can manage to get the two closer together again?
Mark
zippo: if by palette, you are talking about installed components then the answer is yes because PDO is not available as a component. It's just a unit that you include with your program. If you download PDO you will see some sample programs written in delphi and Free Pascal, so it should be clear how it's used.
mdaems: the statement "PDO = targeted at Mysql Database" is not true. It's written generically with just the need for specific database drivers just like Zeos. What's true at the moment is that there is only one set of drivers: Mysql 4.0, 4.1, and 5.0. If I have time after my commerical project winds down, I may write drivers for postgresql and sqlite if nobody else has already done it. As far as getting them back together, that's not really possible. They share much of the database drivers, that's about all that really links the two now.
Firmos promised that if I published my work you guys would review my mysql 5.0 code and I was hoping that the project would be advertised a bit so people could use it and find any bugs. So far, only one bug has been found by someone else not me. So either it's rock solid, or only two people are using it. There is a notice over at lazarus / free pascal so at least the FPC people know there is another option.
mdaems: the statement "PDO = targeted at Mysql Database" is not true. It's written generically with just the need for specific database drivers just like Zeos. What's true at the moment is that there is only one set of drivers: Mysql 4.0, 4.1, and 5.0. If I have time after my commerical project winds down, I may write drivers for postgresql and sqlite if nobody else has already done it. As far as getting them back together, that's not really possible. They share much of the database drivers, that's about all that really links the two now.
Firmos promised that if I published my work you guys would review my mysql 5.0 code and I was hoping that the project would be advertised a bit so people could use it and find any bugs. So far, only one bug has been found by someone else not me. So either it's rock solid, or only two people are using it. There is a notice over at lazarus / free pascal so at least the FPC people know there is another option.