On 7/16/06, Mike <[EMAIL PROTECTED]> wrote:
[lumping into one mail since it looks like we have a pretty tightly knit group of readers anyway]the sample nscgi config should read: ns_param map "GET /cgi-bin ${homedir}/cgi-bin" instead of hardcoing the path... what is the "right" way of getting nsposgres to build and run under naviserver? nspostgres was not in cvs for either naviserver or the modules - i found it on sourceforge and had to hack it a bit to get it to build even (in particular, it wants the _3_PlUS define removed in: 2005-07-30 Stephen Deasey <[EMAIL PROTECTED]> * include/ns.h: Untabify and reformat some definitions. Remove unused/unneeded NS_AOLSERVER_3_PLUS, NS_SHUTDOWN and NS_REGISTER_SERVER_TRACE. )... now, if there is no less painful way to get nspostgres to work... there should be... :) overall, the state of what modules exist and how to use them appears to be... abysmal. or am I just looking into the wrong place?
The nspostgres module was imported into naviserver cvs and renamed nsdbpg. All the database module were renamed nsdb* to prevent confusion when a new db interface module is imported... (see below)
another question I have is about the ns_db... the OpenACS database access functions are quite nice - is there some way to get them under NaviServer without having to hack up OpenACS and extract them out of it? I know there is an nstcl package available on sourceforge that reimplements this functionality, but from a mile-high guess, this package will conflict/not play nice with the NaveServer stuff...
I have a new database module called nsdbi which presents an API inspired by the ACS db procs. It's all built right into the driver framework. The nsdb module doesn't know anything about bind variable. The nspostgres driver *emulates* bind variables. The ACS procs provide a unified interface over the custom postgres and oracle drivers. For nsdbi I added bind variable support to the driver interface and native postgres support to the nsdbipg driver. It isn't just bind variable though. There are a few things in nsdb, and some in the nsdb/acs combo that are less than ideal. And there's some opportunities for new stuff: prepared queres, caching, performance hacks etc. I'll try and upload this to naviserver cvs soon as the basics seem to be working. It's dependent on Tcl 8.5 dicts, but 8.5 seems to be taking forever to release so I'm going to remove that. Might as well get it out there in whatever state so folks can bash on it.
