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.
Nov 04, 2022 (10 months ago)
Akbar
03:45 AMJason
04:10 AMTypesense
Indexed 2764 threads (79% resolved)
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.
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.


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.

