Обсуждение: Question About PostgreSQL Extensibility

On Thu, 2023-10-12 at 06:09 +0000, Sepideh Eidi wrote:
> 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. Would you please tell me that .net
> assemblies files are executable in PostgreSQL or not? Or is there any way for calling
> assembly methods inside DB?

There is no support for that.  I guess somebody could write an extension PL/net,
and it looks like somebody already has: https://github.com/witblitz/pldotnet.
That code ptobably won't work with recent PostgreSQL releases, but it could be
a basis for you to work upon.

My big question for me is: Why on earth would you want to run .NET code inside a
database?  Why not run it on the client?

Yours,
Laurenz Albe

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

v. G.,
Ilya





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

For the same reason that you can use python or perl in postgresql. It's just another language.
I have .net code running on several sql servers and to change the database to postgresql I have to reprogram them.

 On Thursday, October 12, 2023 at 09:44:08 AM GMT-4, Laurenz Albe <laurenz.albe@cybertec.at> wrote:

 On Thu, 2023-10-12 at 06:09 +0000, Sepideh Eidi wrote:
> 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. Would you please tell me that .net
> assemblies files are executable in PostgreSQL or not? Or is there any way for calling
> assembly methods inside DB?

There is no support for that.  I guess somebody could write an extension PL/net,
and it looks like somebody already has: https://github.com/witblitz/pldotnet.
That code ptobably won't work with recent PostgreSQL releases, but it could be
a basis for you to work upon.

My big question for me is: Why on earth would you want to run .NET code inside a
database?  Why not run it on the client?

Yours,
Laurenz Albe

On Fri, 2023-10-13 at 13:55 +0000, felix.quintgz@yahoo.com wrote:
> For the same reason that you can use python or perl in postgresql. It's just another language.
> I have .net code running on several sql servers and to change the database to postgresql I have to reprogram them.

Yes, you'll have to rewrite them.

Yours,
Laurenz Albe