FUDforum: comp.lang.php » PDO based Abstraction Layer for MySQL with Caching

Home » Imported messages » comp.lang.php » PDO based Abstraction Layer for MySQL with Caching

Show: Today's Messages :: Polls :: Message Navigator

Re: PDO based Abstraction Layer for MySQL with Caching [message #180808 is a reply to message #180807]

Tue, 19 March 2013 23:32

M. Strobel
Messages: 386
Registered: December 2011

Karma:

Senior Member

Am 19.03.2013 23:56, schrieb CPHR:
> I am curious if anyone here can recommend a good abstraction layer for MySQL preferably PDO based. Something that has good caching that's automatic, for example I run the query and it will check to see if it has a cached result before attempting to do the query. I have been using EZ SQL but the caching leaves a lot to be desired and it uses the old mysql_* functions of PHP which are going to be depreciated.
>

It might not help you much if all you want is a caching abstraction layer, but it
must be said:

Anybody in need of general database caching is probably doing something wrong:
selections are done in code, and joins are done in code, while they should be done in
the database.

This is sadly true for many frameworks as far as I can tell. The result are scaling
problems.

Your application specific abstraction is easily done with ~ 10 functions in a PDO
derived class.

And an application specific cache for objects is quite trivial, for example
$order->getCustomer() or $invoice->getDebitor() can easily look up the cache by
[$classname][$id], and give you one (1) object.

/Str.

Report message to a moderator

[Message index]

		PDO based Abstraction Layer for MySQL with Caching By: CPHR on Tue, 19 March 2013 22:56
		Re: PDO based Abstraction Layer for MySQL with Caching By: M. Strobel on Tue, 19 March 2013 23:32
		Re: PDO based Abstraction Layer for MySQL with Caching By: The Natural Philosoph on Tue, 19 March 2013 23:49
		Re: PDO based Abstraction Layer for MySQL with Caching By: Axel Schwenke on Wed, 20 March 2013 08:51

Previous Topic:	split array and string from string (trust me it will make sense when you read)
Next Topic:	APC issues: locking up all processes and lack of PHP 5.4 support

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 05:16:52 GMT 2024

Total time taken to generate the page: 0.05398 seconds