joeconway.com

Table of Contents
1. PL/R - R Procedural Language for PostgreSQL
2. OSCON 2003 presentation: PostgreSQL-embedded Statistical Analysis with PL/R
   OSCON 2004 tutorial: Power PostgreSQL: Extending the Database with C
   OSCON 2004 tutorial: sourcecode
   OSCON 2004 presentation: Flexible Data Acquisition and Analysis
   OSCON 2004 presentation: sourcecode
   OSCON 2005 presentation: Terebytes of Business Intelligence
3. Bison 1.875 source RPM (this one will work on Red Hat 9)
4. Autoconf 2.57 source RPM
5. PostgreSQL 7.3.4 source RPM
  • - standard 7.3.4 distribution plus postgresql-7.3.3-custom.patch and postgresql-7.3.4-plr-0.5.2.patch:
    1) adds PL/R 0.5.2 alpha to contrib
    2) updates contrib/tablefunc to include hash based crosstab (same as in 7.4)
    3) adds preload_libraries GUC variable and related support to preload and initialize libraries at postmaster startup (also in 7.4)
  • - always configure with --enable-debug (allows gdb to gather meaningful info, doesn't hit performance when using gcc, although resulting binaries are larger)
  • - always define __os_install_post /usr/lib/rpm/brp-compress (to not strip the debug symbols that --enable-debug gave us)
  • - always configure with --enable-integer-datetimes
6. contrib/tablefunc backported for PostgreSQL 7.3.x -- sync'd with CVS HEAD 02-Oct-2003
7. CVSup source RPM for Red Hat 9 - requires ezm3 installed to build
8. CVSup binaries RPM for Red Hat 9, Fedora Core 3, and Fedora Core 4
9. PostgreSQL 7.3.2 documentation (pdf format)
10.PostgreSQL 7.3.2 documentation (A4 pdf format)
11.PostgreSQL 7.3.4 binary RPMs for RHAS
12.str_validate for 7.3.X/7.4devel
13.str_validate for 7.2.X
14.DBD::pg 1.22 source RPM
15.DBD::pg 1.22 binary RPM for Red Hat 7.3
16.R-2.0.1 source RPM with --enable-R-shlib
17.Session Variables Example Functions for Postgres 8.1