Re: Ajax/PostgreSQL

From: "Gavin M(dot) Roy" <gmr(at)ehpg(dot)net>
To: Paul M Foster <paulf(at)quillandmouse(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Ajax/PostgreSQL
Date: 2006-08-05 23:32:50
Message-ID: 45F06348-C5E4-465C-996C-0AED502E1F83@ehpg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The way to handle this is to make your ajax call PHP scripts which
handle your data and return your XML for the Javascript (or HTML).

AJAX makes HTTP requests, it does not talk directly to the database
server.

In essence to do what you're asking you would need a JavaScript
implementation of the pgsql protocol. This would at the *very* least
make for the possibility of security issues with your database
backend, where every client hitting your website would need to be
able to access it.

Hope this helps,

Gavin

On Aug 5, 2006, at 3:42 PM, Paul M Foster wrote:

> I'm doing some massive (internal company) applications using PHP,
> which query extensive PostgreSQL tables. This is fine, but
> obviously it often requires multiple web pages to get something
> done. Supposedly, AJAX promises to make web pages more interactive.
> But from what I understand, I'd have to have bindings from
> Javascript into PostgreSQL to make this work.
>
> Here's an example: The user wants to enter a bill (accounts
> payable) into the system. He first has to pick a vendor. Normally,
> this would entail a PHP page that generates a PostgreSQL query. The
> user would then get a second page with various vendor information
> (like number of due days for that vendor), and various other
> payable info. But wouldn't it be nice to have vendor information
> filled in on the original page, directly after the user picks a
> vendor? Theoretically, AJAX might allow something like this. But
> from what I can see, it would require PostgreSQL bindings in
> Javascript, and some way to pass the data back so that PHP could
> use it.
>
> Is this even possible? Is it being worked on? Is there a different
> solution I don't know about? I can see where Javascript can alter
> the look of a page, but I can't work out how it would allow
> interactive use of a PostgreSQL table.
>
> --
> Paul M. Foster
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Wilson 2006-08-05 23:36:56 Re: Ajax/PostgreSQL
Previous Message Tyler MacDonald 2006-08-05 23:32:27 Re: Ajax/PostgreSQL