Обсуждение: LiveWire Javascript and PGSQL
Has anyone tried LiveWire (any version) against a PQSQL database? ___________________________________________________ Roeland M.J. Meyer, ISOC (InterNIC RM993) e-mail: <mailto:rmeyer@mhsc.com>rmeyer@mhsc.com Internet phone: hawk.mhsc.com Personal web pages: <http://www.mhsc.com/~rmeyer>www.mhsc.com/~rmeyer Company web-site: <http://www.mhsc.com/>www.mhsc.com/ ___________________________________________ I bet the human brain is a kludge. -- Marvin Minsky
At 22:56 +0200 on 15/10/98, Roeland M.J. Meyer wrote: > Has anyone tried LiveWire (any version) against a PQSQL database? PostgreSQL is not one of the native databases supported by LiveWire. The only conceivable way of connecting to PostgreSQL from LiveWire is through ODBC. Since most of us use unix, usually our web servers are also unix-based, not NT-based (yuck). So it would mean using unix-based ODBC. The problem here is that the ODBC driver for unix is really not a mature product. There have been tests and improvements over the last couple of months but I for one don't feel confident about installing iODBC, the postODBC driver, and the mysterious configuration files just as yet. If you feel up to the challenge, I'll be glad to hear whether you have succeeded - especially if you happen to be working on a Solaris sparc (2.5.1 or 2.6). Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma
At 11:49 AM 10/18/98 +0200, Herouth Maoz wrote: >At 22:56 +0200 on 15/10/98, Roeland M.J. Meyer wrote: > > >> Has anyone tried LiveWire (any version) against a PQSQL database? > >PostgreSQL is not one of the native databases supported by LiveWire. The >only conceivable way of connecting to PostgreSQL from LiveWire is through >ODBC. As I'm just finding out <sigh>. >Since most of us use unix, usually our web servers are also unix-based, not >NT-based (yuck). So it would mean using unix-based ODBC. We're moving off of a WnNT machine to COL Linux-ELF. NT is beyond (yuck) for production use. We've been trying it, NFG, too many show-stoppers! At this moment, I am investigating the SCO Livewire wrt installing it on Linux via iBCS. If I can't get it to work with Caldera FastTrack then I'll try SCO FastTrack. Maybe I'll learn enough to get it working with Apache-Ben-SSL (mod_livewire ?<grin>?). >The problem here is that the ODBC driver for unix is really not a mature >product. There have been tests and improvements over the last couple of >months but I for one don't feel confident about installing iODBC, the >postODBC driver, and the mysterious configuration files just as yet. I got postODBC under WinNT. Where can I get iODBC? My alternative here is to scrap 5 months of JavaScript code and do a re-write in g++. >If you feel up to the challenge, I'll be glad to hear whether you have >succeeded - especially if you happen to be working on a Solaris sparc >(2.5.1 or 2.6). Caldera Linux with v2.0.35 kernel upgrades (Linux Enterprise Server prototype). ___________________________________________________ Roeland M.J. Meyer, ISOC (InterNIC RM993) e-mail: <mailto:rmeyer@mhsc.com>rmeyer@mhsc.com Internet phone: hawk.mhsc.com Personal web pages: <http://www.mhsc.com/~rmeyer>www.mhsc.com/~rmeyer Company web-site: <http://www.mhsc.com/>www.mhsc.com/ ___________________________________________ I bet the human brain is a kludge. -- Marvin Minsky
> >> Has anyone tried LiveWire (any version) against a PQSQL database?
> We're moving off of a WnNT machine to COL Linux-ELF.
> >The problem here is that the ODBC driver for unix is really not a
> >mature product. There have been tests and improvements over the last
> >couple of months but I for one don't feel confident about installing
> >iODBC, the postODBC driver, and the mysterious configuration files
> >just as yet.
Ah, no faith eh?! We are testing iODBC/psqlODBC under Linux using the
new ApplixWare and it is going fine so far. I should be posting a
standalone beta tarball with docs on postgresql.org in the next few
hours unless I get held up for some reason, in which case it would
happen Thursday (I'm out of town tomorrow).
> I got postODBC under WinNT. Where can I get iODBC? My alternative here
> is to scrap 5 months of JavaScript code and do a re-write in g++.
The psqlODBC driver from www.insightdist.com is the basis for our
current integration work, but the changes we have made to run under Unix
have not yet been moved back into the insightdist tree. So, if you are
on Unix, use our beta or the source tree coming with Postgres-6.4.
I would think that even if there are a few problems you would do better
working them out with the psqlODBC driver rather than losing 5 months of
coding. We're not aware of any specific problems though so you should
just try it!
> (Using) Caldera Linux with v2.0.35 kernel upgrades (Linux Enterprise
> Server prototype).
You should be golden. I'm running RH4.2 with kernel-2.0.30, which is
very similar to the Caldera distribution I recall.
I will post an announcement on the interfaces mailing list, and Cary
O'Brien will likely do the same on the applix.com mailing list.
- Tom
At 01:08 AM 10/21/98 +0000, Thomas G. Lockhart wrote: >> I got postODBC under WinNT. Where can I get iODBC? My alternative here >> is to scrap 5 months of JavaScript code and do a re-write in g++. > >The psqlODBC driver from www.insightdist.com is the basis for our >current integration work, but the changes we have made to run under Unix >have not yet been moved back into the insightdist tree. So, if you are >on Unix, use our beta or the source tree coming with Postgres-6.4. > >I would think that even if there are a few problems you would do better >working them out with the psqlODBC driver rather than losing 5 months of >coding. We're not aware of any specific problems though so you should >just try it! My thinking exactly! Messing with this now is cheaper than re-writting code, if it works. >> (Using) Caldera Linux with v2.0.35 kernel upgrades (Linux Enterprise >> Server prototype). > >You should be golden. I'm running RH4.2 with kernel-2.0.30, which is >very similar to the Caldera distribution I recall. The Caldera distro was originally based on RedHat and still has a *lot* of RedHatisms in it. However, RedHat rpms don't quite work on the Caldera directory structure. MHSC takes Caldera as a base-line and adds in a *ton* of stuff to build our Linux Enterprise Server (LES). It's kind of like turning a Lotus into a Peterbuilt , or Cosworth building truck engines <grin>. >I will post an announcement on the interfaces mailing list, and Cary >O'Brien will likely do the same on the applix.com mailing list. I'd appreaciate a file-attached tar.gz lacking that a URL of where to fetch it from would be greatly appreciated. Where do I send the pizza? ___________________________________________________ Roeland M.J. Meyer, ISOC (InterNIC RM993) e-mail: <mailto:rmeyer@mhsc.com>rmeyer@mhsc.com Internet phone: hawk.mhsc.com Personal web pages: <http://www.mhsc.com/~rmeyer>www.mhsc.com/~rmeyer Company web-site: <http://www.mhsc.com/>www.mhsc.com/ ___________________________________________ I bet the human brain is a kludge. -- Marvin Minsky