www.digitalmars.com         C & C++   DMDScript  

digitalmars.D - Creating Postgresql extensions in D

reply 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?
Sep 05 2020
next sibling parent 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
Sep 05 2020
prev sibling next sibling parent 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
Sep 06 2020
prev sibling next sibling parent 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
Sep 06 2020
prev sibling parent 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
Sep 14 2020