DRX

Web Developer Resource Index: PostgreSQL

PostgreSQL is an open source, object-oriented relational database management system (ORDBMS). PostgreSQL has a long history, starting with the Ingres project out of the UCB. It later evolved into various commercial database systems, including Informix, Sybase, and even (gasp) Microsoft SQL Server.

Fast forward to 2004 when Ingres was now owned by Computer Associates (CA), who released the system as open source, and the current PostgreSQL Project was born. The system includes the ability to define column types, and a powerful set of rules for extracting data from related tables. See the link to Wikipedia at the bottom of the page and the official PostgreSQL Web site for more details.

PostgreSQL has a more liberal BSD-style licensing policy than MySQL’s GNU GPL and commercial licenses.

Updated: Wednesday, October 29th, 2008 @ 1:53 AM EDT

Software:Databases:PostgreSQL {0}(4)[61]

Navigation

Resources

• 1.PostgreSQL

  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. [243]

  ★★★★☆
  URI:http://www.postgresql.org/
  Author:
  PostgreSQL Developers
  [2]
  Reviewed:Wednesday, April 13th, 2005 @ 7:11 PM EDT
  by:
  Douglas Clifton
  
  PostgreSQL postgresql
   

• 2.PostGIS

  PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS). [1766]

  ★★★★☆
  URI:http://postgis.refractions.net/
  Author:
  Refractions Research
  [1]
  Reviewed:Sunday, October 19th, 2008 @ 10:25 PM EDT
  by:
  Douglas Clifton
  
  PostGIS databasegispostgresql
   

• 3.Practical PostgreSQL

  The complete O'Reilly book in an online edition. I tell you what, I wish MySQL AB would take notice of this outstanding resource. It is easy to navigate, includes lots of examples, and you can read it w/o bumping the font size up in your browser. [1244]

  ★★★★☆
  URI:http://commandprompt.com/ppbook/
  Author:
  Command Prompt
  [1]
  Reviewed:Friday, May 27th, 2005 @ 9:01 PM EDT
  by:
  Douglas Clifton
  
  Practical PostgreSQL ebookpostgresqlreference
   

• 4.PostgreSQL 8.0 Documentation

  Full online documentation for PostgreSQL 8.0, with user comments. [244]

  ★★★★☆
  URI:http://www.postgresql.org/docs/8.0/interactive/
  Author:
  PostgreSQL Developers
  [2]
  Reviewed:Wednesday, April 13th, 2005 @ 7:40 PM EDT
  by:
  Douglas Clifton
  
  PostgreSQL 8.0 Documentation postgresqlreference
   

Related Categories

Software:Databases:MySQL {0}(24)[26]

Matching Tags

database ebook gis postgresql reference

Indexes

Search for PostgreSQL on: