Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Alternative databases with WP

Alternative databases with WP

Alternative databases with WP

To start this forum and shamelessly blow my own trumpet, I have written an abstraction layer for the WP database layer that allows the use of PDO (thus improving security) and thus any PDO supported database provided that you have the right 'drivers'.  I have also written a 'driver' for sqlite.  My blog at rathercurious.net has been operating on sqlite for nearly a year now.  

This main benefits for this extension are
  • simply to allow WP users more flexibility in their choice of database.
  • Choosing sqlite makes you WP installation extremely portable: just copy the whole tree from one place to another.  
  • Similarly database backups are as simple as downloading the sqlite file.
  • For me, as well, my host allows 1GB of data but only 100MB of mysql tables.  they do not limit sqlite tables however.  
  • you can run a full function blog off a router+NAS box.  these typically don't have the oomph to run mysql but a lighthttp + sqlite installation runs just fine.
the second big conceptual benefit that i can see is that the work done inside the extension can be taken and easily made into a generic conversion class for mysql -> sqlite queries.  So if you, as a developer, want to offer both types of database as a choice to your users, you no longer have to write two sets of queries - 99% likely that all your needs will be met by running mysql queries through the conversion class.  Alternatively you could code in sqlite and all you'd need to do would be to tweak the create statements ... but don't get me started on my anti-mysql rant!

anyway, there are 600+ users of the extension out there, so i'm relatively comfortable that it works ok.  there are bugs and one biggie has been picked up and i'll be posting a revised version at wp.org soon. In this next version I will also be:
  • moving the sqlite driver architecture from regex to UDF's (better performance in php5)
  • rearchitecting the overall structure to look and feel more like a plugin (automatic upgrades etc)
  • (finally) writing a solution to cope with schema changes so that it will work with dbdelta() (WP's database upgrade function).
You can find the package here

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close