Re: Question About PostgreSQL Extensibility - Mailing list pgsql-general

From Chris Travers
Subject Re: Question About PostgreSQL Extensibility
Date
Msg-id CAKt_ZfsBo=BJgvONP_1uoSz1waFY=Wh7BbDLXF-HuP+Cxb_UoQ@mail.gmail.com
Whole thread Raw
In response to Re: Question About PostgreSQL Extensibility  (Ilya Kosmodemiansky <ik@dataegret.com>)
List pgsql-general


On Thu, Oct 12, 2023 at 10:09 PM Ilya Kosmodemiansky <ik@dataegret.com> wrote:
Hi Sepideh,

> From: Sepideh Eidi <eidi@rhf.de>
> Date: Thu, Oct 12, 2023 at 2:35 PM
> Subject: Question About PostgreSQL Extensibility
> To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>

> We have some .net assemblies and in your documents, I didn’t find any support for this type of files that is executable in DB or not.

PostgreSQL doesn't support .net assemblies like SQL Server does. In
Postgres you can certainly write stored procedures in different
languages, for example in C, but I am not sure if it would solve your
problem

Also if you are self-hosting, you can write and add your own language handlers.  So if you need to support .Net assemblies, this is at least in theory possible.

Note that there are significant reasons to consider rewriting in other languages, however.  The large one is that .Net prefers a very different threading model than Postgres and so that's something that has to be solved (though the Pl/Java folks have solved that problem for Java). 
 

v. G.,
Ilya





best regards,
Ilya Kosmodemiansky,
CEO, Data Egret GmbH
Herrenstr. 1 A 2,
Spiesen-Elversberg, Germany




--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.

pgsql-general by date:

Previous
From: Ilya Kosmodemiansky
Date:
Subject: Re: Question About PostgreSQL Extensibility
Next
From: Laurenz Albe
Date:
Subject: Re: Can not drop partition if exist foreign keys