PostgreSQL is a sophisticated Object-Relational DBMS, supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. It is the most advanced open-source database available anywhere. Commercial Support is also available.
The original Postgres code was the effort of many graduate students, undergraduate students, and staff programmers working under the direction of Professor Michael Stonebraker at the University of California, Berkeley. In 1995, Andrew Yu and Jolly Chen took on the task of converting the DBMS query language to SQL and created a new database system which came to known as Postgres95. Many others contributed to the porting, testing, debugging and enhancement of the Postgres95 code. As the code improved, and 1995 faded into memory, PostgreSQL was born.
PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the support mailing list (questions@PostgreSQL.ORG).
PostgreSQL is free and the complete source is available.
WWW: http://www.postgresql.org/
GtkSQL is a graphical query tool for PostgreSQL/MySQL. You can work on multiple queries simultaneously:
WWW: http://membres.lycos.fr/bbrox/GtkSQL/
This is the C++ interface that has been shipped as part of PostgreSQL for many releases. There is a newer C++ interface called libpqxx, which is in a separate port, postgresq-pgcxx.
WWW: http://gborg.postgresql.org/project/libpqpp/
Welcome to libpqxx, a C++ API to the PostgreSQL database management system.
There are many similar libraries for PostgreSQL and for other databases, some of them database-independent. Most of these, however, are fairly C-like in their programming style, and fail to take advantage of the full power of the C++ language as it has matured since the acceptance of the Standard in 1996.
What libpqxx brings you is effective use of templates to reduce the inconvenience of dealing with type conversions; of standard C++ strings to keep you from having to worry about buffer allocation and overflow attacks; of exceptions to take the tedious and error-prone plumbing around error handling out of your hands; of constructors and destructors to bring resource management under control; and even basic object-orientation to give you some extra reliability features that would be hard to get with most other database interfaces.
WWW: http://gborg.postgresql.org/project/libpqxx/
The perl script mysql2pgsql can be used to convert MySQL database dumps to a -compatible format (so the data can be imported into PostgreSQL). This can be useful if you are switching from MySQL to PostgreSQL and you have quite a bit of data in your MySQL databases.
WWW: http://www.rot13.org/~dpavlin/projects.html
- Pete petef@databits.net
A driver module allowing access to PostgreSQL databases from within AOLserver.
WWW: http://www.aolserver.com/
DBD::Pg is an extension to Perl which allows access to PostgreSQL databases. It is built on top of the standard DBI extension and implements some of the methods that DBI defines.
WWW: http://search.cpan.org/search?dist=DBD-Pg
This is an API for using Perl5 to access PostgreSQL databases. This software is part of the standard PostgreSQL distribution.
WWW: http://www.postgresql.org/
PL/Perl allows you to write PostgreSQL functions and procedures in Perl. Consult the PostgreSQL User's Guide and the INSTALL file in the top-level directory of the source distribution for more information. This software is part of the standard PostgreSQL distribution.
WWW: http://www.postgresql.org/
This is a PAM module for authenticating with PostgreSQL. It also supports:
WWW: http://packages.debian.org/unstable/non-us/libpam-pgsql.html
WWW: http://libpam-pgsql.codecastle.com/
PgAccess is one of the prettiest GUIs (graphical user interfaces) for the open source database PostgreSQL.
PgAccess is a cross-platform database management tool for PostgreSQL written in Tcl/Tk. There are active efforts to turn it into a tool for writing applications that can work in a distributed client-server model (a central PostgreSQL database and remote clients).
PgAccess was originally written by Constantin Teodorescu using Visual Tcl, "the best tool for developing Tcl/Tk applications I've ever seen." It is currently managed by a growing team of developers.
WWW: http://www.pgaccess.org/
A driver for AOLserver to PostgreSQL connectivity. This is the supported driver for the OpenACS project.
phpPgAdmin is phpMyAdmin (for MySQL) ported to PostgreSQL. phpPgAdmin is a fully functional PostgreSQL administration utility. You can use it to create and maintain multiple databases and even multiple servers.
Features include:
WWW: http://phppgadmin.sourceforge.net/
This port installs all of PostgreSQL's documentation files into share/doc/postgresql/html
This is the implementation of JDBC, the Java Database Connectivity API, for accessing PostgreSQL databases from Java. This software is part of the standard PostgreSQL distribution.
WWW: http://www.postgresql.org/
Support connecting to a postgresql database from a unix client application using ODBC. Note: You do not need this port installed on unix if you want to use ODBC to connect a Windows machine to PostgreSQL.
Since there is an ambition to slim the PostgreSQL distribution, this software is no longer a part thereof. It is still the offical ODBC implementation, though.
WWW: http://odbc.postgresql.org/
PL/Ruby is a loadable procedural language for the PostgreSQL database system (7.0 or later) that enables to write functions and trigger procedures in Ruby.
Author: Guy Decoux [ts@moulon.inra.fr]
WWW: http://moulon.inra.fr/ruby/plruby.html
PL/Tcl allows you to write PostgreSQL stored functions and procedures in Tcl. This software is part of the standard PostgreSQL distribution.
WWW: http://www.postgresql.org/
libpgtcl is a library that implements Tcl commands for front-end clients to interact with the Postgresql backends.
pgaccess is a great graphical database management tool for PostgreSQL. This software is part of the standard PostgreSQL distribution.
WWW: http://www.postgresql.org/
Automatic documentation generator for postgresql databases. It supports output in HTML, GraphViz, SGML DocBook and DIA formats.
WWW: http://www.rbt.ca/autodoc/index.shtml
pyPgSQL is a package of two modules that provide a Python DB-API 2.0 compliant interface to PostgreSQL databases. The first module, libpq, exports the PostgreSQL C API to Python. This module is written in C and can be compiled into Python or can be dynamically loaded on demand. The second module, PgSQL, provides the DB-API 2.0 compliant interface and support for various PostgreSQL data types, such as INT8, NUMERIC, MONEY, BOOL, ARRAYS, etc. This module is written in Python.
WWW: http://pypgsql.sourceforge.net/ developed by Bill Allie et al
Gerhard Haering [gerhard.haering@gmx.de]
PyGreSQL is a python module that interfaces to a PostgreSQL database. It embeds the PostgreSQL query library to allow easy use of the powerful PostgreSQL features from a Python script.
As of version 3.2, PyGreSQL was folded into the PostgreSQL development tree. PyGreSQL includes a DB-API 2.0 compliant API wrapper.
Author: D'Arcy J.M. Cain [darcy@druid.net]
WWW: http://www.druid.net/pygresql/
See also: http://www.postgresql.org/idocs/index.php?pygresql.html
psycopg is a PostgreSQL database adapter for the Python programming language. It was written from scratch with the aim of being very small and fast, and stable as a rock. The main advantages of psycopg are that it supports the full Python DBAPI-2.0 and being thread safe at level 2.
psycopg is different from the other database adapter because it was designed for heavily multi-threaded applications that create and destroy lots of cursors and make a conspicuous number of concurrent INSERTs or UPDATEs. Every open Python connection keeps a pool of real (UNIX or TCP/IP) connections to the database. Every time a new cursor is created, a new connection does not need to be opened; instead one of the unused connections from the pool is used. That makes psycopg very fast in typical client-server applications that create a servicing thread every time a client request arrives.
WWW: http://initd.org/software/psycopg
Alex Rodioukov [simuran@shaw.ca]
This is the PostgreSQL driver for DBI-for-Ruby.
Author: Jim Weirich [jweirich@one.ent]
WWW: http://www.ruby-projects.org/dbi/
This is an extention module to access PostgreSQL database from Ruby. This library works with PostgreSQL 6.4/6.5 and 7.0/7.1.
Authors: Yukihiro Matsumoto [matz@ruby-lang.org]
Eiji Matsumoto [usagi@ruby.club.or.jp]
Noboru Saitou [noborus@zetabits.com](current
maintainer)
WWW: http://www.postgresql.jp/interfaces/ruby/archive/
This is the Z PyGreSQL database adapter product for the Z Object Publishing Environment.
All content on this site is Copyright 2001
- 2003 by Bill Nicholls
All Rights Reserved