[Mono-list] GSoC Proposal: PL/Mono

[Robert Jordan]

Olexandr Melnyk wrote:
> 
> 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?

The runtime should be initialized once.

> 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?

Let's have a look at PL/Java's code: it comes with its own JDBC
driver around Pg's SPI API. This probably means that there is no
no way to pass a connection from inside a procedure to a driver.
Same for PL/Perl.

You may want to ask this question on PostgreSQL's mailing lists
as well.

Robert