mysql支持Graph_通过torodb && hasura graphql 让mongodb 快速支持graphql api

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 集成

添加支持

查询

说明

集成起来，简直太方便了

参考资料