[Mono-list] GSoC Proposal: PL/Mono

[Olexandr Melnyk]

Hey,

On 3/30/08, Geoff Norton <gnorton at novell.com> wrote:

> Him
>
>
> On 29-Mar-08, at 10:20 AM, Olexandr Melnyk wrote:
>
> > I'm interested in applying for this year's GSoC program, to work on
> > PL/Mono: pluggable procedural language for PostgreSQL. The main
> > purpose of the project is to allow programmers to write stored
> > procedures for PostgreSQL database in one of the languages that are
> > supported by Mono platform (similar to how they can do it with PL/
> > Perl and PL/Python).
> >
>
>
> This sound like a GREAT idea.  I actually looked into this and its
> definatley a mature enough interface/project now.
>
>
> > As I remember from the past, such attempt already existed and was
> > hosted at pgFoundry, but I can't find any files related to it. Does
> > anyone know about its status?
> >
>
>
> Its dead in the water and never proceeded beyond a very brief proof of
> concept.
>
>
> > I would also like to hear some feedback about the idea (and its
> > usefulness) in general.
> >
>
>
> I think its a fantastic idea.  Can you make sure you submit an
> application to google before the deadline?  Please follow their
> guidelines and make sure you include a projected timeline of
> milestones and how you think the summer would proceed.


There are several potential problems I don't know how to solve yet.

First one is combining PostgreSQL's multi-process
nature with Mono. Should Mono runtime be initialised every time a (Mono-based)
stored procedure is invoked in PostgreSQL? How good will this work
from performance stand point?

Second one is handling transactions. If we want to allow sending
queries back to
the database from managed code, one way would be to create a connection in
the opposite
direction. However, this will not work with transactions as two
connections are isolated from each
other. Another possible solution is to pass connection resource from
PostgreSQL through PL/Mono to managed code, and ask ADO.NET to reuse it.
Any thoughts on this?

Thanks!

Thanks!
>
>
> -geoff
>
>


-- 
Sincerely yours,
Olexandr Melnyk <><
http://omelnyk.net/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20080331/de75121b/attachment.html