Search found 19 matches

by jrmarino
30.05.2006, 11:18
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Does anyone successfully connect mysql5 with kylix ?
Replies: 6
Views: 1238

Jotiwoken, I use mysql 5.0 commercially with Delphi and Free Pascal. Zeos didn't and still doesn't support Mysql 4.1 or 5.0 natively, plus you can see some of this date issues. For this, using zeos as a starting base, I completely created a new API, closely based on PHP's Data Objects API. It suppor...
by jrmarino
28.04.2006, 07:38
Forum: Feature Requests
Topic: MySQL v5
Replies: 18
Views: 6842

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...
by jrmarino
16.04.2006, 16:41
Forum: Feature Requests
Topic: MySQL v5
Replies: 18
Views: 6842

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...
by jrmarino
04.04.2006, 08:27
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4455

Thanks, I'll take a look and likely update via subversion.


added: Okay, I made your suggested changes verbatim, and now they are available as revision 8. Thanks again for the feedback.
by jrmarino
31.03.2006, 14:00
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4455

The zeos-derivative Pascal Data Objects ( http://seegernet.koolhost.de/zeosforum/viewtopic.php?p=1714#1714 ) doesn't suffer from this internal slowness. It uses only the mysql native calls, meaning it can return the entire rowset and the number of rows in the result set (as opposed to leaving on the...
by jrmarino
12.03.2006, 21:14
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: I built Native Mysql 4.1/5.0 driver in PDO wrapper
Replies: 11
Views: 2495

PDO has been delivered, ready to go

Helmut, Ok, it's done. I have spent most of the weekend fully documenting the interface on a Trac wiki. When you see the contents of the wiki, you will understand. The new home of "Pascal Data Objects" is https://trac.synsport.com:8000/index.php/pdo/wiki Unfortunately you have to get throu...
by jrmarino
10.03.2006, 08:52
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: I built Native Mysql 4.1/5.0 driver in PDO wrapper
Replies: 11
Views: 2495

Helmut, that was a great tip! Since my last post, I was successful in compiling and executing PDO on FreeBSD, so I went to bed happy (I'm in the same timezone as you here in Holland). However, the executable was a whopping 1226kb. After running "strip" on it, the executable reduced to 571k...
by jrmarino
09.03.2006, 21:54
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: I built Native Mysql 4.1/5.0 driver in PDO wrapper
Replies: 11
Views: 2495

I have my own SVN server, so that's not necessary, thanks. I'm not quite ready to check anything in because I'm still testing it, especially with FPC. I just got it compiling without errors or warnings, and its running under FPC 2.0.2 (finally!). I hate how big the FPC executables are, about 5x the ...
by jrmarino
09.03.2006, 11:05
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: I built Native Mysql 4.1/5.0 driver in PDO wrapper
Replies: 11
Views: 2495

Thanks, I just discovered on my own about the range checking trick, (FPC Bug 4510). Developers attempted fix in early january, but it's not been worked on since, very frustrating. Wasted several more hours on that last night, but I'm on track to get this working for FPC. I think you can definitely b...
by jrmarino
08.03.2006, 17:28
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: I built Native Mysql 4.1/5.0 driver in PDO wrapper
Replies: 11
Views: 2495

The code has been working very well, and I'm very productive using it. I'm still shaking out some minor things, but I've already used it extensively with great success. I'm also in the process of testing it with FPC. That didn't go well last night, unfortunately. I found what I think is a bug in FPC...
by jrmarino
07.03.2006, 21:56
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: MySQL 5
Replies: 7
Views: 2499

I solved this problem, but I had to build my own mysql 5.0 driver, and in doing so, ended up building a whole new wrapper. http://seegernet.koolhost.de/zeosforum/viewtopic.php?t=397 Regardless of what is said above, mysql 4.0, 4.1, and 5.0 all need separate DLL's. The DLL's provided with zeos are ol...
by jrmarino
01.02.2006, 16:32
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: I built Native Mysql 4.1/5.0 driver in PDO wrapper
Replies: 11
Views: 2495

I built Native Mysql 4.1/5.0 driver in PDO wrapper

I choose to upgrade my production server from MySQL 4.0 to MySQL 4.1 specifically because I needed prepared statements now, and maybe subqueries in the future, so I was none too pleased to discover than Zeos 6.5.1 uses emulated prepared statements for MySQL 4.1. Worse, when I dug into the 4.1 driver...
by jrmarino
10.01.2006, 18:54
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: CVS Builds
Replies: 4
Views: 1600

I also think this library has untapped potential and would like to see it progress (at least to the point that I can get it installed!)

anyway, nov/dec are generally slow months due to traditional holidays -- I expect that's the main reason.
by jrmarino
07.01.2006, 15:47
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: zeosdbo from cvs, lazarus and fpc
Replies: 36
Views: 11255

Okay, here's the update.

I removed the entire CVS repository and reinstalled zeros_rework branch. I then applied the patch.

I got the same exact error page that I posted before. I'm not sure why this isn't working for me, because I'm following all the instructions
by jrmarino
07.01.2006, 15:33
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: zeosdbo from cvs, lazarus and fpc
Replies: 36
Views: 11255

I work with Subversion, this is the first CVS project I've every used. Does the CVS client (CVSTortoise) not get the latest files automatically? I assumed if I "update repository" I automatically get the latest files. I not, I'm glad my own projects are on subversion, because CVS seems ter...