项目作者: renardeinside

项目描述 :
PosgreSQL Debezium CDC Example
高级语言: Jupyter Notebook
项目地址: git://github.com/renardeinside/vogel.git
创建时间: 2019-06-26T13:40:35Z
项目社区:https://github.com/renardeinside/vogel

开源协议:

下载


Postgres CDC example

This is a very simple example of PostgreSQL CDC via amazing Debezium Connector.

Commands reference:

  • first of all, run:
    1. docker-compose up --build
  • to get the jupyter token, please run:
    1. docker-compose -f docker-compose.yml exec jupyter-local jupyter notebook list
    In answer you will receive:
    1. Currently running servers:
    2. http://0.0.0.0:8888/?token={here goes your token} :: /home/jovyan
    Please copy the provided link to the browser.

Data Schema

  • Customers:
    1. Column | Type | Modifiers
    2. ------------+------------------------+--------------------------------------------------------
    3. id | integer | not null default nextval('customers_id_seq'::regclass)
    4. first_name | character varying(255) | not null
    5. last_name | character varying(255) | not null
    6. email | character varying(255) | not null
  • Orders
    1. Column | Type | Modifiers
    2. ------------+---------+-----------------------------------------------------
    3. id | integer | not null default nextval('orders_id_seq'::regclass)
    4. order_date | date | not null
    5. purchaser | integer | not null
    6. quantity | integer | not null
    7. product_id | integer | not null
  • Products
    1. Column | Type | Modifiers
    2. -------------+------------------------+-------------------------------------------------------
    3. id | integer | not null default nextval('products_id_seq'::regclass)
    4. name | character varying(255) | not null
    5. description | character varying(512) |
    6. weight | double precision |
  • Products on hand:
    1. Column | Type | Modifiers
    2. ------------+---------+-----------
    3. product_id | integer | not null
    4. quantity | integer | not null

Misc

To connect to the database directly, please use:

  1. docker-compose \
  2. -f docker-compose.yml \
  3. exec postgres env PGOPTIONS="--search_path=inventory" \
  4. bash -c 'psql -U $POSTGRES_USER postgres'