pglogical
pg-logical-replication
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 |
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
- Pglogical 2
-
How to mirroring database in postgresql
You may want to look into pglogical since it replicates sequences as well. I don't think postgres' built-in logical replication replicates sequences.
pg-logical-replication
-
PostgreSQL Logical Replication Explained
> 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
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?
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.