2 ms·
How does this compare to PGSync? (https://pgsync.com/ https://pgsync.com/)
by ahnick 2y ago
How does this compare to PGSync? (https://pgsync.com/ https://pgsync.com/)
- nick-keller 2y agoI believe it is very comparable to PGSync in the way it works (schema-based CDC), the main differences are: - PGSync is a full-stack solution and PG-Sync is "just" a library. PGSync will work out of the box while PG-Capture will require more setup but you'll get more flexibility - PGSync does not let you choose where you get your data from, it handles everything for you. PG-Capture lets you source events from Debezium, WAL-Listener, PG directely... - PGSync is only meant to move data from PG to Elastic or Open-Search. While this use-case is perfectly feasible with PG-Capture, you can use it for many more things: populating cache, indexing into Algolia, sending events to an event bus... All in all, the main difference is that PG-Capture is agnostic of the stack you want as input and output, allowing you to do pretty much anything while PGSync is focused on indexing data from PG to Elastic. I hope that clears things up!