• kajaru (4/4) Sep 05 2020 I haven't found anything except a single topic here where there's
• mw (4/8) Sep 05 2020 Maybe the first thing to check is goto https://code.dlang.org/
• Andre Pany (9/13) Sep 06 2020 As far as I understand it is easily possible. You have to
• Laeeth Isharc (6/10) Sep 06 2020 Some unfinished work towards porting the git example for
• Denis Feklushkin (9/13) Sep 14 2020 A bit offtopic: it might be worth find or developing a protocol

kajaru <kajaru serendipia.email> writes:

I haven't found anything except a single topic here where there's 
no helpful information.

Has anyone done that nowadays? Is there any simple example? Is it 
possible at all in D?

mw <mingwu gmail.com> writes:

On Sunday, 6 September 2020 at 05:07:36 UTC, kajaru wrote:
 I haven't found anything except a single topic here where 
 there's no helpful information.

 Has anyone done that nowadays? Is there any simple example? Is 
 it possible at all in D?


Maybe the first thing to check is goto https://code.dlang.org/
and search if someone has done that already:

https://code.dlang.org/search?q=Postgresql

Andre Pany <andre s-e-a-p.de> writes:

On Sunday, 6 September 2020 at 05:07:36 UTC, kajaru wrote:
 I haven't found anything except a single topic here where 
 there's no helpful information.

 Has anyone done that nowadays? Is there any simple example? Is 
 it possible at all in D?

As far as I understand it is easily possible. You have to 
translate the postgres C headers to D (I think you might  find 
them on code.dlang.org or use DPP to generate it yourself).

Then you have to do s.th. similiar to this example for C
https://www.percona.com/blog/2019/04/05/writing-postgresql-extensions-is-fun-c-language/

Just ask, when you have questions.

Kind regards
Andre

Laeeth Isharc <laeeth laeeth.com> writes:

On Sunday, 6 September 2020 at 05:07:36 UTC, kajaru wrote:
 I haven't found anything except a single topic here where 
 there's no helpful information.

 Has anyone done that nowadays? Is there any simple example? Is 
 it possible at all in D?

Some unfinished work towards porting the git example for 
postgresql FDW to D.  Uses dpp but if can't handle some of the 
macros.  This is all I have right now.


https://gist.github.com/Laeeth/82d5b1f1c5c3b643ea718a8f24c29741


https://gist.github.com/Laeeth/c46a48fea8bb6e125c21a28c7d684020

Denis Feklushkin <feklushkin.denis gmail.com> writes:

On Sunday, 6 September 2020 at 05:07:36 UTC, kajaru wrote:
 I haven't found anything except a single topic here where 
 there's no helpful information.

 Has anyone done that nowadays? Is there any simple example? Is 
 it possible at all in D?

A bit offtopic: it might be worth find or developing a protocol 
for calling Postgres functions and aggregates from PG server to 
local external handlers. Something like WCGI but binary for local 
processes. This will lead to tiny well-tested loadable PG module.

This will be more safe than run custom binaries on production 
RDBMS.

Support of PG binary types is already implemented in 
https://github.com/denizzzka/dpq2