Hello Experts out there, I need some advice and direction please. We have a dataset of restaurant locations indexed in typesense. Each restaurant has a set of tables, and users make bookings for specific time slots on those tables. Goal: When a user searches for a restaurant (by name, location, cuisine, etc.), the system should return only those restaurants that have available table time slots matching the user's requested date and time. Key Constraints: • A restaurant may have multiple tables, and each table may have multiple bookings across the day. • The system must efficiently filter out restaurants that are fully booked for the given time slot(s). is this the right usecase for typesense ?

This is a great use-case for JOINs, and filtering by availability on the JOINed collection!

@Fanis Tharropoulos is it possible as of today on typesense

https://typesense.org/docs/28.0/api/joins.html Yes!

great ! is there any practical example

There's a demo: https://github.com/typesense/showcase-joins-django/

is it possible @Fanis Tharropoulos if i can google meet with someone at typesense to run through the schema and queries to get expert advice on the best practices

Due to the amount of users and our bandwidth, we sadly don't offer meetings outside of paid support. You can, if you want, sign up for a support plan here: https://cloud.typesense.org/support-plans And contact us

got it @Fanis Tharropoulos , if i purchase the plan, will anyone be allocated to help me out

If you get the business support plan, send us a message and we'll arrange a meeting together 😁