Page 1 of 1

MySQL Classes

Posted: Mon May 14, 2007 7:02 am
by Grim...
Does anyone have any recommendations for a nice simple MySQL class?
Searching for this reveals about ten billion matches, and none of them seem to be about the class itself.

Posted: Mon May 14, 2007 7:51 am
by Oren
d11wtq wrote one while back... viewtopic.php?t=52479

Posted: Mon May 14, 2007 8:14 am
by Grim...
Did that not have some speed issues with large resultsets?

Posted: Mon May 14, 2007 8:38 am
by Maugrim_The_Reaper
It did - it was using mysql_seek() which slowed things down. Not sure if an updated copy with fixes applied was ever posted. Finding a simple class is probably worse than the proverbial needle in a haystack though ;). The closest I've ever bothered with is a mysql PDO adapter which returns ArrayObjects and relies almost completely on prepared statements. Haven't bothered digging any further - there are any number of Abstraction libraries. Maybe you could grab their adapters or something for standalone use?

Posted: Mon May 14, 2007 9:29 am
by Oren
Grim... wrote:Did that not have some speed issues with large resultsets?
I don't know. I never tested/used this class nor did I read the code :P

Posted: Mon May 14, 2007 9:39 am
by Chris Corbyn
It was seeking forward needlessly. Someone posted the fix for it though. I personally don't use this class now.

Posted: Mon May 14, 2007 11:08 am
by RobertGonzalez
Can you use ADODBlite, or something of that type?

Posted: Mon May 14, 2007 12:42 pm
by AKA Panama Jack
You could use my ADODB Lite class. It supports a number of different database types. It really is quite small and very fast compared to most other dtabase classes.