Object storage and retrieval in PHP part 2 - MongoDb

This post was written 6 years ago.
Mon, 12 Sep 2011
In part one, I talked about how to save and retrieve a PHP object instance using JSON files, and in this post I talk about the same operation using mongoDb, and some gotchas.

I've only tried this in very limited circumstances, mainly to see how feasible it would be to make eatStatic seamlessly switch between json files and mongo - I naively thought that you would just throw a json file at mongo and have it store it for you, but the examples i've found takes the php object and converts to JSON magically, and also passes back a PHP object instance rather than raw JSON.

This post doesn't cover installing mongo, I skipped between several different examples/ tutorials before I got it working, so can't remember exactly how I did it in the end. Once installed though you can connect to it from PHP like this:-

$m = new Mongo(); // connect
$db = $m->cms; // select a database

For comparison purposes we'll create a simple case study object like in Part 1:-

class case_study {
var $id;
var $title;
var $body_text;
var $skills = array();
}

$case_study = new case_study;

$case_study->id = 'my/case_study';
$case_study->title = 'My case study';
$case_study->body_text = 'Some text for the case study';
$case_study->skills['css'] = 'CSS';
$case_study->skills['sitebuild'] = 'Site Build';

which gives us:-

case_study Object
(
[id] => my/case_study
[title] => My case study
[body_text] => Some text for the case study
[skills] => Array
(
[css] => CSS
[sitebuild] => Site Build
)

)

To store this in mongo db, we simply specify a collection to use ("collection" is analogous to table in a relational database, but you can create them on demand, and don't have to specify a schema) and them insert our object:-

$case_studies = $db->case_studies;
$case_studies->insert($case_study);

To get it back we use:-

$case_study = $case_studies->findOne(array('id' => 'my/case_study'));

Passing this to print_r() gives us:-

Array
(
[_id] => MongoId Object
(
[$id] => 4e6de720d2db288b0c000000
)

[id] => my/case_study
[title] => My case study
[body_text] => Some text for the case study
[skills] => Array
(
[css] => CSS
[sitebuild] => Site Build
)

)

Note a couple of things:-

  • It has given us back an Array, instead of an object
  • It has inserted it's own unique ID [_id]

We don't need to worry about the extra ID, as we'll be using our own for lookups, so it can be ignored. To convert the array to an object, simply do:-

$case_study = (object) $case_study;

Which takes us back to:-

stdClass Object
(
[_id] => MongoId Object
(
[$id] => 4e6de720d2db288b0c000000
)

[id] => my/case_study
[title] => My case study
[body_text] => Some text for the case study
[skills] => Array
(
[css] => CSS
[sitebuild] => Site Build
)

)
This post was written 6 years ago, which in internet time is really, really old. This means that what is written above, and the links contained within, may now be obsolete, inaccurate or wildly out of context, so please bear that in mind :)
Tags: php / mongodb / eatStatic /
Strict Standards: Only variables should be passed by reference in /home/rickhurst/sites/rickblog.eatstatic/lib/eatStatic/eatStaticBlog.class.php on line 595 Strict Standards: Only variables should be passed by reference in /home/rickhurst/sites/rickblog.eatstatic/lib/eatStatic/eatStaticBlog.class.php on line 595 Strict Standards: Only variables should be passed by reference in /home/rickhurst/sites/rickblog.eatstatic/lib/eatStatic/eatStaticBlog.class.php on line 595 Strict Standards: Only variables should be passed by reference in /home/rickhurst/sites/rickblog.eatstatic/lib/eatStatic/eatStaticBlog.class.php on line 595 Strict Standards: Only variables should be passed by reference in /home/rickhurst/sites/rickblog.eatstatic/lib/eatStatic/eatStaticBlog.class.php on line 595 Strict Standards: Only variables should be passed by reference in /home/rickhurst/sites/rickblog.eatstatic/lib/eatStatic/eatStaticBlog.class.php on line 595

Introducing eatStatic blog engine

This post was written 6 years ago.
Sun, 04 Sep 2011
creating a new blog post in textmate
Recently I ported this blog from an ancient version of wordpress to my own simple blog engine, which uses my PHP5 micro-framework, "eatStatic". I use the phrase "blog engine" rather than blog software, as it isn't really packaged up yet as something I would describe as software - its more just a collection of classes and templates that can be used to keep a blog.

