pglogical VS pg-logical-replication

Compare pglogical vs pg-logical-replication 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)
InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
pglogical pg-logical-replication
2 2
938 79
1.0% -
4.0 2.6
9 days ago over 1 year ago
C TypeScript
GNU General Public License v3.0 or later MIT License
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.

pg-logical-replication

Posts with mentions or reviews of pg-logical-replication. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-03-18.
  • PostgreSQL Logical Replication Explained
    4 projects | news.ycombinator.com | 18 Mar 2023
    > Logical replication is also great for replicating to other systems - for example Debezium [1] that writes all changes to a Kafka stream.

    So I'm looking for a Rust library (or a C library) that receives a Postgres logical replication stream and is compatible with Postgres 15, does you know of something?

    Debezium is unfortunately written in Java, and I think your Powersync is proprietary right? (I didn't find a Github link). I can find stuff like https://www.npmjs.com/package/pg-logical-replication but again, it's Javascript.

  • Sync databases on command
    3 projects | /r/PostgreSQL | 15 Dec 2022
    And I also found these two library that support the two plugin: - https://github.com/kibae/pg-logical-replication - https://github.com/hasura/pgdeltastream

What are some alternatives?

When comparing pglogical and pg-logical-replication 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.

wal2json - JSON output plugin for changeset extraction

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

debezium - Change data capture for a variety of databases. Please log issues at https://issues.redhat.com/browse/DBZ.

sqlite-wf - Simple visual ETL tool

pgdeltastream - Streaming Postgres logical replication changes atleast-once over websockets

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

Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

crystal - 🔮 Graphile's Crystal Monorepo; home to Grafast, PostGraphile, pg-introspection, pg-sql2 and much more!

relay-starter-kit - 💥 Monorepo template (seed project) pre-configured with GraphQL API, PostgreSQL, React, and Joy UI. [Moved to: https://github.com/kriasoft/graphql-starter-kit]

slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.