Are there any plans in the future to rework Moodle to use/implement NOSQL databases?
Som svar til Lawrence N
Re: Future Moodle releases - Any plans for NoSQL / Bigtable?
av Dan Marsden -
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
Som svar til Dan Marsden
Re: Future Moodle releases - Any plans for NoSQL / Bigtable?
av Juho Viitasalo -
I think Drupal can take advantage on NoSQL.
http://drupal.stackexchange.com/questions/991/nosql-vs-other-sql-drupal-setups
Som svar til Lawrence N
Re: Future Moodle releases - Any plans for NoSQL / Bigtable?
av Mark Johnson -
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.
Som svar til Mark Johnson
Re: Future Moodle releases - Any plans for NoSQL / Bigtable?
av 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.
Som svar til John Reese
Re: Future Moodle releases - Any plans for NoSQL / Bigtable?
av 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.
Som svar til Rex Lorenzo
Re: Future Moodle releases - Any plans for NoSQL / Bigtable?
av 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.
Som svar til Lawrence N
Re: Future Moodle releases - Any plans for NoSQL / Bigtable?
av sam marshall -
Som svar til sam marshall
Re: Future Moodle releases - Any plans for NoSQL / Bigtable?
av Dan Marsden -
Awesome!