PDO (SQLite) Plugin for Wordpress - Rating, Reviews, Demo & Download
Plugin Description
Wordpress has for a long time, and for good reasons, been locked into using mysql as its database storage engine. There is a good discussion of ‘why’ in the codex
But this design choice has ramifications; not least because mysql’s implementation of sql is not standard. Even with the use of the EZSQL abstraction layer bundled with Wordpress, this makes plugging in other databases very difficult.
PDO For Wordpress is a step towards eliminating this difficulty. Think about this ‘plugin’ in four steps:
- the basic layer takes all queries and separates out the variables from the language. It replaces each variable with a placeholder as well as stripping mysql specific ‘nasties’ like the slash-escaping and backticks.
- then a language specific driver steps in and rewrites the query to use its own native constructs or (in the case of SQLite) pushes the query into some special user-defined functions
- the basic layer then puts it all back together and runs the query, finally …
- returning the whole thing to the EZSQL abstraction layer so that Wordpress doesn’t know that anything has gone awry
See below/other notes for details of known limitations
Screenshots
There are no screenshots