Difference between revisions of "PostgreSQL"

Jump to: navigation, search
m
Line 1: Line 1:
 
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.
  
PostgreSQL describes itself thus:
+
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 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:
 
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:
Line 24: Line 22:
 
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."
 
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."
  
PostgreSQL home page: http://www.postgresql.org/
+
== See also ==
 +
 
 +
* [http://www.postgresql.org PostgreSQL home page]
 +
* [http://moodle.org/mod/forum/view.php?id=45 Using Moodle databases forum]
 +
 
 +
[[Category:Administrator]]
 +
[[Category:Developer]]
 +
[[Category:SQL databases]]
 +
 
 +
{{stub}}

Revision as of 14:24, 30 May 2006

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."

See also