Feature Suggestion: PL/Js

On Wed, 2009-10-07 at 15:00 +0700, Kiswono Prayogo wrote:

by using latest v8 engine from google, is it possible to build PL/Js
just like other PL in Postgre? such as PL/PHP
what should i learn if i want to build PL/Js?

Start here:

http://developer.postgresql.org/pgdocs/postgres/plhandler.html

I notice that this has not been updated for the new inline handlers, but
that shouldn't stop you.

Kiswono Prayogo escribi�:

by using latest v8 engine from google, is it possible to build PL/Js
just like other PL in Postgre? such as PL/PHP
what should i learn if i want to build PL/Js?

I think Josh Tolley has some slides on how we built PL/LOLCODE that
could prove useful.

BTW I've seen requests for PL/Js so I'm sure it'll be welcome. What
license is v8 under?

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

I think Josh Tolley has some slides on how we built PL/LOLCODE that
could prove useful.

BTW I've seen requests for PL/Js so I'm sure it'll be welcome. What
license is v8 under?

the new BSD License

http://code.google.com/p/v8/

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
%s is too gigantic of an industry to bend to the whims of reality

Alvaro Herrera wrote:

Kiswono Prayogo escribi�:

by using latest v8 engine from google, is it possible to build PL/Js
just like other PL in Postgre? such as PL/PHP
what should i learn if i want to build PL/Js?

I think Josh Tolley has some slides on how we built PL/LOLCODE that
could prove useful.

BTW I've seen requests for PL/Js so I'm sure it'll be welcome. What
license is v8 under?

It's a BSD license, but it's a C++ API. While it looks cool, I think
SpiderMonkey is possibly a better bet.

cheers

andrew

On Wed, Oct 07, 2009 at 10:22:02AM -0400, Alvaro Herrera wrote:

Kiswono Prayogo escribió:

by using latest v8 engine from google, is it possible to build PL/Js
just like other PL in Postgre? such as PL/PHP
what should i learn if i want to build PL/Js?

I think Josh Tolley has some slides on how we built PL/LOLCODE that
could prove useful.

Said slides are available here:
http://www.pgcon.org/2009/schedule/events/159.en.html

I hope they can be useful.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

Joshua Tolley escribi�:

On Wed, Oct 07, 2009 at 10:22:02AM -0400, Alvaro Herrera wrote:

Kiswono Prayogo escribi�:

by using latest v8 engine from google, is it possible to build PL/Js
just like other PL in Postgre? such as PL/PHP
what should i learn if i want to build PL/Js?

I think Josh Tolley has some slides on how we built PL/LOLCODE that
could prove useful.

Huh, I didn't mean "we built" but "he built"!

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

On Oct 7, 2009, at 7:55 AM, Andrew Dunstan wrote:

BTW I've seen requests for PL/Js so I'm sure it'll be welcome. What
license is v8 under?

It's a BSD license, but it's a C++ API. While it looks cool, I think
SpiderMonkey is possibly a better bet.

SquirrelFish? http://webkit.org/blog/189/announcing-squirrelfish/

Best,

David

On Wed, Oct 7, 2009 at 5:00 AM, Kiswono Prayogo <kiswono@gmail.com> wrote:

by using latest v8 engine from google, is it possible to build PL/Js
just like other PL in Postgre? such as PL/PHP
what should i learn if i want to build PL/Js?
thanks in advance.

regards,
Kis
GB

You also can see this link:

http://xen.samason.me.uk/~sam/repos/pljs/README

--
Marcelo Costa
www.marcelocosta.net
-------------------------------------------------
“You can't always get what want”,

Doctor House in apology to Mike Jagger

On Wed, Oct 07, 2009 at 11:29:15AM -0400, Alvaro Herrera wrote:

Joshua Tolley escribió:

On Wed, Oct 07, 2009 at 10:22:02AM -0400, Alvaro Herrera wrote:

Kiswono Prayogo escribió:

by using latest v8 engine from google, is it possible to build PL/Js
just like other PL in Postgre? such as PL/PHP
what should i learn if i want to build PL/Js?

I think Josh Tolley has some slides on how we built PL/LOLCODE that
could prove useful.

Huh, I didn't mean "we built" but "he built"!

I didn't feel like you were stealing credit. I certainly couldn't have built
it, such as it is, without support from -hackers. :)

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

Said slides are available here:
http://www.pgcon.org/2009/schedule/events/159.en.html

I hope they can be useful.

--
Joshua Tolley / eggyknap

ok i will read it, thanks ^^

On Wed, Oct 7, 2009 at 11:18 PM, David E. Wheeler <david@kineticode.com> wrote:

On Oct 7, 2009, at 7:55 AM, Andrew Dunstan wrote:

BTW I've seen requests for PL/Js so I'm sure it'll be welcome.  What
license is v8 under?

It's a BSD license, but it's a C++ API. While it looks cool, I think
SpiderMonkey is possibly a better bet.

SquirrelFish? http://webkit.org/blog/189/announcing-squirrelfish/

Best,

David

i guess v8 still the best javascript interpreter
http://waynepan.com/2008/09/02/v8-tracemonkey-squirrelfish-ie8-benchmarks/
nitro from apple safari would be the second best..
http://www.computerworld.com/s/article/9128638/Safari_4_rivals_Google_Chrome_in_JavaScript_race?intsrc=news_ts_head
but possibly that benchmark is not really valid because it also
benchmark the rendering..

On Wed, Oct 7, 2009 at 11:38 PM, Marcelo Costa <marcelojscosta@gmail.com> wrote:

On Wed, Oct 7, 2009 at 5:00 AM, Kiswono Prayogo <kiswono@gmail.com> wrote:

by using latest v8 engine from google, is it possible to build PL/Js
just like other PL in Postgre? such as PL/PHP
what should i learn if i want to build PL/Js?
thanks in advance.

regards,
Kis
GB

You also can see this link:

http://xen.samason.me.uk/~sam/repos/pljs/README

--
Marcelo Costa
www.marcelocosta.net
-------------------------------------------------
“You can't always get what want”,

Doctor House in apology to Mike Jagger

hmm.. someone has built it first, i'll try it in the moment ^^

On Thu, 2009-10-08 at 07:06 +0700, Kiswono Prayogo wrote:

Said slides are available here:
http://www.pgcon.org/2009/schedule/events/159.en.html

I hope they can be useful.

--
Joshua Tolley / eggyknap

ok i will read it, thanks ^^

And video:

http://www.vimeo.com/3728119

Joshua D. Drake

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander

Kiswono Prayogo escribi�:

i guess v8 still the best javascript interpreter
http://waynepan.com/2008/09/02/v8-tracemonkey-squirrelfish-ie8-benchmarks/
nitro from apple safari would be the second best..
http://www.computerworld.com/s/article/9128638/Safari_4_rivals_Google_Chrome_in_JavaScript_race?intsrc=news_ts_head
but possibly that benchmark is not really valid because it also
benchmark the rendering..

Performance is not the only useful measure. Embeddability in Postgres
is very important, and it being C++ is not a good starting point.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Peter Eisentraut <peter_e@gmx.net> writes:

Start here:
http://developer.postgresql.org/pgdocs/postgres/plhandler.html
I notice that this has not been updated for the new inline handlers, but
that shouldn't stop you.

Actually, that chapter is so old it didn't get updated for language
validators either :-(. I added some text, and changed the link in
create_language.sgml so hopefully we'll notice it next time.

regards, tom lane