Hey, On 3/30/08, Geoff Norton <[EMAIL PROTECTED]> 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/
_______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
