Pdo Mysql driver

96 views
Skip to first unread message

oc666

unread,
Dec 28, 2009, 6:24:43 PM12/28/09
to Joomla! CMS Development
I just ended develop pdo_mysql driver based on the original mysql
driver. I started with pdo mysql because of its convenience with the
original mysql. The next step would be develop the other pdo drivers
(mssql, oracle, postgresql, etc). I started to develop with pdo
because it's native php driver for many DBs with few differences in
the code.

Here is the driver code (pre-alpha release. be careful if you going to
use):
http://joomla.libnet.co.il/libraries/joomla/database/database/pdo_mysql.php.txt

I got an error that say (running on Joomla 1.6 alpha): "Infinite loop
detected in JError"
I don't why, but I switched on the the log and here it is:
http://joomla.libnet.co.il/index.php

Sam Moffatt

unread,
Dec 29, 2009, 4:06:30 AM12/29/09
to joomla-...@googlegroups.com
Just having a quick browse through, when you have the select you
basically make that a nop - PDO doesn't have the ability to change
database?
Same comments for ping, PDO doesn't have an equivalent?

Sam Moffatt
http://pasamio.id.au

> --
>
> You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
> To post to this group, send an email to joomla-...@googlegroups.com.
> To unsubscribe from this group, send email to joomla-dev-cm...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/joomla-dev-cms?hl=en-GB.
>
>
>

Cohen Ofer

unread,
Dec 29, 2009, 11:40:17 AM12/29/09
to joomla-...@googlegroups.com
My friend, Google, told me that we could implement pdo mysql ping
function like that:
http://terenceyim.wordpress.com/2009/01/09/adding-ping-function-to-pdo/
"My friend" didn't find any clue about select function. I think the
function is not available because of the modularity of the driver.
Those two functions aren't part of JDatabase abstract. Where those
functions are used?

Cohen Ofer

29/12/2009 11:06, Quote Sam Moffatt:

Sam Moffatt

unread,
Dec 29, 2009, 6:51:08 PM12/29/09
to joomla-dev-cms
Not quite sure where ping is used, it would be for a long running
script that periodically ensures their database connection is still
available (perhaps something we could build in, checking if the SQL
server disappeared error and then pinging the connection to see if PHP
can reconnect it). Select is something I've used in third party code
to switch databases on a secondary connection for items within the
same instance but it is something you could probably work around not
having.

Sam Moffatt
http://pasamio.id.au

Cohen Ofer

unread,
Dec 29, 2009, 8:11:03 PM12/29/09
to joomla-...@googlegroups.com
Is the select function needed by the Joomla core?

Cohen Ofer

ב-30/12/2009, בשעה 01:51, Sam Moffatt <pas...@gmail.com> כתב/
ה:

Sam Moffatt

unread,
Dec 29, 2009, 10:12:24 PM12/29/09
to joomla-dev-cms
I'm not entirely sure, I think we use it in the database adapter
connection function but nowhere else in core uses it I believe.

Sam Moffatt
http://pasamio.id.au

Reply all
Reply to author
Forward
0 new messages