XMLDB Documentation: Difference between revisions
From MoodleDocs
No edit summary |
Helen Foster (talk | contribs) No edit summary |
||
| (3 intermediate revisions by 3 users not shown) | |||
| Line 3: | Line 3: | ||
XMLDB is Moodle's database abstraction layer -- it is the library of code that lets Moodle interact with and access the database. | XMLDB is Moodle's database abstraction layer -- it is the library of code that lets Moodle interact with and access the database. | ||
In this page you will find links to all the XMLDB-related documentation | In this page you will find links to all the XMLDB-related documentation. | ||
=== Introduction === | === Introduction === | ||
| Line 14: | Line 14: | ||
* [[:en:Installing MSSQL for PHP|Installing MSSQL for PHP]]: One short manual about the steps needed to successfully add MSSQL support to PHP. | * [[:en:Installing MSSQL for PHP|Installing MSSQL for PHP]]: One short manual about the steps needed to successfully add MSSQL support to PHP. | ||
* [[:en:Installing Moodle|Installing Moodle]]: The guide to install Moodle (once you have the [[:en:Installing AMP|AMP platform]] working on your server). | * [[:en:Installing Moodle|Installing Moodle]]: The guide to install Moodle (once you have the [[:en:Installing AMP|AMP platform]] working on your server). | ||
| Line 31: | Line 30: | ||
* [http://tracker.moodle.org/secure/IssueNavigator.jspa?reset=true&&type=4&type=2&type=3&type=5&pid=10011&resolution=-1&component=10131&sorter/field=issuekey&sorter/order=DESC XMLDB pending improvements and features] | * [http://tracker.moodle.org/secure/IssueNavigator.jspa?reset=true&&type=4&type=2&type=3&type=5&pid=10011&resolution=-1&component=10131&sorter/field=issuekey&sorter/order=DESC XMLDB pending improvements and features] | ||
* [http://moodle.org/mod/forum/view.php?id=55 Developers forum]: For general development discussions. | * [http://moodle.org/mod/forum/view.php?id=55 Developers forum]: For general development discussions. | ||
=== Database engine documentation === | === Database engine documentation === | ||
| Line 40: | Line 38: | ||
* [http://dev.mysql.com/doc/refman/5.0/en/index.html MySQL] | * [http://dev.mysql.com/doc/refman/5.0/en/index.html MySQL] | ||
* [http://msdn.microsoft.com/en-us/library/ms189826.aspx MSSQL] | * [http://msdn.microsoft.com/en-us/library/ms189826.aspx MSSQL] | ||
=== See also === | === See also === | ||
| Line 49: | Line 46: | ||
[[Category:XMLDB]] | [[Category:XMLDB]] | ||
[[Category:DB]] | [[Category:DB]] | ||
[[ja:XMLデータベーススキーマ]] | |||
Latest revision as of 13:26, 13 December 2024
XMLDB is Moodle's database abstraction layer -- it is the library of code that lets Moodle interact with and access the database.
In this page you will find links to all the XMLDB-related documentation.
Introduction
- Introduction: Where the general idea of XMLDB is explained.
- Roadmap: An overall view of the process of implementing the XMLDB subsystem, with details for each point of the process.
- Problems: A comprehensive list of issues that need to be determined/solved prior to incorporate them into the roadmap.
Installation
- Installing MSSQL for PHP: One short manual about the steps needed to successfully add MSSQL support to PHP.
- Installing Moodle: The guide to install Moodle (once you have the AMP platform working on your server).
Developing
- DDL functions: One list of the new XMLDB Data Definition functions and their usage.
- DML functions: One list of the available Data Manipulation functions and their usage.
- XMLDB Usage: Explanation about the XML schema basis, the XML editor embedded within Moodle, its naming conventions and one simple but illustrative example.
- Installing and upgrading plugin database tables
- Coding guidelines: The main coding guidelines and, more exactly, the database structures section that you must follow carefully in order to produce good cross-db code.
- Database schema: Moodle database diagrams in DBDesigner4 format.
Bugs and new features
- XMLDB known bugs
- XMLDB pending improvements and features
- Developers forum: For general development discussions.
Database engine documentation
Here are convenient links to the reference documentation of the various database engines we support, should you need to check that something is supported by all of them:
See also
- DB column types - Some links about column types inside every RDBMS and their characteristics.
- DB key and index naming - Some info about automatic naming of keys/indexes and other objects.
- DB reserved words - A collection of reserver words inside each RDBMS.
