Is Convex a good for for advanced search?
I'm building out a product that is a platform for data analytics on startups.
It will contain companies, executives, board members, funding rounds, etc.
One of the main features is an advanced search, which will allow to search on companies and people using many filters - names, tags (for industries), funding, etc. An important note is that there will be a lot of many-to-many tables, and we need to be able to efficiently filter based on values in other tables, like tags.
So all that to ask, is convex a good fit for this use case? I'm tempted by the DX and all other benefits, but this seems like it might not be the optimal workload for the product.
It will contain companies, executives, board members, funding rounds, etc.
One of the main features is an advanced search, which will allow to search on companies and people using many filters - names, tags (for industries), funding, etc. An important note is that there will be a lot of many-to-many tables, and we need to be able to efficiently filter based on values in other tables, like tags.
So all that to ask, is convex a good fit for this use case? I'm tempted by the DX and all other benefits, but this seems like it might not be the optimal workload for the product.
