pglogical VS clickhouse-sink-connector

Compare pglogical vs clickhouse-sink-connector and see what are their differences.

pglogical

Logical Replication extension for PostgreSQL 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades. (by 2ndQuadrant)
Postgresql Replication logical-decoding database-replication Subscription publish-subscribe data-transformation data-transport ETL Cdc zero-downtime
Source Code
2ndquadrant.com
Suggest alternative
Edit details

clickhouse-sink-connector

Replicate data from MySQL, Postgres and MongoDB to ClickHouse (by Altinity)
Avro Kafka kafka-connect Clickhouse Postgresql Replication Cdc debezium MySQL Mongo
Source Code
altinity.com
Suggest alternative
Edit details
WorkOS
Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
Our great sponsors
pglogical clickhouse-sink-connector
2 1
935 173
2.1% 11.6%
3.9 9.8
22 days ago 1 day ago
C Python
GNU General Public License v3.0 or later Apache License 2.0
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

pglogical

Posts with mentions or reviews of pglogical. We have used some of these posts to build our list of alternatives and similar projects.

clickhouse-sink-connector

Posts with mentions or reviews of clickhouse-sink-connector. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-10-04.
  • ClickHouse Cloud is now in Public Beta
    13 projects | news.ycombinator.com | 4 Oct 2022
    Check out the Altinity Sink Connector for ClickHouse [0]. This is advancing quite quickly and already has prod deployments. Please feel free to try it out.

    [0] https://github.com/Altinity/clickhouse-sink-connector

What are some alternatives?

When comparing pglogical and clickhouse-sink-connector you can also consider the following projects:

symmetric-ds - SymmetricDS is database replication and file synchronization software that is platform independent, web enabled, and database agnostic. It is designed to make bi-directional data replication fast, easy, and resilient. It scales to a large number of nodes and works in near real-time across WAN and LAN networks.

spyql - Query data on the command line with SQL-like SELECTs powered by Python expressions

peerdb - Fast, Simple and a cost effective tool to replicate data from Postgres to Data Warehouses, Queues and Storage

asyncmy - A fast asyncio MySQL/MariaDB driver with replication protocol support

sqlite-wf - Simple visual ETL tool

clickhouse-operator - Altinity Kubernetes Operator for ClickHouse creates, configures and manages ClickHouse clusters running on Kubernetes

ReplicaDB - ReplicaDB is open source tool for database replication, designed for efficiently transferring bulk data between relational and non-relational databases

matano - Open source security data lake for threat hunting, detection & response, and cybersecurity analytics at petabyte scale on AWS

pglogical vs symmetric-ds clickhouse-sink-connector vs spyql pglogical vs peerdb clickhouse-sink-connector vs asyncmy pglogical vs sqlite-wf clickhouse-sink-connector vs clickhouse-operator pglogical vs ReplicaDB clickhouse-sink-connector vs matano