NoSQL database written in PHP?

Question

Is there some NoSQL solution written in PHP (perhaps NoSQL front end to MySQL or PostgreSQL)? I need to store and search for key/value pairs in my PHP scripts, but I need to run it on webhosing where I cannot to install anything (so CouchDB, MongoDB etc. is not solution for me). I need something that supports somethinq like this:

// select * from things where x=3 and y="foo" 
db.things.find( { x : 3, y : "foo" } ); 

Thanks.

Edit: I am looking for a simple NoSQL (en.wikipedia.org/wiki/NoSQL) document-oriented database (en.wikipedia.org/wiki/Document-oriented_database).

Answer 1

Check out the DBA functions, they may already be compiled in to your PHP.

Edit: Or, given the updated replies in your post, Amazon SimpleDB sounds like it might be a good match. I don't believe there are any external dependencies that need to be installed.

Answer 2

Isn't SQLlite (or SQLlite3 for PHP 5.3+) available ? That would be weird because it's supposed to be enabled by default with PHP 5...

** EDIT **

A suggestion would be to have a normal SQL database (ex: SQLlite, MySQL, etc.) and store your objects in their serialized form.

Something like

$data = new DataClass();
$data->x = 3;
$data->y = 'foo';

$serialized_data = addslashes(serialize($data));
mysql_query("INSERT INTO data_table (x,y,data) VALUES ('{$data->x}', '{$data->y}', '{$serialized_data}')")

//Then To SELECT...

$link = mysql_query("SELECT data FROM data_table WHERE x=3 AND y='foo'");
$row = mysql_fetch_array($link)
$data = unserialize($row['data'])

This way, you can perform query and store virtually any kind of objects. All you need to do is to have specific columns for the values you wish to "index". You could even have a different table for every class for convenience.

Answer 3

FIRST: if you try to use something done in PHP your script's performance will be terrible.

there are few project where you can use something in top of mysql to have a key/value storage

try this and take a look to this great implementation of friendfeed