Small MongoDB Notes - Revision history

Admin: /* Installation - Ubuntu */

2014-03-05T14:39:57Z

‎Installation - Ubuntu

Admin: /* Installation - Ubuntu */

2014-01-28T14:34:26Z

‎Installation - Ubuntu

Admin at 09:05, 27 January 2014

2014-01-27T09:05:20Z

Admin at 15:49, 1 April 2013

2013-04-01T15:49:38Z

Admin: Created page with "The PHP's PECL driver provides a very neat and clean integration. Databases and collections within are accessed directly as if members of the (client) connection:

// host de..."

2013-04-01T15:40:18Z

Created page with "The PHP's PECL driver provides a very neat and clean integration. Databases and collections within are accessed directly as if members of the (client) connection: <pre>// host de..."

New page

The PHP's PECL driver provides a very neat and clean integration. Databases and collections within are accessed directly as if members of the (client) connection:
<pre>// host defaults to 'localhost', port defaults to 27017:
$client = new MongoClient(["host[:port]"]);
// access database directly - replace 'database' with DB's name:
$client->database
// as well as collection within the database:
$client->database->collection
// now lets find some documents in the collection:
$client->database->collection->find([query]);
// find() returns iterator, so just foreach through it:
foreach ($client->database->collection->find([query]) as $id => $doc)
; // do your best here...</pre>
If you need only one document (or know that there is - at most - one), you can use <tt>findOne()</tt> function that returns the document directly.

@@ Line 7: / Line 7: @@
 $ sudo apt-get update
 $ sudo apt-get install mongodb-10gen
-$ sudo apt-get install php-pear            # if you don't have PECL yet
+$ sudo apt-get install php-pear php5-dev   # if you don't have PECL yet; phpize is also needed
 $ sudo pecl install mongo                  # PECL will echo what to add to php.ini;
                                             # you can add this to both CLI and in-Apache PHP using

@@ Line 8: / Line 8: @@
 $ sudo apt-get install mongodb-10gen
 $ sudo apt-get install php-pear            # if you don't have PECL yet
-$ sudo pecl install mongo                  # PECL will echo what to add to php.ini
+$ sudo pecl install mongo                  # PECL will echo what to add to php.ini;
-$ sudo vim /etc/php5/apache2/php.ini
+                                           # you can add this to both CLI and in-Apache PHP using
 $ sudo service apache2 restart             # restart apache to reload php settings</pre>

← Older revision		Revision as of 09:05, 27 January 2014
Line 1:		Line 1:
		+	== Installation - Ubuntu ==
		+
		+	[http://www.mongodb.com/ MongoDB Inc.] provides PPA source for Ubuntu. PECL provides native PHP driver.
		+
		+	<pre>$ sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 7F0CEB10
		+	$ echo 'deb http://downloads-distro.mongodb.org/repo/ubuntu-upstart dist 10gen' \| sudo tee /etc/apt/sources.list.d/mongodb.list
		+	$ sudo apt-get update
		+	$ sudo apt-get install mongodb-10gen
		+	$ sudo apt-get install php-pear # if you don't have PECL yet
		+	$ sudo pecl install mongo # PECL will echo what to add to php.ini
		+	$ sudo vim /etc/php5/apache2/php.ini
		+	$ sudo service apache2 restart # restart apache to reload php settings</pre>
		+
		+	== Troubles on Desktop ==
		+
		+	While it behaves well on servers, MongoDB has some peculiarities on desktop machines.
		+
		+	Here's a typical day in the desktop MongoDB user's life:
		+
		+	<pre># check it's running
		+	$ ps aux \| grep mongod
		+
		+	0 S user 22154 28201 0 80 0 - 1097 pipe_w 16:31 pts/9 00:00:00 grep mongod
		+
		+	# not running, eh?... lets try manually... beware that mongo
		+	# can't find its own config files on desktop machines...
		+	$ sudo mongod --config /etc/mongodb.conf
		+
		+	all output going to: /var/log/mongodb/mongodb.log
		+
		+	# did it die? if not, you're lucky and you're ready to roll!...
		+	# otherwise, lets rock... log will most probably tell you that you
		+	# need to repair db because of unclean shutdown
		+	$ sudo mongod --config /etc/mongodb.conf --repair
		+
		+	...
		+
		+	# now we should be able to start mongo
		+	$ sudo mongod --config /etc/mongodb.conf</pre>
		+
		+	And now you should have mongo running (and one terminal stuck with mongo... but who cares, it's not the olden days, where you had just one).
		+
		+	== Using in PHP ==
		+
	The PHP's PECL driver provides a very neat and clean integration. Databases and collections within are accessed directly as if members of the (client) connection:		The PHP's PECL driver provides a very neat and clean integration. Databases and collections within are accessed directly as if members of the (client) connection:
	<pre>// host defaults to 'localhost', port defaults to 27017:		<pre>// host defaults to 'localhost', port defaults to 27017:

← Older revision		Revision as of 15:49, 1 April 2013
Line 12:		Line 12:
	; // do your best here...</pre>		; // do your best here...</pre>
	If you need only one document (or know that there is - at most - one), you can use <tt>findOne()</tt> function that returns the document directly.		If you need only one document (or know that there is - at most - one), you can use <tt>findOne()</tt> function that returns the document directly.
		+
		+	Some more useful functions:
		+	<pre>// make sure 'field' is indexed:
		+	$client->database->collection->ensureIndex('field');
		+	// get some information about the query:
		+	$client->database->collection->find([query])->explain();</pre>