Database FAQ: Difference between revisions
From MoodleDocs
Frank Ralf (talk | contribs) (→XMLDB) |
Frank Ralf (talk | contribs) |
||
Line 14: | Line 14: | ||
== b) Moodle database == | == b) Moodle database == | ||
See | See | ||
* [[Development:Database Schema]] - The files available here are in [http://fabforce.net/dbdesigner4/ DBDesigner 4] format. DBDesigner 4 is a schema drawing program for MySQL data bases released under GPL. | * [[Development:Database Schema]] - The files available here are in [http://fabforce.net/dbdesigner4/ DBDesigner 4] format. DBDesigner 4 is a schema drawing program for MySQL data bases released under GPL. | ||
* [[Development:Database schema introduction]] | * [[Development:Database schema introduction]] |
Revision as of 10:18, 28 May 2009
Note: This article is a work in progress. Please use the page comments or an appropriate moodle.org forum for any recommendations/suggestions for improvement.
Databases and Moodle
When talking about Moodle and databases there are actually two different kind of things which can be meant:
- a) The Moodle activity named Database
- b) The database on your server where Moodle stores all its content
a) Database module (activity)
See
b) Moodle database
See
- Development:Database Schema - The files available here are in DBDesigner 4 format. DBDesigner 4 is a schema drawing program for MySQL data bases released under GPL.
- Development:Database schema introduction
- Create Moodle site database
- "Database abstraction layers and Moodle" from Christopher Douce's blog (Open University)
- "Moodle database design issues I'd like to tackle/see tackled" in the Moodle forum (from 2007).
XMLDB
XMLDB stores the database definition in an XML format that can be used to install Moodle on any database.
- Development:XMLDB Documentation
- Development:XMLDB defining an XML structure#The XMLDB editor
- Development:Database
- XMLDB editor
- Category:XMLDB
Different kinds of databases
- MySQL
- MSSQL, see Installing MSSQL for PHP
- Oracle, see Installing Oracle for PHP
- PostgreSQL
New database layer in Moodle 2.0
- See Development:DB_layer_2.0.
- For new features in Moodle 2.0 see Development:Coding#Database.