MySQL Classes

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
Grim...
DevNet Resident
Posts: 1445
Joined: Tue May 18, 2004 5:32 am
Location: London, UK

MySQL Classes

Post 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.
User avatar
Oren
DevNet Resident
Posts: 1640
Joined: Fri Apr 07, 2006 5:13 am
Location: Israel

Post by Oren »

d11wtq wrote one while back... viewtopic.php?t=52479
Grim...
DevNet Resident
Posts: 1445
Joined: Tue May 18, 2004 5:32 am
Location: London, UK

Post by Grim... »

Did that not have some speed issues with large resultsets?
User avatar
Maugrim_The_Reaper
DevNet Master
Posts: 2704
Joined: Tue Nov 02, 2004 5:43 am
Location: Ireland

Post 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?
User avatar
Oren
DevNet Resident
Posts: 1640
Joined: Fri Apr 07, 2006 5:13 am
Location: Israel

Post 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
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

It was seeking forward needlessly. Someone posted the fix for it though. I personally don't use this class now.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Can you use ADODBlite, or something of that type?
User avatar
AKA Panama Jack
Forum Regular
Posts: 878
Joined: Mon Nov 14, 2005 4:21 pm

Post 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.
Post Reply