Re: .NET or Mono functions in PG - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: .NET or Mono functions in PG
Date
Msg-id 20071130151926.GB22321@svr2.hagander.net
Whole thread Raw
In response to .NET or Mono functions in PG  ("Gevik Babakhani" <pgdev@xs4all.nl>)
Responses Re: .NET or Mono functions in PG
Re: .NET or Mono functions in PG
List pgsql-hackers
On Fri, Nov 30, 2007 at 02:31:44PM +0100, Gevik Babakhani wrote:
> 
> I am investigating the possibility of having stored procedures
> and functions written in .NET language flavors. I remember a long time
> ago there was a gborg project wanting to implement it, but that is long 
> gone I guess. anyway....
> 
> I think there are two possibilities:
> 
> a) Use of MS.NET core and implement it only for Windows. 
> b) Use of Mono core and have the possibility to run it also on *nix systems.
> c) Or perhaps a hybrid of the above would be possible.
> 
> Any implementation would require to invoke/call an external runtime (Mono or
> MS.CRL).
> I wonder what the performance would be.
> 
> I would like to have your opinion about this idea. 

I did look at this at some earlier point as well. One big problem at that
time was that once you embedded mono, yuo had all sorts of threads running
in your backend ;-)

Another way to do it is "the PL/J" way (I think). Which is starting up a
separate process with the VM in it and then do RPC of some kind to it.
Which has more overhead per call, but lower per backend etc. And a lot less
"dangerous".

I never got past the thinking stage though. But it would certanily be nice
to have!

//Magnus


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Release Note Changes
Next
From: Tom Lane
Date:
Subject: Re: Release Note Changes