Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #8744

Re: PDO based Abstraction Layer for MySQL with Caching

Show all headers | View raw

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.

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

PDO based Abstraction Layer for MySQL with Caching CPHR <ryan@cloudpresshosting.com> - 2013-03-19 15:56 -0700
  Re: PDO based Abstraction Layer for MySQL with Caching "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2013-03-20 00:32 +0100
  Re: PDO based Abstraction Layer for MySQL with Caching The Natural Philosopher <tnp@invalid.invalid> - 2013-03-19 23:49 +0000
    Re: PDO based Abstraction Layer for MySQL with Caching Axel Schwenke <axel.schwenke@gmx.de> - 2013-03-20 09:51 +0100

csiph-web