From: Mike <nee...@gm...> - 2006-07-16 08:08:40
|
[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? 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... Thanks for your input... after a few "serious" hours of NaviServer - things look pretty good. At least I think I've found what I was looking for - hopefully you guys won't be too annoyed with all my questions, since I'm likely to have much more of them in the future... |
From: Vlad S. <vl...@cr...> - 2006-07-16 13:16:29
|
Just checkout modules from CVS, it has nsdbpg which compiles and wors just fine. > 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...> > > 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... > > There are some in nstk modules, not like in OpenACS but higher level and small. OACS duplication never was in out TODO list:-)) |
From: Andrew P. <at...@pi...> - 2006-07-16 13:54:19
|
> > 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? Nope. The right way to do it is to refactor the OpenACS db_* proc support into a stand-alone Tcl package, and then use that same package for both OpenACS and non-OpenACS systems. That definitely is feasible, but unfortunately, I never got around to doing it. :( -- Andrew Piskorski <at...@pi...> http://www.piskorski.com/ |
From: Stephen D. <sd...@gm...> - 2006-07-17 20:34:48
|
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. |
From: Mike <nee...@gm...> - 2006-07-17 21:39:10
|
On 7/17/06, Stephen Deasey <sd...@gm...> 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. |
From: Stephen D. <sd...@gm...> - 2006-07-20 22:54:40
|
On 7/17/06, Mike <nee...@gm...> wrote: > On 7/17/06, Stephen Deasey <sd...@gm...> 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. It's not a problem. I have it in CVS on my laptop. Needs to be done anyway -- I want to run it and not depend on unreleased Tcl 8.5. > 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. \ Sorry, missed this. I'm syncing the laptop every few days... > 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. > You're using Postgres, right? |
From: Mike <nee...@gm...> - 2006-07-23 00:02:06
|
> > 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. > > > You're using Postgres, right? Correct. Thus far I've been trying to use nstk. It hasn't been terrible, but it hasn't been pleasant either... |
From: Vlad S. <vl...@cr...> - 2006-07-23 00:43:42
|
nstk is quite old and i have not updated in for a long time. Can you describe what was not pleasant and what was terrible, i may work on that to improve it. Mike wrote: >>> 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. >>> >> You're using Postgres, right? > > Correct. Thus far I've been trying to use nstk. It hasn't been > terrible, but it hasn't been pleasant either... > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > naviserver-devel mailing list > nav...@li... > https://lists.sourceforge.net/lists/listinfo/naviserver-devel > -- Vlad Seryakov 571 262-8608 office vl...@cr... http://www.crystalballinc.com/vlad/ |
From: Mike <nee...@gm...> - 2006-07-23 01:04:47
|
On 7/22/06, Vlad Seryakov <vl...@cr...> wrote: > nstk is quite old and i have not updated in for a long time. > > Can you describe what was not pleasant and what was terrible, i may work > on that to improve it. Vlad, I am familiar with OpenACS database API. I am used to it. nstk is very limited as a database API - it is intended to output to a template, so, for example, it's missing a db_foreach sort of functionality. I didn't say it is terrible - I said it hasn't been terrible working with it - but not nearly as pleasant as the ns_db API I am used to. I also looked at OSSWEB, but it brings with itself a whole bunch of baggage that I'm not ready for, e.g. ossweb::util::parse_args ... |
From: Vlad S. <vl...@cr...> - 2006-07-23 01:10:12
|
I agree, actually i have foreach command in OSSWEB and i do not know why it is not included in to nstk, let me add it. Also, tell me if what kind of functionality you would like to see in nstk without make it bloated or big. I know it is very limited, that was the goal. I am familiar with OpenACS and i created nstk for only reason not to add any additional baggage so it can be used standalone with no dependencies. Of course it is mutual to having full-blown system like OpenACS. > > Vlad, > I am familiar with OpenACS database API. I am used to it. nstk is > very limited as a database API - it is intended to output to a > template, so, for example, it's missing a db_foreach sort of > functionality. I didn't say it is terrible - I said it hasn't been > terrible working with it - but not nearly as pleasant as the ns_db API > I am used to. I also looked at OSSWEB, but it brings with itself a > whole bunch of baggage that I'm not ready for, e.g. > ossweb::util::parse_args ... > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > naviserver-devel mailing list > nav...@li... > https://lists.sourceforge.net/lists/listinfo/naviserver-devel > -- Vlad Seryakov 571 262-8608 office vl...@cr... http://www.crystalballinc.com/vlad/ |
From: Mike <nee...@gm...> - 2006-07-23 01:28:22
|
On 7/22/06, Vlad Seryakov <vl...@cr...> wrote: > I agree, actually i have foreach command in OSSWEB and i do not know why > it is not included in to nstk, let me add it. Also, tell me if what kind > of functionality you would like to see in nstk without make it bloated > or big. I know it is very limited, that was the goal. > > I am familiar with OpenACS and i created nstk for only reason not to add > any additional baggage so it can be used standalone with no > dependencies. Of course it is mutual to having full-blown system like > OpenACS. It is not clear to me that it makes sense to enhance nstk if Stephen is working on something similar. I think a consensus on the "one true direction" should be made and efforts placed into it. Do you agree? |