Re: [naviserver-devel] another sample config issue and some database related questions...

[Stephen D. <sd...@gm...>]

On 7/16/06, Mike <nee...@gm...> 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  <sd...@us...>
>
>   * 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.