Re: [PATCHES] Re: PostGIS spatial extensions

Projects that are as organized, professional, and value-adding as yours is  can surely stand on their own.  I
comparethis to the recently released  OpenFTS.  If we start including projects of this size we'd explode in size  and
maintenanceoverhead.
 

Doesn't this discussion indicate that the time is fast approaching, if
not already past, for some type of system for handling installation of
3rd party software?

It would seem that two prerequisites would need to be satisfied to do
this:

- Definition and implementation of the interface to be provided for extensions.  Presumably, this would involve
defininga well-designed set of public header files and associated libraries at the right level of granularity.  For
example,encapsulating each type in its own header file with a standardized set of operations defined in a server-side
librarywould be extremely valuable.  The library (or libraries) could be used to link the backend and installed for
extensionsto take advantage of preexisting types when others need to construct new more complex ones.
 

- Definition and implementation of a consistent extension management system for retrieving, compiling, and installing
extensions. This could even be used for installing the system itself, thereby making the entire operation of managing
thesoftware consistent.
 

I point out that the NetBSD pkgsrc system[1] does the latter in an
extremely flexible and well-designed manner, and has been a major
foundation for the openpackages project.  It even includes 7 distinct
packages[2] for different elements of PostgreSQL, not including a
number of other packages broken out for different interfaces.  The
same system could be adopted for managing 3rd party extensions.

Having been involved in defining what header files to install, and
having been actively involved in developing new types for use in our
installation, I can say that external packaging of PostgreSQL, local
extension of PostgreSQL, and management of 3rd party software would be
greatly enhanced by an effort to address the two prerequisites
mentioned above.

Cheers,
Brook

---------------------------------------------------------------------------
[1] http://www.netbsd.org/Documentation/software/packages.html
[2] ftp://ftp.netbsd.org/pub/NetBSD/packages/pkgsrc/databases/README.html