Database FAQ: Difference between revisions
From MoodleDocs
m (→See also:) |
Frank Ralf (talk | contribs) (→Moodle database: moved forum link to the correct sub-section) |
||
(46 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
{{Work in progress}} | {{Work in progress}} | ||
There are two types of "databases" in Moodle: | |||
: a) The '''Moodle activity''' named ''Database'' | |||
::* [[Database activity module FAQ]] is the FAQ page | |||
: b) The '''database on your server''' where Moodle stores all its content | |||
Here is some additional information that may help guide you to more information to answer your FAQs | |||
== | == Database activity module == | ||
* [[Database module]] | Moodle Docs | ||
* [[Database module FAQ]] | * [[:Category:Database activity module]] | ||
* [http://moodle.org/mod/forum/view.php?id=3505 Database module forum] | * [[Database activity module]] | ||
* [[Database activity module FAQ]] | |||
* [http://moodle.org/mod/forum/view.php?id=3505 Database activity module forum] | |||
* [[Import_and_export_FAQ#How_do_I_import_and_export_database_entries.3F| How do I import and export database entries?]] | |||
== | == Moodle database == | ||
* [[ | ===Moodle Docs links=== | ||
* [[:Category:DB]] | |||
* [[Development:Database schema introduction]] | * [[Development:Database schema introduction]] | ||
* [[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. | |||
* [[Create Moodle site database]] | * [[Create Moodle site database]] | ||
* [http:// | |||
===Moodle Forums links=== | |||
* [http://moodle.org/mod/forum/view.php?id=45 Databases forum] | |||
* [http://moodle.org/mod/forum/discuss.php?d=65072 "Moodle database design issues I'd like to tackle/see tackled"] in the Moodle forum (from 2007). | * [http://moodle.org/mod/forum/discuss.php?d=65072 "Moodle database design issues I'd like to tackle/see tackled"] in the Moodle forum (from 2007). | ||
* [http://www.jchq.net/moodle2erd.mwb MySQL workbench file] for download (for using with [http://www.mysql.de/products/workbench/ MySQL Workbench]). - Related forum discussion: [http://moodle.org/mod/forum/discuss.php?d=108886 Referential integrity in Moodle] | |||
===Non Moodle.org links=== | |||
* [http://learn.open.ac.uk/mod/oublog/viewpost.php?post=5741 "Database abstraction layers and Moodle"] from [http://moodle.org/user/view.php?id=78896&course=5 Christopher Douce]'s blog (Open University) | |||
=== Moodle core libraries === | |||
Moodle's core libraries provide lots of functions for working with the database. | |||
* [http://xref.moodle.org/nav.html?lib/datalib.php.html /lib/datalib.php] for higher level functions | |||
* [http://xref.moodle.org/nav.html?lib/dmllib.php.html /lib/dmllib.php] for lower level functions | |||
== XMLDB == | == XMLDB == | ||
XMLDB stores the database definition in an XML format that can be used to install Moodle on any database. | XMLDB stores the database definition in an XML format that can be used to install Moodle on any database. | ||
* [[Development:Database]] | |||
* [[Development:XMLDB Documentation]] | * [[Development:XMLDB Documentation]] | ||
* [[Development: | * [[Development:XMLDB defining an XML structure#The XMLDB editor]] | ||
* [[XMLDB editor]] | * [[XMLDB editor]] | ||
* [[:Category:XMLDB]] | * [[:Category:XMLDB]] | ||
'''Introduction to Moodle Programming''' course: | |||
* [http://dev.moodle.org/mod/resource/view.php?id=48 Unit 7 - Part A: Block Basics: Create a Database Table for the Block] | |||
* [http://dev.moodle.org/mod/resource/view.php?id=55 Unit 7 - Appendix B: The XMLDB Editor] | |||
== Different kinds of databases == | == Different kinds of databases == | ||
* [[MySQL]] | * [[MySQL]] | ||
* MSSQL | * MSSQL - see [[Installing MSSQL for PHP]] | ||
* Oracle | * Oracle - see [[Installing Oracle for PHP]] | ||
* [[PostgreSQL]] | * [[PostgreSQL]] | ||
Line 39: | Line 63: | ||
* See [[Development:DB_layer_2.0]]. | * See [[Development:DB_layer_2.0]]. | ||
* For new features in Moodle 2.0 see [[Development:Coding#Database]]. | * For new features in Moodle 2.0 see [[Development:Coding#Database]]. | ||
* [[Development:DB_layer_2.0_delegated_transactions| Delegated transactions]] on Moodle Docs and the related forum discussion on [http://moodle.org/mod/forum/discuss.php?d=135847 Database transactions in Moodle] | |||
== See also: == | == See also: == | ||
*[ | * Moodle Documentation Forum discussion about [http://moodle.org/login/index.php#p545740 Categories "DB" and "Database"] | ||
[[Category:Developer]] | [[Category:Developer]] | ||
[[Category:DB]] | [[Category:DB]] | ||
[[Category:XMLDB]] | |||
[[Category:Database activity module]] | |||
[[Category:FAQ]] | [[Category:FAQ]] |
Latest revision as of 13:09, 24 November 2010
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.
There are two types of "databases" in Moodle:
- a) The Moodle activity named Database
- Database activity module FAQ is the FAQ page
- b) The database on your server where Moodle stores all its content
Here is some additional information that may help guide you to more information to answer your FAQs
Database activity module
Moodle Docs
- Category:Database activity module
- Database activity module
- Database activity module FAQ
- Database activity module forum
- How do I import and export database entries?
Moodle database
Moodle Docs links
- Category:DB
- Development:Database schema introduction
- 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.
Moodle Forums links
- Databases forum
- "Moodle database design issues I'd like to tackle/see tackled" in the Moodle forum (from 2007).
- MySQL workbench file for download (for using with MySQL Workbench). - Related forum discussion: Referential integrity in Moodle
Non Moodle.org links
- "Database abstraction layers and Moodle" from Christopher Douce's blog (Open University)
Moodle core libraries
Moodle's core libraries provide lots of functions for working with the database.
- /lib/datalib.php for higher level functions
- /lib/dmllib.php for lower level functions
XMLDB
XMLDB stores the database definition in an XML format that can be used to install Moodle on any database.
- Development:Database
- Development:XMLDB Documentation
- Development:XMLDB defining an XML structure#The XMLDB editor
- XMLDB editor
- Category:XMLDB
Introduction to Moodle Programming course:
- Unit 7 - Part A: Block Basics: Create a Database Table for the Block
- Unit 7 - Appendix B: The XMLDB Editor
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.
- Delegated transactions on Moodle Docs and the related forum discussion on Database transactions in Moodle
See also:
- Moodle Documentation Forum discussion about Categories "DB" and "Database"