pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestion About PostgreSQL Extensibility
7+ messages / 5 participants
[nested] [flat]
* Question About PostgreSQL Extensibility
@ 2023-10-12 06:09 Sepideh Eidi <eidi@rhf.de>
0 siblings, 2 replies; 7+ messages in thread
From: Sepideh Eidi @ 2023-10-12 06:09 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hi madam/sir,
Our company want to use a database for first time, we select PostgreSQL from a list of open-source Databases. But at first, we want to be sure about something. 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?
Best regard,
Sepideh Eidi
Software Development
[cid:image001.png@01D9FCE2.F2F39B40]
REILHOFER KG
Zugspitzstraße 5 - <x-apple-data-detectors://1/1> 85757 Karlsfeld - <x-apple-data-detectors://1/1> Germany<x-apple-data-detectors://1/1>
Tel +49 8131 59295 <tel:+49%208131%2059295%200> 72 - Fax +49 8131 97447<tel:+49%208131%2097447>
eidi@rhf.de<mailto:eidi@rhf.de> - www.rhf.de<http://www.rhf.de/;
[cid:image002.png@01D9FCE2.F2F39B40]<https://www.linkedin.com/company/reilhofer-kg/; [cid:image003.png@01D9FCE2.F2F39B40] <https://www.xing.com/companies/reilhoferkg; [cid:image004.png@01D9FCE2.F2F39B40] <https://www.instagram.com/reilhoferkg; [cid:image005.png@01D9FCE2.F2F39B40] <https://www.youtube.com/user/reilhoferkg; [cid:image006.png@01D9FCE2.F2F39B40]
General Manager: Stefan Salvermoser. Registergericht: Amtsgericht München, HRA 65361
Attachments:
image001.png (image/png, 5.1K) download
view image
image002.png (image/png, 3.5K) download
view image
image003.png (image/png, 933B) download
view image
image004.png (image/png, 1.4K) download
view image
image005.png (image/png, 3.3K) download
view image
image006.png (image/png, 980B) download
view image
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Question About PostgreSQL Extensibility
@ 2023-10-12 13:43 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Sepideh Eidi <eidi@rhf.de>
1 sibling, 1 reply; 7+ messages in thread
From: Laurenz Albe @ 2023-10-12 13:43 UTC (permalink / raw)
To: Sepideh Eidi <eidi@rhf.de>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Question About PostgreSQL Extensibility
@ 2023-10-12 15:08 Ilya Kosmodemiansky <ik@dataegret.com>
parent: Sepideh Eidi <eidi@rhf.de>
1 sibling, 1 reply; 7+ messages in thread
From: Ilya Kosmodemiansky @ 2023-10-12 15:08 UTC (permalink / raw)
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>; +Cc: Sepideh Eidi <eidi@rhf.de>
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
v. G.,
Ilya
best regards,
Ilya Kosmodemiansky,
CEO, Data Egret GmbH
Herrenstr. 1 A 2,
Spiesen-Elversberg, Germany
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Question About PostgreSQL Extensibility
@ 2023-10-13 05:05 Chris Travers <chris.travers@gmail.com>
parent: Ilya Kosmodemiansky <ik@dataegret.com>
0 siblings, 0 replies; 7+ messages in thread
From: Chris Travers @ 2023-10-13 05:05 UTC (permalink / raw)
To: ik@dataegret.com; +Cc: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>; Sepideh Eidi <eidi@rhf.de>
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.
http://www.efficito.com/learn_more
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Question About PostgreSQL Extensibility
@ 2023-10-13 13:55 felix.quintgz@yahoo.com
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 7+ messages in thread
From: felix.quintgz@yahoo.com @ 2023-10-13 13:55 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Question About PostgreSQL Extensibility
@ 2023-10-16 15:32 Laurenz Albe <laurenz.albe@cybertec.at>
parent: felix.quintgz@yahoo.com
0 siblings, 1 reply; 7+ messages in thread
From: Laurenz Albe @ 2023-10-16 15:32 UTC (permalink / raw)
To: felix.quintgz@yahoo.com; pgsql-general@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Question About PostgreSQL Extensibility
@ 2023-10-17 09:52 Chris Travers <chris.travers@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 7+ messages in thread
From: Chris Travers @ 2023-10-17 09:52 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: felix.quintgz@yahoo.com; pgsql-general@lists.postgresql.org
On Mon, Oct 16, 2023 at 10:59 PM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:
> 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.
>
Or pick up the pldotnet handler and patch it to work on the new version.
My experience forward porting such things is that it is usually trivial.
Of course there may be other reasons to rewrite but it really depends on a
lot of factors.
>
> Yours,
> Laurenz Albe
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2023-10-17 09:52 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-12 06:09 Question About PostgreSQL Extensibility Sepideh Eidi <eidi@rhf.de>
2023-10-12 13:43 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-10-13 13:55 ` felix.quintgz@yahoo.com
2023-10-16 15:32 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-10-17 09:52 ` Chris Travers <chris.travers@gmail.com>
2023-10-12 15:08 ` Ilya Kosmodemiansky <ik@dataegret.com>
2023-10-13 05:05 ` Chris Travers <chris.travers@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox