Future Moodle releases - Any plans for NoSQL / Bigtable?

Future Moodle releases - Any plans for NoSQL / Bigtable?

by Lawrence N -
Number of replies: 8

Are there any plans in the future to rework Moodle to use/implement NOSQL databases?

 

Average of ratings: -
In reply to Lawrence N

Re: Future Moodle releases - Any plans for NoSQL / Bigtable?

by Dan Marsden -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Plugins guardians Picture of Testers Picture of Translators

I haven't heard of anyone planning this but Moodle relies pretty heavily on the use of SQL - so it would be quite a significant task... can you give any examples of large open-source software packages that support both SQL and NoSQL databases on the back end? (I'd be interested to see how they manage it)


..of course many of Moodles db calls are abstracted into functions that could be handled by a nosql driver like get_records/update_record/insert_record calls - but the more complex areas that use sql like enrolments/roles/reports all make heavy use of SQL that may not be easily portable to NoSQL

Average of ratings: -
In reply to Lawrence N

Re: Future Moodle releases - Any plans for NoSQL / Bigtable?

by Mark Johnson -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

I'm interested for the reason behind your question, do you have something specific in mind that would require a NoSQL database?

As Dan describes, NoSQL databases aren't just drop-in replacements for SQL databases, so it wouldn't just be a case of writing a new database abstraction - they're different beasts with different applications.

Average of ratings: -
In reply to Mark Johnson

Re: Future Moodle releases - Any plans for NoSQL / Bigtable?

by John Reese -

Nothing specific. I just thought that it may be a good idea to at least think about it as these big tables would eventually be the norm one of these days.

Average of ratings: -
In reply to John Reese

Re: Future Moodle releases - Any plans for NoSQL / Bigtable?

by Rex Lorenzo -

Maybe as a possible place to store log files? After a couple of million rows the mdl_log table gets cumbersome. We actually prune out log table every so often, but would like to keep it to do some statistics.

Maybe having the ability to have the logs be sent to a log server would be better. NoSQL and Bigtable would seem ideal for that case.

Average of ratings: -
In reply to Rex Lorenzo

Re: Future Moodle releases - Any plans for NoSQL / Bigtable?

by Simon Story -

I'm not a massive fan of MySQL, but if you did want to keep mdl_log, perhaps investigate storing it in a MySQL db using the Archive compressed storage engine.

Average of ratings: -