castled 运行试用

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

环境运行

docker-compose

git clone https://github.com/castledio/castled.git

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

创建pipeline

data warehouse

说明

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

参考资料

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