Directory of PostgreSQL Resources

Home > Computers > Software > Databases > PostgreSQL

PostgreSQL is a powerful relational database management system (rdbms) that is similar to Ingres. PostgreSQL is an enhancement of the original POSTGRES database management system, a next-generation DBMS research prototype. While PostgreSQL retains the powerful data model and rich data types of POSTGRES, it replaces the PostQuel query language with an extended subset of SQL.

Subcategories

• Replication

Resources in This Category

• 2ndQuadrant

  http://www.2ndquadrant.com/
  Training and support for development, tuning, and replication. Site includes course outlines, pricing, and schedules.

• A Review by Paragon Corporation

  http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=11
  Article that focuses on features that make PostgreSQL different from most relational database management systems.

• Cybertec Schönig & Schönig GmbH

  http://www.cybertec.at/
  The company provides professional source-level support and solutions on top of PostgreSQL. Offers information on products and services, references, ressources, and blog.

• Databases: As The Tables Turn

  http://www.phpbuilder.com/columns/tim20001112.php3
  Tim Perdue article about porting sourceforge code from MySQL to PostreSQL.

• EnterpriseDB

  http://www.enterprisedb.com/
  A relational database management system based on PostgreSQL that adds Oracle compatibility feature, performance and management features.

• Guide to Version 7.x Development and Configuration

  http://www.osmosislatina.com/postgres/index.htm
  A side by side comparison to Oracle 8i that can also be read as a stand alone document.

• Interactive SQL

  http://www.microolap.com/products/database/pgisql/
  GUI tool for creating SQL queries and managing PostgreSQL databases [commercial].

• MySQL PHP to PostgresSQL

  http://mp2p.mikekohn.net/
  A program that takes a php page that uses mysql calls and changes them into Postgres calls.

• Native PostgreSQL Frontend for Windows

  http://psql.sourceforge.net/
  Client applications for Windows including native SQL terminal and backup tools, psql and pg_dump, for executing SQL scripts and accessing PostgreSQL servers remotely.

• OCaml

  http://alain.frisch.fr/soft#xpath
  OCaml bindings that allow access to Postgres from the OCaml programming language. [Open Source, LGPL]

• Octave-pg

  http://dirk.eddelbuettel.com/code/octave-pg.html
  Octave modules to access PostgreSQL.

• Oracle v. Postgres

  http://openacs.org/forums/message-view?message_id=17231
  Forum discussion comparing Oracle and Postgres.

• Performance Tuning PostgreSQL

  http://www.revsys.com/writings/postgresql-performance.html
  This article aims to help demystify PostgreSQL database performance tuning.

• PGExplorer

  http://www.pgexplorer.com/
  A GUI development tool for the Postgres Database Server is presented with screenshot, FAQs, download and costs. [Commercial].

• PhpPgAdmin

  http://phppgadmin.sourceforge.net/
  Feature list and downloads for a web-based administration tool.[Open Source, GPL]

• PostGIS: Geographic objects for PostgreSQL

  http://postgis.refractions.net/
  Spatially enables the server, allowing it to be used as a backend spatial database for geographic information systems (GIS).

• Postgres on Redhat7.0

  http://www.phpbuilder.com/columns/kevin20010314.php3
  Article from PHPBuilder on obtaining packages, installing and configuring.

• PostgresDAC

  http://www.microolap.com/products/connectivity/postgresdac/
  Borland Delphi/C++Builder component set for direct access to PostgreSQL without BDE or ODBC.

• PostgresPy Project

  http://python.projects.postgresql.org/
  An open source software project dedicated to the continual improvement of the relationship between Python and PostgreSQL.

• PostgreSQL

  http://www.postgresql.org/
  Sophisticated open-source Object-Relational DBMS supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. Completely free database

• PostgreSQL Manager

  http://www.pgsqlmanager.com/
  Graphical tool for PostgreSQL administration and development.

• pyPgSQL

  http://pypgsql.sourceforge.net/
  A Python library for accessing PostgreSQL databases that conforms to the Python DB-API version 2.

• Recursive functions in PostGreSQL PGSQL

  http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=24
  An example of how to display a recursive tree in pgsql.

• Red Hat Database

  http://www.sourceware.org/rhdb/
  A version of Postgres that has been optimized for the Red Hat Linux distribution.

• Search PostgreSQL Sites

  http://www.pgsql.ru/
  A searchengine for PostgreSQL-Documentation. Sample application for Tsearch2.

• Tsearch2

  http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
  Implementation of a new data type tsvector - a searchable data type with indexed access. Documentation and download.

Other Languages

• Italian
• German
• Japanese
• Chinese Simplified

 

Home > Computers > Software > Databases > PostgreSQL

 

---

 

Thanks to DMOZ, which built a great web directory for nearly two decades and freely shared it with the web. About us