Re: Question About PostgreSQL Extensibility

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Re: Question About PostgreSQL Extensibility
Дата
Msg-id CAKt_ZfsBo=BJgvONP_1uoSz1waFY=Wh7BbDLXF-HuP+Cxb_UoQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question About PostgreSQL Extensibility  (Ilya Kosmodemiansky <ik@dataegret.com>)
Список 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 по дате отправления:

Предыдущее
От: Ilya Kosmodemiansky
Дата:
Сообщение: Re: Question About PostgreSQL Extensibility
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Can not drop partition if exist foreign keys