Thread: postgreSQL and javascript
Is it possible to connect to postgreSQL using JavaScript? If so, how? I have been
reading a lot about JDBC, but it has all java examples.
Thanks,
Andrew Dellinger
How about the LiveWire Database Service: http://developer.netscape.com/docs/manuals/communicator/jsref/lw.htm Is anyone using it? Any comments? Andrew Dellinger wrote: > Is it possible to connect to postgreSQL using JavaScript? If so, how? > I have beenreading a lot about JDBC, but it has all java > examples. Thanks,Andrew Dellinger
No. Javascript is nothing to do with Java (the similar names confuse a lot of people), and Javascript is a simple scripting language running within the browser.
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@maidstone.gov.uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough Council
-----Original Message-----
From: Andrew Dellinger [mailto:aedellin@mindspring.com]
Sent: Tuesday, November 28, 2000 4:17 AM
To: pgsql-interfaces@postgresql.org
Subject: [INTERFACES] postgreSQL and javascriptIs it possible to connect to postgreSQL using JavaScript? If so, how? I have beenreading a lot about JDBC, but it has all java examples.Thanks,Andrew Dellinger
Tell me about it. More often than not, I wish they'd change the damn name of it. Call it Netscript or something. Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Peter Mount" <petermount@maidstone.gov.uk> To: "'Andrew Dellinger'" <aedellin@mindspring.com>; <pgsql-interfaces@postgresql.org> Sent: Tuesday, November 28, 2000 3:55 AM Subject: RE: [INTERFACES] postgreSQL and javascript > No. Javascript is nothing to do with Java (the similar names confuse a lot > of people), and Javascript is a simple scripting language running within the > browser. > > Peter > > -- > Peter Mount > Enterprise Support Officer, Maidstone Borough Council > Email: petermount@maidstone.gov.uk > WWW: http://www.maidstone.gov.uk <http://www.maidstone.gov.uk/> > All views expressed within this email are not the views of Maidstone Borough > Council > > -----Original Message----- > From: Andrew Dellinger [mailto:aedellin@mindspring.com] > Sent: Tuesday, November 28, 2000 4:17 AM > To: pgsql-interfaces@postgresql.org > Subject: [INTERFACES] postgreSQL and javascript > > > Is it possible to connect to postgreSQL using JavaScript? If so, how? I have > been > reading a lot about JDBC, but it has all java examples. > > Thanks, > Andrew Dellinger > >
They have some time ago, just no one's picked up on it - EMCEA (may have the wrong spelling). Peter -- Peter Mount Enterprise Support Officer, Maidstone Borough Council Email: petermount@maidstone.gov.uk WWW: http://www.maidstone.gov.uk All views expressed within this email are not the views of Maidstone Borough Council > -----Original Message----- > From: Adam Lang [mailto:aalang@rutgersinsurance.com] > Sent: Tuesday, November 28, 2000 1:50 PM > To: pgsql-interfaces@postgresql.org > Subject: Re: [INTERFACES] postgreSQL and javascript > > > Tell me about it. More often than not, I wish they'd change > the damn name > of it. Call it Netscript or something. > > Adam Lang > Systems Engineer > Rutgers Casualty Insurance Company > ----- Original Message ----- > From: "Peter Mount" <petermount@maidstone.gov.uk> > To: "'Andrew Dellinger'" <aedellin@mindspring.com>; > <pgsql-interfaces@postgresql.org> > Sent: Tuesday, November 28, 2000 3:55 AM > Subject: RE: [INTERFACES] postgreSQL and javascript > > > > No. Javascript is nothing to do with Java (the similar > names confuse a lot > > of people), and Javascript is a simple scripting language > running within > the > > browser. > > > > Peter > > > > -- > > Peter Mount > > Enterprise Support Officer, Maidstone Borough Council > > Email: petermount@maidstone.gov.uk > > WWW: http://www.maidstone.gov.uk <http://www.maidstone.gov.uk/> > > All views expressed within this email are not the views of Maidstone > Borough > > Council > > > > -----Original Message----- > > From: Andrew Dellinger [mailto:aedellin@mindspring.com] > > Sent: Tuesday, November 28, 2000 4:17 AM > > To: pgsql-interfaces@postgresql.org > > Subject: [INTERFACES] postgreSQL and javascript > > > > > > Is it possible to connect to postgreSQL using JavaScript? > If so, how? I > have > > been > > reading a lot about JDBC, but it has all java examples. > > > > Thanks, > > Andrew Dellinger > > > > >
On Tue, 28 Nov 2000, Peter Mount wrote: > They have some time ago, just no one's picked up on it - EMCEA (may > have the wrong spelling). Well, sort of. ECMAScript [1] is a standard of which JavaScript is the most popular implementation. Good luck getting the name replaced. In light of the opportunity for JavaScript developers to capitalize on the confusion, which would tend to boost the perceived worth of their resumes in the eyes of the confused, I don't predict much chance of success for a name change. But perhaps I'm being too cynical. :->} [1] ftp://ftp.ecma.ch/ecma-st/Ecma-262.pdf -- Bob Kline mailto:bkline@rksystems.com http://www.rksystems.com
No, you probably have it exactly correct... Just like peter said though, people using the names interchangeably is aggravating. Of course, no offense to anyone on the list, when you are in conversation with someone and they do that, you get a good idea of actually what they know then. That is one of my first signs to discount someone as a valid source. You know the ad campaign: "Pork. The other white meat"? Maybe their should be one for Java: "Java. Has nothing to do with the script." Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Bob Kline" <bkline@rksystems.com> To: "Peter Mount" <petermount@maidstone.gov.uk> Cc: "'Adam Lang'" <aalang@rutgersinsurance.com>; <pgsql-interfaces@postgresql.org> Sent: Tuesday, November 28, 2000 9:54 AM Subject: RE: [INTERFACES] postgreSQL and javascript > On Tue, 28 Nov 2000, Peter Mount wrote: > > > They have some time ago, just no one's picked up on it - EMCEA (may > > have the wrong spelling). > > Well, sort of. ECMAScript [1] is a standard of which JavaScript is the > most popular implementation. Good luck getting the name replaced. In > light of the opportunity for JavaScript developers to capitalize on the > confusion, which would tend to boost the perceived worth of their > resumes in the eyes of the confused, I don't predict much chance of > success for a name change. But perhaps I'm being too cynical. :->} > > [1] ftp://ftp.ecma.ch/ecma-st/Ecma-262.pdf > > -- > Bob Kline > mailto:bkline@rksystems.com > http://www.rksystems.com
Hello,
Actually javascript is quite capable of running server side too. The capabilities of the implementation depend on platform. While I personally know nothing about connecting javascript to a database, I have seen examples of this in MSDN (Microsoft Developer's Network). This may or may not only be possible on the Microsoft platform with their javascript implementation. Even then, I think it is a server side thing. Though if you can do it on the server, you may be able to do it in the client, at least with IE. I recall seeing something about disconnected recordsets and javascript in a wrox book somewhere....
Don't give up yet. Search on 'disconnected recordset'... Maybe there is a way.
I am of the persuasion that the data should be extracted by the time that javascript is playing with it. Then again, I still have a lot to learn. I usually build my javascript datastructures as the page is being rendered by using either ASP or PHP. Granted, this makes for some cumbersome code, but hey, it is built dynamically and all I need to maintain is the piece of code that generates the mess, not the mess itself : )
About jdbc... It has absolutely nothing to do with javascript. It is for java. JavaDataBaseConnectivity. I agree with Peter and Adam in their assertion that the name for javascript is problematic. People new to programming would benefit from the distinction of a new name.
Check out devedge.netscape.com for a decent javascript reference. If you are new to javascript go to javascript.internet.com and start playing with some working scripts to learn a little about the way the language works. There are tutorials here too. There may or may not be better sites now. These two have gotten me out of any pickle that I have ever confronted.
The most important thing is to first grasp what an object model is, then learn the DOM or Document Object Model (or at least print it out and hang it in your cube, you will need it!). From there you will really be able to impress your friends. Using javascript I have approached the functionality and bells and whistles of thick client Apps (- data access of course!) in a browser. It is very powerful indeed. When combined with ASP or PHP, it is even more so. I don't know how I ever got along without it!
Like everything else, javascript works differently in Netscape than it does in IE. This manifests itself in positioning coordinates (Netscape and IE count pixels from different spots), event handlers (IE Supports tag events that Netscape does not). Most likely, both Netscape and Microsoft's CEOs will go to hell for all the hours of developer torture caused by their unwillingness to decide on standards and stick by them. They know what the impact is to millions of developers worldwide, yet they continue. No I don't have a preference, I hate both companies with equal ferocity. Do yourself a favor, debug javascript in Netscape. It is the least common denominator.
thx,
Neil
----- Original Message -----From: Peter MountSent: Tuesday, November 28, 2000 3:55 AMSubject: RE: [INTERFACES] postgreSQL and javascriptNo. Javascript is nothing to do with Java (the similar names confuse a lot of people), and Javascript is a simple scripting language running within the browser.Peter--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@maidstone.gov.uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough Council-----Original Message-----
From: Andrew Dellinger [mailto:aedellin@mindspring.com]
Sent: Tuesday, November 28, 2000 4:17 AM
To: pgsql-interfaces@postgresql.org
Subject: [INTERFACES] postgreSQL and javascriptIs it possible to connect to postgreSQL using JavaScript? If so, how? I have beenreading a lot about JDBC, but it has all java examples.Thanks,Andrew Dellinger
I know what you are talking about. Using javascript server side with ASP. By default, ASP support the use of javascript (or termed by Microsoft as JScript) or vbscript. In all honesty, I don't know anyone that uses javascript with ASP on the server side. And then, I'd assume you have to use ADO to connect to a database. Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Neil P Davis" <npdavis@hotmail.com> To: "Peter Mount" <petermount@maidstone.gov.uk>; "'Andrew Dellinger'" <aedellin@mindspring.com>; <pgsql-interfaces@postgresql.org> Sent: Tuesday, November 28, 2000 10:07 AM Subject: Re: [INTERFACES] postgreSQL and javascript Hello, Actually javascript is quite capable of running server side too. The capabilities of the implementation depend on platform. While I personally know nothing about connecting javascript to a database, I have seen examples of this in MSDN (Microsoft Developer's Network). This may or may not only be possible on the Microsoft platform with their javascript implementation. Even then, I think it is a server side thing. Though if you can do it on the server, you may be able to do it in the client, at least with IE. I recall seeing something about disconnected recordsets and javascript in a wrox book somewhere.... Don't give up yet. Search on 'disconnected recordset'... Maybe there is a way. I am of the persuasion that the data should be extracted by the time that javascript is playing with it. Then again, I still have a lot to learn. I usually build my javascript datastructures as the page is being rendered by using either ASP or PHP. Granted, this makes for some cumbersome code, but hey, it is built dynamically and all I need to maintain is the piece of code that generates the mess, not the mess itself : ) About jdbc... It has absolutely nothing to do with javascript. It is for java. JavaDataBaseConnectivity. I agree with Peter and Adam in their assertion that the name for javascript is problematic. People new to programming would benefit from the distinction of a new name. Check out devedge.netscape.com for a decent javascript reference. If you are new to javascript go to javascript.internet.com and start playing with some working scripts to learn a little about the way the language works. There are tutorials here too. There may or may not be better sites now. These two have gotten me out of any pickle that I have ever confronted. The most important thing is to first grasp what an object model is, then learn the DOM or Document Object Model (or at least print it out and hang it in your cube, you will need it!). From there you will really be able to impress your friends. Using javascript I have approached the functionality and bells and whistles of thick client Apps (- data access of course!) in a browser. It is very powerful indeed. When combined with ASP or PHP, it is even more so. I don't know how I ever got along without it! Like everything else, javascript works differently in Netscape than it does in IE. This manifests itself in positioning coordinates (Netscape and IE count pixels from different spots), event handlers (IE Supports tag events that Netscape does not). Most likely, both Netscape and Microsoft's CEOs will go to hell for all the hours of developer torture caused by their unwillingness to decide on standards and stick by them. They know what the impact is to millions of developers worldwide, yet they continue. No I don't have a preference, I hate both companies with equal ferocity. Do yourself a favor, debug javascript in Netscape. It is the least common denominator. thx, Neil ----- Original Message ----- From: Peter Mount To: 'Andrew Dellinger' ; pgsql-interfaces@postgresql.org Sent: Tuesday,November 28, 2000 3:55 AM Subject: RE: [INTERFACES] postgreSQL and javascript No. Javascript is nothing to do with Java (the similar names confuse a lot of people), and Javascript is a simple scripting language running within the browser. Peter -- Peter Mount Enterprise Support Officer, Maidstone Borough Council Email: petermount@maidstone.gov.uk WWW: http://www.maidstone.gov.ukAll views expressed within this email are not the views of Maidstone Borough Council -----Original Message----- From: Andrew Dellinger [mailto:aedellin@mindspring.com] Sent: Tuesday, November 28, 20004:17 AM To: pgsql-interfaces@postgresql.org Subject: [INTERFACES] postgreSQL and javascript Is it possible to connect to postgreSQL using JavaScript? If so, how? I have been reading a lot about JDBC, but it has all java examples. Thanks, Andrew Dellinger
Actually there is some way to connect javascript to java. I forget how. I looked at it a long time ago and it seemed messy, but then again anything javascript is messy. So you could in theory create a java applet, connect to it with javascript, and get your data. Good luck. -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com
Which is why any webstuff I do these days has as little javascript as possible, and do most of it in php. -- Peter Mount Enterprise Support Officer, Maidstone Borough Council Email: petermount@maidstone.gov.uk WWW: http://www.maidstone.gov.uk All views expressed within this email are not the views of Maidstone Borough Council > -----Original Message----- > From: Joseph Shraibman [mailto:jks@selectacast.net] > Sent: Tuesday, November 28, 2000 11:56 PM > To: Peter Mount > Cc: 'Andrew Dellinger'; pgsql-interfaces@postgresql.org > Subject: Re: [INTERFACES] postgreSQL and javascript > > > Actually there is some way to connect javascript to java. I forget > how. I looked at it a long time ago and it seemed messy, but > then again > anything javascript is messy. So you could in theory create a java > applet, connect to it with javascript, and get your data. > > Good luck. > > > -- > Joseph Shraibman > jks@selectacast.net > Increase signal to noise ratio. http://www.targabot.com >
Follow this url for some ideas you can use to hook up javascript to java and then to some server CGI. http://www.gunther.web66.com/JavaCGIBridge/ At 09:35 AM 11/29/2000 +0000, Peter Mount wrote: >Which is why any webstuff I do these days has as little javascript as >possible, and do most of it in php. > >-- >Peter Mount >Enterprise Support Officer, Maidstone Borough Council >Email: petermount@maidstone.gov.uk >WWW: http://www.maidstone.gov.uk >All views expressed within this email are not the views of Maidstone Borough >Council > > > > -----Original Message----- > > From: Joseph Shraibman [mailto:jks@selectacast.net] > > Sent: Tuesday, November 28, 2000 11:56 PM > > To: Peter Mount > > Cc: 'Andrew Dellinger'; pgsql-interfaces@postgresql.org > > Subject: Re: [INTERFACES] postgreSQL and javascript > > > > > > Actually there is some way to connect javascript to java. I forget > > how. I looked at it a long time ago and it seemed messy, but > > then again > > anything javascript is messy. So you could in theory create a java > > applet, connect to it with javascript, and get your data. > > > > Good luck. > > > > > > -- > > Joseph Shraibman > > jks@selectacast.net > > Increase signal to noise ratio. http://www.targabot.com > > :wq Tim Uckun Due Diligence Inc. http://www.diligence.com/ Americas Background Investigation Expert. If your company isn't doing background checks, maybe you haven't considered the risks of a bad hire.