Thread: postgreSQL and javascript

postgreSQL and javascript

From
"Andrew Dellinger"
Date:
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

Re: postgreSQL and javascript

From
George Koras
Date:
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






RE: postgreSQL and javascript

From
Peter Mount
Date:
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 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

Re: postgreSQL and javascript

From
"Adam Lang"
Date:
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
>
>



RE: postgreSQL and javascript

From
Peter Mount
Date:
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
> >
> >
> 


RE: postgreSQL and javascript

From
Bob Kline
Date:
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



Re: postgreSQL and javascript

From
"Adam Lang"
Date:
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



Re: postgreSQL and javascript

From
"Neil P Davis"
Date:
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 -----
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
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

Re: postgreSQL and javascript

From
"Adam Lang"
Date:
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




Re: postgreSQL and javascript

From
Joseph Shraibman
Date:
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


RE: postgreSQL and javascript

From
Peter Mount
Date:
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
> 


RE: postgreSQL and javascript

From
Tim Uckun
Date:
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.