- build image
docker-compose build
- start griddb && pgspider:griddb
docker-compose up -d griddb pgspider-griddb
- init some datas
after griddb start && source code in
java-app
dir
docker-compose up griddb-java
- use griddb_fdw extension
CREATE EXTENSION griddb_fdw;
// use notification_member
CREATE SERVER griddb_svr FOREIGN DATA WRAPPER griddb_fdw OPTIONS(notification_member 'griddb:10001',clustername 'defaultCluster');
CREATE USER MAPPING FOR public SERVER griddb_svr OPTIONS(username 'admin', password 'admin');
IMPORT FOREIGN SCHEMA griddb_schema FROM SERVER griddb_svr INTO public;
select * from col01;
- use plv8 extension
// create plv8 extension
CREATE EXTENSION plv8;
// create shortid func
CREATE or replace FUNCTION shortid() RETURNS text AS
$$
const shortid = require('shortid');
const result = shortid.generate();
return result;
$$
LANGUAGE plv8;
// register plv8 require funcs
cd node-app && yarn && node app.js
// alter database for session init plv8 func
ALTER DATABASE postgres SET "plv8.start_proc" TO "v8.plv8_init";
// maybe need restart pg server
// do some insert with knex orm framework
cd node-app && yarn && node index.js