torodb 可以方便的将mongo 数据实时同步到pg，hasura graphql 可以方便的将pg 数据暴露为graphql

api，集成在一起真的很方便

环境准备

• docker-compose 文件

version: '2'services:  graphql-engine:    image: hasura/graphql-engine:v1.0.0-alpha27    ports:    - "8080:8080"    command: >      /bin/sh -c "      graphql-engine --database-url postgres://postgres@postgres/torod serve --enable-console;      "  torodb-stampede:    image: torodb/stampede    links:      - postgres      - mongodb    environment:      - POSTGRES_PASSWORD      - TORODB_SETUP=true      - TORODB_SYNC_SOURCE=mongodb:27017      - TORODB_BACKEND_HOST=postgres      - TORODB_BACKEND_PORT=5432      - TORODB_BACKEND_DATABASE      - TORODB_BACKEND_USER      - TORODB_BACKEND_PASSWORD      - DEBUG  postgres:    image: postgres:9.6    environment:      - POSTGRES_PASSWORD    ports:      - "15432:5432"  mongodb:    image: mongo:3.2    ports:      - "28017:27017"    entrypoint:      - /bin/bash      - "-c"      - mongo --nodb --eval '            var db;             while (!db) {                 try {                   db = new Mongo("mongodb:27017").getDB("local");                 } catch(ex) {}                 sleep(3000);             };             rs.initiate({_id:"rs1",members:[{_id:0,host:"mongodb:27017"}]});        ' 1>/dev/null 2>&1 &         mongod --replSet rs1

• 启动

docker-compose up -d

测试数据添加

可以使用工具连接，直接导入数据都是可以的

graphql 集成

• 添加支持
  
  
• 查询
  

说明

集成起来，简直太方便了

参考资料