MongoDB seems to be a really good option.

But I haven’t seen any more complex example, with use of embedded objects or relationships with that datasource.

Somebody has tried ?

Thank you for using and explaining MongoDB Datasource.
Now, I release ver0.2

Properties of each model become little simple. primaryKey(_id) is automatically set. using mongSchema property insted of _schema.
You don’t need to set “var $useTable = false;” if there is no collection(Table).

Here is new sample model for ver0.2

class Note extends AppModel {
    var $name = 'Note';
    var $useDbConfig = 'mongo';
	var $mongoSchema = array(
            'title' => array('type' => 'string'),
            'body' => array('type' => 'text'),
            'numbered' => array('type' => 'integer'),
        );

}

Sebastien: While MongoDB doesn’t support associations or joins out of the box, you could emulate them at the datasource level.

Ichikaway: Awesome, looks like a nice set of improvements :D

Hi,

I am using Cake 1.2.6 and have some difficulty using ver0.2 when using $mongoScheme, it looks like cake does not interpret column type integer properly when inserting new records.

I tried to insert record with integer values, but when I query back using mongo console (db.mytable.find()), the supposed-to-be-integer value is display as string

I traced the Cake model.php source, and at line 1034, there is $this->scheme() call, which I believe there should be a function schema() inside the model as posted in this page

I am new to Cake framework, but I like to use mongoDB for my application. can someone help out.

thanks

Hi again,
please ignore my previous comment.

Now it seems that cakephp does not typecast well the integer format. so the question is, how to properly insert integer (or float) values to mongoDB from cakephp, currently, all are inserted as string values

One thing I feel is not mentioned clearly about the Mongo DSO is that is DOES support deep document hierarchies (= nested arrays) and not only the simple datatypes listed in the source code (string, integer…).

It looks to me like any “datatype” can be an array and the schema will be ignored (i.e. not treated as a string or something). For clarity one can apparently even just set the datatype to array just for clarity.

I did not see this mentioned anywhere in your post or in the docs for the dso. For me and my purposes that is a big deal and no mention of it meant no support in my mind. I am very happy I created a model and ran some tests though. :)

thanks for the tutorial Mark.

what about apache cassandra ( http://cassandra.apache.org/ )?

I fail to understand the advantages of using a NoSQL database with CakePHP. In any case, one does not use the SQL syntax directly, since the interaction with the database is hidden behind the CakePHP layer. So, what does this change?

MongoDB looks pretty much amazing! It’s time to get my hand dirty.

Nice work from Yasushi Ichikaway.

I have two questions:

Which is the best way to store images, movies in MongoDB? Write a own Datasource (for Gridfs) or extend the MDS?

And can i specify in the mongoschema types like MongoBinData?

thanks in advance

The update method of the datasource is in error here.
Instead of upgrading, it inserts a new record.

Can not connect to servers with user and password

@Rafael: Make sure you have echo $form->hidden(’_id’); in your edit/update form.

Hello.

I`ve little problem. I tried many times to connect mongodb datasource with cakephp. But only what i get is this: ConnectionManager::loadDataSource – Unable to import DataSource class mongodb.mongodbSource [CORE\cake_1.3\cake\libs\model\connection_manager.php, line 185]

mongodb_source.php datasource I insert in app/models/datasources/. Where is the problem?

@Artis – You need to clone the repository into your plugins directory

It has to look like:

cakephp/app/plugins/mongodb/models/datasources/mongodb_source.php

I see the ensureIndex() method defined on the MongodbSource class. But how do I call/use it?
Thank you.

I really love the MongoDB and with cake it’s looks quite more beatifull now =). I hope cakephp will have native nosql drivers in next releases (and with auto schemes like sql maybe).

For now this driver looks awesome, thanks for all efforts.

PS: Cake Bake ignores “plugin” datasources. I never inspect bake mechanism just noticed and saying in addition.
PHP Fatal error: Class ‘Mongo’ not found in /cake/1.3/cake/libs/model/connection_manager.php on line 114

Thanks.

I always have wanted to define my schema in my model exactly like this does. And I secretly always wanted to use Mongo anyway!

Matt