✳flâneur — a map of the web's best reading

toluaina/pgsync: Postgres to Elasticsearch/OpenSearch sync

github.com · 1,007 words · saved by 1 readers

PGSync is a middleware for syncing data from Postgres to Elasticsearch/OpenSearch effortlessly. It allows you to keep Postgres as your source of truth and expose structured denormalized documents in Elasticsearch/OpenSearch. Changes to nested entities are propagated to Elasticsearch/OpenSearch. PGSync's advanced query builder then generates optimized SQL queries on the fly based on your schema. PGSync's advisory model allows you to quickly move and transform large volumes of data quickly whilst maintaining relational integrity. Simply describe your document structure or schema in JSON and PGSync will continuously capture changes in your data and load it into Elasticsearch/OpenSearch without writing any code. PGSync transforms your relational data into a structured document format. It allows you to take advantage of the expressive power and scalability of Elasticsearch/OpenSearch directly from Postgres. You don't have to write complex queries and transformation pipelines. PGSync is ligh

PGSync Real-time PostgreSQL to Elasticsearch/OpenSearch sync Keep your relational database as the source of truth while powering lightning-fast search Website · Documentation · Examples · Report Bug What is PGSync? PGSync is a change data capture tool that syncs data from PostgreSQL , MySQL , or MariaDB to Elasticsearch or OpenSearch in real-time. Define your document structure in JSON, and PGSync handles the rest — no custom code required. Django integration: Use django-pgsync to integrate PGSync with Django projects. %%{init: {'look': 'handDrawn', 'theme': 'neutral'}}%% flowchart LR subgraph

Explore this link on the map →

related reading