castled 官方直接提供了docker-compose 一键运行

环境运行

• docker-compose

git clone <a href="https://github.com/castledio/castled.git">https://github.com/castledio/castled.git</a>

cd castled

docker-compose up -d 

• pg 准备

docker run -d -p 5432:5432 -e POSTGRES_PASSWORD=dalong postgres:14.0

• rest api server

docker run -p  80:80 -d kennethreitz/httpbin

• 权限分配
  可以参考官方文档

 

-----------------------------------USER CREATON STARTS-------------------------------------------------------

— Create a new user CASTLED for connecting to postgres DB

CREATE USER CASTLED WITH PASSWORD 'dalongdemoapp';

-----------------------------------USER CREATON ENDS----------------------------------------------------------

   

-----------------------------------BOOK KEEPING SCHEMA ACCESS STARTS------------------------------------------

-- Create a private bookkeeping schema for storing sync data

CREATE SCHEMA CASTLED;

 

-- Give the CASTLED user full access to the bookkeeping schema

GRANT ALL ON SCHEMA CASTLED TO CASTLED;

 

-- Give CASTLED user access to all objects existing n the bookkeeping schema

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA CASTLED TO CASTLED;

   

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA PUBLIC TO CASTLED;

试用效果

地址 http://localhost:3000

• ui

 

 

• 创建pipeline

data warehouse

 

 

 

 

 

 

说明

目前官方云端的以及开源版本基本都是一样的，可以使用了kafka，mysql，redis等中间件，代码还是很值得学习下的

参考资料

https://docs.castled.io/getting-started/Sources/configure-postgres
https://github.com/castledio/castled