On Thu, Oct 12, 2023 at 10:09 PM Ilya Kosmodemiansky <ik@xxxxxxxxxxxxx> wrote:
Hi Sepideh,
> From: Sepideh Eidi <eidi@xxxxxx>
> Date: Thu, Oct 12, 2023 at 2:35 PM
> Subject: Question About PostgreSQL Extensibility
> To: pgsql-general@xxxxxxxxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
> 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).
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.
