Pushed to naviserver/nsdbpg
What is this? ------------ This module implements a simple NaviServer/AOLserver database services driver. A database driver is a module which interfaces between the NaviServer database-independent nsdb module and the API of a particular DBMS. A database driver's job is to open connections, send SQL statements, and translate the results into the form used by nsdb. In this case, the driver is for the PostgreSQL ORDBMS from The PostgreSQL Global Development Group. This is the official driver for the OpenACS project. PostgreSQL can be downloaded and installed on most Unix systems. To use this driver, you must have PostgreSQL installed on your system. For more information on PostgreSQL or to download the code, open: http://www.postgresql.org What's new? ----------- See Changelog. How does it work? ---------------- Driver modules look much like ordinary AOLserver modules but are loaded differently. Instead of being listed with other modules in the [ns\server\<server-name>\modules] configuration section, a database driver is listed in the [ns\db\drivers] section and nsdb does the loading. The database driver initialization function normally does little more than call the nsdb Ns_DbRegisterDriver() function with an array of pointers to functions. The functions are then later used by nsdb to open database connections and send and process queries. This architecture is much like ODBC on Windows. In addition to open, select, and getrow functions, the driver also provides system catalog functions and a function for initializing a virtual server. The virtual server initialization function is called each time nsdb is loaded into a virtual server. In this case, the server initialization function, Ns_PgServerInit, adds the "ns_pg" Tcl command to the server's Tcl interpreters which can be used to fetch information about an active PostgreSQL connection in a Tcl script. Contributors to this file include: Don Baccus <email@example.com> Lamar Owen <firstname.lastname@example.org> Jan Wieck <email@example.com> Keith Pasket (SDL/USU) Scott Cannon, Jr. (SDL/USU) Dan Wickstrom <firstname.lastname@example.org> Scott S. Goodwin <email@example.com> Gustaf Neumann <firstname.lastname@example.org> Original example driver by Jim Davidson DEVELOPER'S GUIDE: Run 'make help' for developer information. The build step needs from PostgreSQL - the include file libpq-fe.h - the library libpq.* Examples for a build operation: export PG=/usr/local/pg965 make PGLIB=$PG/lib PGINCLUDE=$PG/include make PGINCLUDE=/usr/include/postgresql To build/install on a non-standard path, use e.g.: export PG=/usr/local/pg965 make PGLIB=$PG/lib PGINCLUDE=$PG/include NAVISERVER=/opt/local/ns/ make PGLIB=$PG/lib PGINCLUDE=$PG/include NAVISERVER=/opt/local/ns/ install Under MacPorts, you might use something like: make PGLIB=/opt/local/lib/postgresql10/ PGINCLUDE=/opt/local/include/postgresql10/ For extended code checking via cppchek, one might use e.g. make PGLIB=/opt/local/lib/postgresql10/ PGINCLUDE=/opt/local/include/postgresql10/ cppcheck See the Makefile for further information on building this module.