Database FAQ: Difference between revisions
From MoodleDocs
Frank Ralf (talk | contribs) |
Frank Ralf (talk | contribs) |
||
Line 18: | Line 18: | ||
* [[Create Moodle site database]] | * [[Create Moodle site database]] | ||
* [http://learn.open.ac.uk/mod/oublog/viewpost.php?post=5741 "Database abstraction layers and Moodle"] from Christopher Douce's blog (Open University) | * [http://learn.open.ac.uk/mod/oublog/viewpost.php?post=5741 "Database abstraction layers and Moodle"] from Christopher Douce's blog (Open University) | ||
* [http://moodle.org/mod/forum/discuss.php?d=65072 Moodle database design issues I'd like to tackle/see tackled] in the Moodle forum. | |||
== XMLDB == | == XMLDB == |
Revision as of 10:11, 23 April 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:
- the Moodle activity named Database
- the database on your server where Moodle stores all its content
Database module (activity)
See
Moodle database
- Development:Database Schema - The files available here are in DBDesigner4 format. DBDesigner4 is a schema drawing program 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.
XMLDB
XMLDB stores the database definition in an XML format that can be used to install Moodle on any database.
Different kinds of databases
- MySQL
- MSSQL, see Installing MSSQL for PHP
- Oracle, see Installing Oracle for PHP
- PostgreSQL