Re: PostgreSQL and .NET - Mailing list pgsql-general

From Magnus Hagander
Subject Re: PostgreSQL and .NET
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C71CA@algol.sollentuna.se
Whole thread Raw
In response to PostgreSQL and .NET  ("Stanislaw Tristan" <stas775@i.com.ua>)
List pgsql-general
>>>>> If there was idea to implement a .NET support in Windows
>version of PostgreSQL? Like existing Pl/Java
>>>>
>>>> We have a .Net client.  You want server-side .Net?  No one has ever
>>>> talked about that, sorry.
>>>
>>> not knowin gmuch about .Net ... what is a 'server-side
>.Net'?  Like a
>>> PL/.Net?
>>
>> Yea, I assume so. If we can do server-side Java, I assume we could do
>> server-side .Net if someone wanted to code it.  Of course it would be
>> Win32-only, unless we used Mono for Unix.
>
From the Mono web site:
>
>"Mono can run existing programs targeting the .NET or Java frameworks."
>
>does this mean that something written for Java (or .Net) could
>be compiled without mods?

No need to recompile, just run it. While it feels a bit weird, running
"./foo.exe" works just fine (assuming you've configured the "misc binary
executor" or wahtever it's called to identify a mono executable -
otherwise, run "mono foo.exe"). Compiled with Visual Studio on Windows,
just copy over the .EXE. The same should work for Java, but the support
is not as complete in the class libraries, AFAIK.

PL/mono would be very nice. You can write in C#, Java, C++, VB(yuck),
JScript etc from MS product, and there is definitly a python
implementation out there. There are commercial implementations that let
you do Cobol, if you're really crazy ;-)
It would also provide a nice migration / co-existance with MS SQL 2005
which has it, and I beleive the new DB2 versions (on windows) also have
stored procs in .NET.

As .net is fairly similar to the JVM in architecture, it would probably
be about as much work as PL/J[ava]. Which is quite a bit of work. I have
no idea if anything can just be "stolen" from the PL/J[ava] projects...

//Magnus

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: do I need replication or something else?
Next
From: Michelle Konzack
Date:
Subject: Re: How to query pgsql from a BASH script ?