#community-help

Syncing Typesense and PostgreSQL

TLDR Akbar is a beginner at Typesense and asks for documentation on syncing it with PostgreSQL. Jason states they are not aware of such a thing, but offers information on uploading documents from Postgres to Typesense.

10mo

Join the chat

Nov 04, 2022 (10 months ago)

Photo of md5-1965fa97b66e8773338a20ff8cf8fcf7

Akbar

03:45 AM

Hi guys, I'm beginner in typesense. I want to know, is there any documentation or tutorial that clearly explain how to sync typesense and postgresql? Thank you everyone!

Photo of md5-c7ebbbcac16a1763e16d0e8e8177b0ae

Jason

04:10 AM

I’m not aware of any syncing from to the other. We upset documents from Postgres to Typesense. Used the Impodt api to do the initial load.

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 2764 threads (79% resolved)

Join Our Community Manage subscription

Similar Threads

Realtime Synchronization of Postgres DB with Typesense

Ahmad asked how to sync Postgres DB with Typesense in real time. Kishore Nallan suggested handling it through the application layer, using queues and lambdas, or running daily dumps.

21mo

Managing Typesense Across Large Datasets

Phillip inquired about best practices with Typesense for large datasets. Ross shared personal practices, and Jason confirmed Typesense isn't designed to be a primary datastore. Patrick shared a related discussion link. Viji mentioned using DynamoDB Streams as an option.

13mo

Troubleshooting Typesense Document Import Error

Christopher had trouble importing 2.1M documents into Typesense due to memory errors. Jason clarified the system requirements, explaining the correlation between RAM and dataset size, and ways to tackle the issue. They both also discussed database-like query options.

8mo