Just wanted to brainstorm regarding a table wizard/mongodb possible integration
We've entered the mobile scene pretty strong and we're thinking of having something lighter then drupal services on the server side (Drupal performs a full drupal bootstrap for each service call).
This might be ok in a low traffic application but could never suite a mmorpg or a facebook application.
My idea is to use node.js as the server and mongodb as the storage and then export the mongodb data to drupal.
Now what I imagined was a tablewizard plugin or stroage engine (or whatever the right terminology for that would be) that would effectively take a mongodb set and export it to views.
Is this area been researched? I know the ex nowpublish (chx and the gang) have been going mongo and that chuck form Acquia has gone in the same route.
I wonder if there is a way to have views support for a mongo based data set.
Has anybody researched or implemented anything in this direction, Does an integration with tablewizard even make sense or is the binding to mysql to strong here?
Any help would be appriciated as I plan this out...
Lior
Comments
Definitely talk to chx about
Definitely talk to chx about this. He probably knows MongoDB better than anyone else in the Drupalverse at the moment, and I know he's really excited about seeing MongoDB be a viable - if not the primary - database for Drupal 7. Are you familiar with using IRC? Stop by the channels sometime - you can often catch him there.
The Boise Drupal Guy!
Sure it is possible. Views3
Sure it is possible.
Views3 has a pluggable query backend. You could even query from memcache, but i think it's not so practical :)
Here is some basic code:
http://drupalcode.org/viewvc/drupal/contributions/sandbox/chx/mongodb_vi...
Afaik table wizard always writes into a sql database, perhaps this will be abstracted.
a mongodb views plugin. great
a mongodb views plugin. great for testing.
Hi liorkesos, was just
Hi liorkesos, was just wondering if you ever made any progress on this. I'm currently looking for a similar solution.
subscribe.
subscribe.
Drupal Developer in Beijing
EntityFieldQuery
Best off starting with with http://drupal.org/project/efq_views
This supports EntityFieldQuery + views intregration.
MongoDB module supports EntityFieldQuery.
No mongodb/views-specific code required.
Hey Catch, I know this is a
Hey Catch, I know this is a really late response but I'm back to looking into this. I did try out EntityFieldQuery last year when you mentioned it and I had my fields stored in MongoDB.
But for my use case the data I display in views never needs to be edited in drupal so there's no need to store it as a field. Obviously I could store it as a field for the purpose of querying the data but because this data is for Analytics and we have so much of it this is adding a lot of unneeded overhead.
As a side not I wasn't feeling very comfortable storing all my fields in MongoDB when I really didn't have a need to. Mainly due to any potential overhead in development time due to problems we might run into. It would be great if the MongoDB module allowed you to just store certain fields in MongoDB.
efq with calendar
Hi,
EntityFieldQuery ( http://drupal.org/project/efq_views ) helped a lot. But I need to implement calendar with mongodb fields. Any suggestion?