Future Moodle releases - Any plans for NoSQL / Bigtable?

Future Moodle releases - Any plans for NoSQL / Bigtable?

Lawrence N -
回帖数:8

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

 

回复Lawrence N

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

Dan Marsden -
Core developers的头像 Particularly helpful Moodlers的头像 Peer reviewers的头像 Plugin developers的头像 Plugins guardians的头像 Testers的头像 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

回复Lawrence N

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

Mark Johnson -
Core developers的头像 Particularly helpful Moodlers的头像 Peer reviewers的头像 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.

回复Mark Johnson

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

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.

回复John Reese

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

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.

回复Rex Lorenzo

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

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.