2
$PostgreSQL: pgsql/doc/src/sgml/external-projects.sgml,v 1.7 2004-12-29 23:36:46 tgl Exp $
5
<appendix id="external-projects">
6
<title>External Projects</title>
9
<productname>PostgreSQL</productname> is a complex software project,
10
and managing it is difficult. We have found that many
11
enhancements to <productname>PostgreSQL</productname> can be more
12
efficiently developed separately from the core project. Separate
14
have their own developer teams, email lists, bug tracking,
15
and release schedules. While their independence makes
16
development easier, it makes users' jobs harder. They have to hunt
17
around looking for database enhancements to meet their needs.
18
This section describes some of the more popular externally
19
developed enhancements and guides you on how to find them.
23
Many <productname>PostgreSQL</productname>-related projects are
25
<productname>GBorg</> at <ulink
26
url="http://gborg.postgresql.org">http://gborg.postgresql.org</ulink>
27
or <productname>pgFoundry</> at <ulink
28
url="http://pgfoundry.org">http://pgfoundry.org</ulink>.
30
<productname>PostgreSQL</productname>-related projects that are hosted
31
elsewhere, but you will have to do an Internet search to find them.
34
<sect1 id="external-interfaces">
35
<title>Externally Developed Interfaces</title>
38
<primary>interfaces</primary>
42
<productname>PostgreSQL</productname> includes very few interfaces
43
with the base distribution. <application>libpq</> is packaged because
44
it is the primary <application>C</> interface and many other
45
interfaces are built on top of it. <application>ecpg</> is packaged
46
because it is tied to the server-side grammar so is very dependent
47
on the database version. All the other interfaces are independent
48
projects and must be installed separately.
52
Some of the more popular interfaces are:
59
This is the most common interface for <application>Windows</>
69
A <application>JDBC</> interface.
78
<application>.Net</> interface for more recent
79
<application>Windows</> applications.
88
A newer <application>C++</> interface.
97
An older <application>C++</> interface.
106
A <application>Perl</> interface with an <acronym>API</> similar
107
to <application>libpq</>.
116
A <application>Perl</> interface that uses the
117
<acronym>DBD</>-standard <application>API</>.
126
A newer version of the <application>Tcl</> interface.
135
The original version of the <application>Tcl</> interface.
141
<term>PyGreSQL</term>
144
A <application>Python</> interface library.
151
All of these can be found at
152
<productname>GBorg</> (<ulink
153
url="http://gborg.postgresql.org">http://gborg.postgresql.org</ulink>)
154
or <productname>pgFoundry</> (<ulink
155
url="http://pgfoundry.org">http://pgfoundry.org</ulink>).
160
<sect1 id="external-extensions">
161
<title>Extensions</title>
164
<primary>extensions</primary>
168
<productname>PostgreSQL</> was designed from the start to be
169
extensible. For this reason, extensions loaded into the database can
170
function just like features that are packaged with the database. The
171
<filename>contrib/</> directory shipped with the source code
172
contains a large number of extensions. The <filename>README</> file
173
in that directory contains a summary. They include conversion tools,
174
full-text indexing, <acronym>XML</> tools, and additional data types
175
and indexing methods. Other extensions are developed independently,
176
like <application>PostGIS</>. Even <application>PostgreSQL</>
177
replication solutions are developed externally. For example,
178
<application>Slony-I</> is a popular master/slave replication solution
179
that is developed independently from the core project.
183
There are several administration tools available for
184
<productname>PostgreSQL</>. The most popular is
185
<application>pgAdmin</>, and there are several commercially
192
<!-- Keep this comment at the end of the file
197
sgml-minimize-attributes:nil
198
sgml-always-quote-attributes:t
201
sgml-parent-document:nil
202
sgml-default-dtd-file:"./reference.ced"
203
sgml-exposed-tags:nil
204
sgml-local-catalogs:("/usr/lib/sgml/catalog")
205
sgml-local-ecat-files:nil