On 7/17/06, Stephen Deasey <[EMAIL PROTECTED]> wrote:
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.
Stephen,
Two things. First, I think that removing the dict stuff is a
mistake. Reverting any work that was progress is not a good idea.
Second, I would love to help at least test this module or further its
progress. However, I need for this to happen <now> - as in, at the
latest by tomorrow evening EDT I will need to have at least something
I can use to access the database from naviserver. Right now I am
looking at 4 choices:
1) drop nsdb from naviserver and use nstcl after cleaning up any
multi-thread issues
2) import ad_proc and 00-database from OACS and hack them up until
they work. (unfortunately the combination of the two is not possible
- nstcl ad_proc does not support positional parameters without default
values after named parameters ith default values)
3) dig into OSSWEB and import its notion of ad_proc and db_*
4) nsdbi and friends
Numbers 3 and 4 sound most appealing to me at this moment because
these are "most supported" by the naviserver "community" - getting
help with 00-database is unlikely to happen for something unrelated to
OACS and nstcl hasn't been touched in 2+ years. The downside to
Number 3 is that i need to import a bunch of things with OSSWEB that
are not related to the database, and I am hesitant about doing so.
Your thoughts, comments, and opinions are most welcome.