IDEAS

Ways to get Parrot in your Postgres database:

* Embedd One VM per postgres backend
    ** load via a shared library (.so or .dylib)
* pure NCI

Notes for the PostgreSQL side:

* PL/LOLCODE http://pgfoundry.org/projects/pllolcode/

* http://www.postgresql.org/docs/8.4/static/xfunc-c.html

* http://www.postgresql.org/docs/8.4/static/plhandler.html

* http://developer.postgresql.org/pgdocs/postgres/parser-stage.html

* http://www.postgresonline.com/journal/index.php?/archives/6-Language-Architecture-in-PostgreSQL.html

Notes for the Parrot side:

* mod_parrot http://www.parrot.org/mod_parrot

* Parrot Core Embedding Docs: http://docs.parrot.org/parrot/latest/html/docs/pdds/draft/pdd10_embedding.pod.html

Other random semi-related stuff

* PL/R http://www.joeconway.com/plr/

* PL/Scheme http://plscheme.projects.postgresql.org/

* R in Postgres: http://www.omegahat.org/RSPostgres/

Things we'll need to build:
1) A C-based shared object containing at minimum a "language handler" function.
This is what PostgreSQL calls when trying to execute a PL/Parrot function, and
it's responsible for invoking the interpreter. This will probably be called
plparrot.so

2) Some sort of module PL/Parrot functions can import which will allow them to
talk to the database.

There will be some interesting interaction, perhaps, between these two modules.
The handler function is the only one that will have capacity to talk to the
database (barring opening a new connection to the database from Parrot, but
that would obviate the benefits of a procedural language). Presumably the .so
will need to export functions to the module to allow it to get to the database.

The first step in all this is to get the handler function working, so you can
run Parrot routines that don't access the database, you can pass them data, and
they can return data. Second will be to make the database interaction module
work.

Update:
01:54   eggyknap  : So presumably we can write, in nqp-rx, something that can export some functions and be loaded by any function written in a 
                    language parrot understands... and presumably those exported functions can actually wrap C code we'll write in the C bits 
                    of pl/parrot?
01:54   dukeleto  : eggyknap: that sounds about right
01:55   dukeleto  : eggyknap: please write that down somewhere :)
01:55   eggyknap  : Sweet... 'cuz that's how it's gotta work, AFAICS.