The bulk of the code was written last year in the space of a couple of hours while sitting in a garage waiting for my car to be fixed - I was about to go on a long road trip and wanted a blogging solution that let me create blog posts and organise photos offline and then conveniently sync it to the live site when I had an internet connection. The result was my "on the road" blog about mobile working.

The thing that sets this apart from other blog engines (and the origin of the name "eatStatic", along with a nod to a 90's techno act), is that instead of using a relational database to store content, it uses simple text files for blog posts, and cached json files to store collections of data (e.g. post lists, tag references etc.). I have it set up to run with dropbox so that I compose my posts in textmate and they are synced to a dropbox folder on the webserver. You don't have to use dropbox though - you can use any technique you like to upload the data files to the server - for "on the road" I use subversion, which means I also have versioning of blog content. Draft posts are composed in a drafts folder and moved into the main posts folder to push them live. There is currently no admin area on the site, though I might add one later.

The published date and URI for each post are taken from the text file name - i've adapted it for this blog to use the same url scheme as wordpress to avoid link rot on legacy content. Some people asked me why I don't just use the title and created/ modified date of the text file to make it even simpler, and the answer is that I wanted finer control, and the option to specify the publish date - using created/ modified would have been a disaster for the content I imported from wordpress. Also by naming each file starting with YYYY-MM-DD, the post files are easier to sort/ find in the post folder, both visually/ manually and in code. You can use HTML in the blog post and additionally line breaks are converted to br tags, other then immediately after a closing tag. You can add tags and metadata at the end of the text file.

I've also got a simple thumbnail gallery which can be included in a post (see below) by uploading a folder full of full-size images with the same name as the post. The idea behind this is that a set of jpeg/ png images can be imported from a camera, and automatically pushed to the server by dropbox. A caching script creates the thumbnails and web-size version on demand, which are saved to the filesystem for efficiency during subsequent requests. I considered setting it up so that each post had it's own folder, which could then contain images, but the blog engine was mostly written with the idea of quickly creating posts by opening textmate/ emacs, writing and saving rather then faffing around with creating folders.

I made the decision not to build in any commenting functionality - the anti-spam / moderation features needed are too much of a pain to deal with, so i've archived the old wordpress comments into the post body and integrated disqus instead.

As I mentioned before, I've been using a previous version of eatStatic successfully for my "on the road" blog, but I wanted to see how it coped with 100's of posts rather then just a handful - it seems to be doing fine, coping with over 600 posts, but i'm sure there is room for improvement. I've also been investigating making the json read/write switchable to use mongodb so that it could potentially be very scaleable - i've encountered a few inconsistencies in the way that PHP json_decode() and mongodb object retrieval work, but nothing that can't be worked around - expect a blog post on that later!

I don't expect eatStatic blog to be a wordpress killer, but it may appeal to techie types who want a lightweight PHP5 blog engine, maybe to plug into an existing site and people who want to compose posts in textmate/ emacs (or any other code editor), rather than in a web form. If you are interested in trying it, keep an eye on the github repo, as i'll commit an example of how this blog is formed, once i've ironed out the more embarrassing bugs! I may add a simple admin area at a later date, to allow publishing entirely via the web, and I think it would also benefit from a "post by email" feature, for convenient moblogging, but don't hold your breath!

When I was importing content (I actually wrote a python script to parse a wordpress xml export file and create the text files), I found it quite fitting that the first ever post on this blog nearly ten years ago was made on a home-brewed ASP blog engine which used XML for data storage. I think before then I kept a static HTML blog of sorts, on a freeserve site, but unfortunately haven't got a copy of that for completeness.

Lastly, whether or not you want to set up an eatStatic-based blog, if you aren't already using dropbox, it really is excellent, so why not sign up for free 2GB account using my referral URL, so I can get some more free space? Even though I have a paid dropbox account, I use a second free account to mount on my server for automated site/ database backups and for this blog and it keeps filling up!
This post was written 6 years ago, which in internet time is really, really old. This means that what is written above, and the links contained within, may now be obsolete, inaccurate or wildly out of context, so please bear that in mind :)