Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit6b16aaa

Browse files
committed
First version of external projects manual section.
1 parent28c8c99 commit6b16aaa

File tree

3 files changed

+228
-3
lines changed

3 files changed

+228
-3
lines changed

‎doc/src/sgml/external-projects.sgml

Lines changed: 223 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,223 @@
1+
<!--
2+
$PostgreSQL: pgsql/doc/src/sgml/external-projects.sgml,v 1.1 2004/12/03 05:50:17 momjian Exp $
3+
-->
4+
5+
<chapter id="external-projects">
6+
<title>External Projects</title>
7+
8+
<para>
9+
<productname>PostgreSQL</productname> is a large piece of very
10+
complex software, and managing the code is a difficult process. We
11+
have found that many enhancements to
12+
<productname>PostgreSQL</productname> can be more efficiently
13+
developed independently of the main project. They can have their own
14+
developer teams, email lists, their own bug tracking, and their own
15+
release schedule. While their independence makes development easier,
16+
it makes users job harder. They have to hunt around looking for
17+
database enhancements to meet their needs.
18+
</para>
19+
20+
<para>
21+
This section will outlines some of the more popular externally
22+
developed enhancements and guides you on how to find them.
23+
</para>
24+
25+
<sect1 id="interfaces">
26+
<title>Externally Developed Interfaces</title>
27+
28+
<indexterm>
29+
<primary>interfaces</primary>
30+
</indexterm>
31+
32+
<para>
33+
<productname>PostgreSQL</productname> packages very few interfaces
34+
with the base distribution. <application>libpq</> is packaged because
35+
it is the primary <application>C</> interface and many other
36+
interfaces are built on top of it. <application>ecpg</> is packaged
37+
because it is tied to the server-side grammar so it is very dependent
38+
on the database version. All the other interfaces are independent
39+
projects.
40+
</para>
41+
42+
<para>
43+
To use other interfaces, you have to do some searching. For example,
44+
<productname>GBorg</> at <ulink url="http://gborg.postgresql.org">
45+
http://gborg.postgresql.org</ulink> has over thirty interfaces listed
46+
in its <literal>Drivers/Interfaces</> section. Some of the more
47+
popular interfaces are:
48+
49+
<variablelist>
50+
<varlistentry>
51+
<term>ODBC</term>
52+
<listitem>
53+
<para>
54+
This is the most common interface for <application>Windows</>
55+
applications.
56+
</para>
57+
</listitem>
58+
</varlistentry>
59+
60+
<varlistentry>
61+
<term>psqlODBC</term>
62+
<listitem>
63+
<para>
64+
This is the most common interface for <application>Windows</>
65+
applications.
66+
</para>
67+
</listitem>
68+
</varlistentry>
69+
70+
<varlistentry>
71+
<term>Npgsql</term>
72+
<listitem>
73+
<para>
74+
<application>.Net</> interface for more recent
75+
<application>Windows</> applications.
76+
</para>
77+
</listitem>
78+
</varlistentry>
79+
80+
<varlistentry>
81+
<term>libpq++</term>
82+
<listitem>
83+
<para>
84+
An older <application>C++</> interface.
85+
</para>
86+
</listitem>
87+
</varlistentry>
88+
89+
<varlistentry>
90+
<term>libpqxx</term>
91+
<listitem>
92+
<para>
93+
A newer <application>C++</> interface.
94+
</para>
95+
</listitem>
96+
</varlistentry>
97+
98+
<varlistentry>
99+
<term>pgperl</term>
100+
<listitem>
101+
<para>
102+
A <application>Perl</> interface with an <acronym>API</> similar
103+
to <application>libpq</>.
104+
</para>
105+
</listitem>
106+
</varlistentry>
107+
108+
<varlistentry>
109+
<term>DBD-Pg</term>
110+
<listitem>
111+
<para>
112+
A <application>Perl</> interface that uses the
113+
<acronym>DBD</>-standard <application>API</>.
114+
</para>
115+
</listitem>
116+
</varlistentry>
117+
118+
<varlistentry>
119+
<term>pgtcl</term>
120+
<listitem>
121+
<para>
122+
The original version of the <application>TCL</> interface.
123+
</para>
124+
</listitem>
125+
</varlistentry>
126+
127+
<varlistentry>
128+
<term>PyGreSQL</term>
129+
<listitem>
130+
<para>
131+
A <application>Python</> interface library.
132+
</para>
133+
</listitem>
134+
</varlistentry>
135+
136+
<varlistentry>
137+
<term>pgjdbc</term>
138+
<listitem>
139+
<para>
140+
A <application>JDBC</> interface.
141+
</para>
142+
</listitem>
143+
</varlistentry>
144+
145+
<varlistentry>
146+
<term>pgtclng</term>
147+
<listitem>
148+
<para>
149+
A newer version of the <application>TCL</> interface.
150+
</para>
151+
</listitem>
152+
</varlistentry>
153+
154+
</variablelist>
155+
</para>
156+
157+
<para>
158+
That section also contains several server-side languages that are
159+
separate projects. <application>pgFoundry</> at <ulink
160+
url="http://pgfoundry.org">http://pgfoundry.org</ulink> contains
161+
even more projects. Other projects are not even hosted on these
162+
servers and you will have to do an internet search to find them.
163+
</para>
164+
165+
</sect1>
166+
167+
<sect1 id="extensions">
168+
<title>Extensions</title>
169+
170+
<indexterm>
171+
<primary>extensions</primary>
172+
</indexterm>
173+
174+
<para>
175+
<productname>PostgreSQL</> was designed from the start to be
176+
extensible. For this reason, extensions loaded into the database can
177+
function just like features that are packaged with the database. The
178+
<filename>/contrib</> directory shipped with the source code
179+
contains a large number of extensions. The <filename>READMD</> file
180+
in that directory contains a summary. They include conversion tools,
181+
full-text indexing, <acronym>XML</> tools, and additional data types
182+
and indexing methods. Other extensions are developed independently,
183+
like <application>PostGIS</>. Even <application>PostgreSQL</>
184+
replication solutions are developed externally. For example,
185+
<application>Slony</> is a popular master/slave replication solution
186+
that is developed independently from the main projects.
187+
</para>
188+
189+
</sect1>
190+
191+
<sect1 id="administration-tools">
192+
<title>Administration Tools</title>
193+
194+
<indexterm>
195+
<primary>administration tools</primary>
196+
</indexterm>
197+
198+
<para>
199+
There are several administration tools available for
200+
<productname>PostgreSQL</>. The most popular is
201+
<application>pgadmin</>, and there are several commercially
202+
available ones.
203+
</para>
204+
205+
</sect1>
206+
</chapter>
207+
208+
<!-- Keep this comment at the end of the file
209+
Local variables:
210+
mode:sgml
211+
sgml-omittag:nil
212+
sgml-shorttag:t
213+
sgml-minimize-attributes:nil
214+
sgml-always-quote-attributes:t
215+
sgml-indent-step:1
216+
sgml-indent-data:t
217+
sgml-parent-document:nil
218+
sgml-default-dtd-file:"./reference.ced"
219+
sgml-exposed-tags:nil
220+
sgml-local-catalogs:("/usr/lib/sgml/catalog")
221+
sgml-local-ecat-files:nil
222+
End:
223+
-->

