Re: Javascript support in the backend, i.e. PL/JS

Sam Mason <sam(at)samason(dot)me(dot)uk> writes:
> For SPI, I'm thinking that I'd currently like to attempt some object
> orientated style interface. ...
> So running some SQL would probably look something like:

> for (row in spi.prepare("SELECT 1 AS n").query()) {
> print(row.n);
> }

What's not apparent to me is how one can avoid re-planning the query
every single time the function is called?

More generally, I think that the average programmer would rather just
not be bothered with all these details; he'd want to write

for (row in spi.query("...sql..." [, arguments])) { ...

I don't object to exposing the machinery for those who like to play with
such stuff, but you should have shortcuts to keep the simple things
simple.

regards, tom lane