I have a question about tracking counts (e.g. no_of_students, no_of_books) with typesense document and joins. Suppose i have a student collection and book collection, and i have to maintain a count (no_of_books_owned by student) on books at student collection. Is it better to maintain this count as an attribute on student collection? Is it possible for me to do a join to get this count, like we do with SQL db tables? is a join performant for this kind of use case?

If you do a join via filtering, without any other filter parameter, the

found

parameter will be the equivalent

COUNT

aggregate function on SQL

@weiklr I think https://github.com/typesense/typesense/issues/2073 is what you're looking for? If so, we'll have this feature in the next RC.