SimpleDB

Shortly before I moved all of my new development work to Django I was struggling to find something that I felt comfortable with as I was working in the PHP world. I found that the database access was mostly frustrating, repetitive and slow.

This project didn't expand beyond a prototype stage but shows good promise for something that can give PHP developer easy access to query their databases. The current prototype only supports mySQL databases.

The general API for querying a database showed the most progress. For example a simple call on a table people to get all records would be as simple as this;

$simple_db = new SimpleDB("username", "password", "host");
$simple_db->people->all()

No other code is required other than the inclusion of the SimpleDB code base. The idea here was to move away from writing repetitive SQL all the time. The prototype has some very strict limitations but would be interesting to develop further for those looking for a simple PHP query class. Initial work was also done with inserting and updating with a similar API however it was not completed.