Achieving MySQL tables join in Typesense
TLDR Shabber enquired about simulating MySQL table joins in Typesense. Kishore Nallan responded that Typesense doesn't support joins and suggested storing data as a single document.
1
Jun 28, 2023 (5 months ago)
Shabber
10:18 AMin mysql i have two tables from which old autocomplete works by joining two tables.
how can we achieve this in typesense .
there might be cases all time table values get updated
any suggestion for this please ?
Kishore Nallan
10:21 AMShabber
10:22 AM1
Typesense
Indexed 3015 threads (79% resolved)
Similar Threads
Integrating Typesense for Search Functionality into Application Hosted on AWS
Rajashekar needed help integrating Typesense into an AWS-hosted application. Jason confirmed they're correctly implementing it and pointed them to additional guides.
Typesense Information Retrieval and Features
Ahmed sought to retrieve all data from typesense. Kishore Nallan shared a build and instructions. TJ queried about cascading delete, a feature Kishore Nallan agreed to consider.
Adding and Updating Collections in Typesense Server
sonu asked about methods to add and update collections in a Typesense server. Jason advised that documents can be added individually or in bulk, and updates can be batched using the import function, even with a small React app with a MySQL database.