Hacker News new | ask | show | jobs
by vosper 1404 days ago
PGSync might be useful for those who don't mind also running Elasticsearch

https://github.com/toluaina/pgsync

3 comments

In that case you may also want to take a look at https://github.com/zombodb/zombodb
Oh that’s super neat! Looks like a more elegant way to link Postgres and Elasticsearch:

“From a technical perspective, ZomboDB is a 100% native Postgres extension that implements Postgres' Index Access Method API. As a native Postgres index type, ZomboDB allows you to CREATE INDEX ... USING zombodb on your existing Postgres tables. At that point, ZomboDB takes over and fully manages the remote Elasticsearch index and guarantees transactionally-correct text-search query results.”

This is so neat! How does it handle updates? Are there similar systems which can sync with Redis for quick caching?
Thank you for sharing. Does anyone know of something similar for dynamodb?
Indexing dynamodb with elasticsearch ? Amplify makes it super easy.

https://docs.amplify.aws/cli-legacy/graphql-transformer/sear...

Sorry, no, I mean sync pg to dynamodb instead of elasticsearch.