‎doc/src/sgml/filelist.sgml

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/filelist.sgml,v 1.39 2004/11/12 21:50:53 tgl Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/filelist.sgml,v 1.40 2004/12/03 05:50:18 momjian Exp $ -->
22

33
<!entity history SYSTEM "history.sgml">
44
<!entity info SYSTEM "info.sgml">
@@ -48,6 +48,7 @@
4848
<!entity dfunc SYSTEM "dfunc.sgml">
4949
<!entity ecpg SYSTEM "ecpg.sgml">
5050
<!entity extend SYSTEM "extend.sgml">
51+
<!entity external-projects SYSTEM "external-projects.sgml">
5152
<!entity func-ref SYSTEM "func-ref.sgml">
5253
<!entity infoschema SYSTEM "information_schema.sgml">
5354
<!entity libpq SYSTEM "libpq.sgml">

‎doc/src/sgml/postgres.sgml

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/postgres.sgml,v 1.67 2004/12/0301:23:38 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/postgres.sgml,v 1.68 2004/12/0305:50:18 momjian Exp $
33
-->
44

55
<!DOCTYPE book PUBLIC "-//OASIS//DTD DocBook V4.2//EN" [
@@ -179,7 +179,7 @@ $PostgreSQL: pgsql/doc/src/sgml/postgres.sgml,v 1.67 2004/12/03 01:23:38 momjian
179179
&lobj;
180180
&ecpg;
181181
&infoschema;
182-
&external_projects;
182+
&external-projects;
183183

184184
</part>
185185

@@ -236,6 +236,7 @@ $PostgreSQL: pgsql/doc/src/sgml/postgres.sgml,v 1.67 2004/12/03 01:23:38 momjian
236236
&geqo;
237237
&indexcost;
238238
&gist;
239+
&filelayout;
239240
&page;
240241
&bki;
241242

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp