COSCUP 2024

My best practices for interacting between PostgreSQL and ClickHouse
2024-08-04, 11:30–12:00 (Asia/Taipei), TR409-2

In this session, I will introduce my experiences about interacting between PostgreSQL and ClickHouse. It includes multiple approaches about how these two different types of databases can interact with each other.
I also provide some real-world cases to demonstrate above interacting situations.


My sections are organized and they're as follows:

  1. Introduce myself.
  2. What's ClickHouse?
  3. Why I need to interact between PostgreSQL and ClickHouse?
  4. Introducing multiple approaches about interacting between PostgreSQL and ClickHouse.
  5. Case 1: From PostgreSQL to ClickHouse.
  6. Case 2: From ClickHouse to PostgreSQL.
  7. Conclusion.

My name is Peter Li, I developed many open source projects and I also keen on contributing/collaborating many open source projects in the GitHub for about six years.

In the past, I worked as a associate engineer in Industrial Technology Research Institute and I research the electric and energy application systems.

Now I worked as a associate engineer in Institute for Information Industry and I research the medical information and carbon emission domains.

This speaker also appears in: