「PostgreSQL」の版間の差分
Mitsuhiro Yoshida (トーク | 投稿記録) 編集の要約なし |
Mitsuhiro Yoshida (トーク | 投稿記録) 編集の要約なし |
||
1行目: | 1行目: | ||
作成中です - [[利用者:Mitsuhiro Yoshida|Mitsuhiro Yoshida]] | 作成中です - [[利用者:Mitsuhiro Yoshida|Mitsuhiro Yoshida]] 2008年2月3日 (日) 11:09 (CST) | ||
PostgreSQL is one of the two databases that is fully supported by Moodle. A database is a required component of any Moodle installation. | PostgreSQL is one of the two databases that is fully supported by Moodle. A database is a required component of any Moodle installation. | ||
27行目: | 27行目: | ||
* [http://www.postgresql.org PostgreSQL home page] | * [http://www.postgresql.org PostgreSQL home page] | ||
* [[Arguments in favour of PostgreSQL]] | |||
* [http://moodle.org/mod/forum/view.php?id=45 Using Moodle databases forum] | * [http://moodle.org/mod/forum/view.php?id=45 Using Moodle databases forum] | ||
* [http://en.wikipedia.org/wiki/Postgres Wikipedia article on PostgerSQL] | * [http://en.wikipedia.org/wiki/Postgres Wikipedia article on PostgerSQL] |
2008年2月3日 (日) 17:09時点における版
作成中です - Mitsuhiro Yoshida 2008年2月3日 (日) 11:09 (CST)
PostgreSQL is one of the two databases that is fully supported by Moodle. A database is a required component of any Moodle installation.
PostgreSQL describes itself as "an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later.
PostgreSQL is an open-source descendant of this original Berkeley code. It supports a large part of the SQL standard and offers many modern features:
- complex queries
- foreign keys
- triggers
- views
- transactional integrity
- multiversion concurrency control
Also, PostgreSQL can be extended by the user in many ways, for example by adding new
- data types
- functions
- operators
- aggregate functions
- index methods
- procedural languages
And because of the liberal license, PostgreSQL can be used, modified, and distributed by everyone free of charge for any purpose, be it private, commercial, or academic."