Artie vs Bucardo

Artie streams database changes captured through CDC or events ingested through an API to destinations in real time. It describes sub-minute latency and exactly-once delivery. Automatic schema handling detects column additions, drops, and type changes and applies them without pipeline restarts or manual DDL. History mode, or SCD Type 2, tracks row versions over time in the destination. A dashboard monitors pipeline health, throughput, latency, and errors, with Datadog and Grafana integrations available. Listed sources include PostgreSQL, MySQL, MongoDB, DynamoDB, Oracle, and SQL Server; destinations include Snowflake, BigQuery, Redshift, Databricks, and S3. Data controls include column-level inclusion, exclusion, encryption, and hashing. Artie says it encrypts data in transit and at rest and does not retain data after processing. The Free plan costs nothing and allows up to 1M billable rows per month and two active pipelines. Growth costs $500 a month billed annually as $6,000, or $600/month month-to-month. Enterprise pricing is custom; it includes BYOC and on-premise deployment options.

Bucardo is a free, open-source system for asynchronous PostgreSQL replication in multi-source and multi-target arrangements. It supports multi-way synchronization and one-direction master-standby replication. Users define named syncs that copy selected tables between a server and other servers. A Perl daemon listens for NOTIFY requests and connects to remote databases to copy data. Multi-source setups can use a standard conflict handler or a custom handler assigned per table. Configuration and replication databases require PostgreSQL 8.1 or later, while the configuration database also needs PL/pgSQL and PL/PerlU. The daemon needs a Unix-like operating system, is tested mainly on Linux and macOS, and does not run natively on Windows. Installation is available from source, RPM or Debian packages, and FreeBSD Ports. Bucardo does not replicate DDL or schema changes. The listed latest release is 5.6.0.