digoal
2018-09-13
PostgreSQL , pgsocket
PostgreSQL 插件，向外部tpc/ip socket服务发生字节流。
pgsocket is an extension for PostgreSQL server to send bytes to remote TCP/IP socket server.
For the first version only single function provided for one way data send in bytearray.
This extension is compiled in Linux against PostgreSQL version 10.
Download source code from https://github.com/AbdulYadi/pgsocket. Build in Linux as usual:
$ USE_PGXS=1 make clean
$ USE_PGXS=1 make
$ USE_PGXS=1 make install
On successful compilation, install this extension in PostgreSQL environment
$ create extension pgsocket;
Let us send bytes to –for example– host with IP address nnn.nnn.nnn.nnn, port 9090, send time out 30 seconds, messages 'Hello'
$ select pgsocketsend('nnn.nnn.nnn.nnn', 9090, 30, (E'\\x' || encode('Hello', 'hex'))::bytea);
Or using address host name instead of IP address
$ select pgsocketsend('thesocketserver', 9090, 30, (E'\\x' || encode('Hello', 'hex'))::bytea);
Now, sending text from a table to remote TCP/IP socket server is easy. Assuming there is a table words:
id txt
——————–
1 Life is easy
2 with PostgreSQL
just do:
$ select pgsocketsend('thesocketserver', 9090, 30, (E'\\x' || encode(t.txt, 'hex'))::bytea)
from words t WHERE t.id = 1;
https://abdulyadi.wordpress.com/2018/09/11/pgsocket-extension-for-simple-socket-client/
https://github.com/AbdulYadi/pgsocket
https://abdulyadi.wordpress.com/2015/11/14/extension-for-qr-code-bitmap/
您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.
