Re: 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(at)postgresql(dot)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(at)maidstone(dot)gov(dot)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(at)mindspring(dot)com]
Sent: Tuesday, November 28, 2000 4:17 AM
To: pgsql-interfaces(at)postgresql(dot)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