There are no shortage of well constructed data table components such as Vuetify, PrimeVue, and AG-Grid.

However none of these tools it seems integrates well into querying my Firestore collection natively.

Here is my specific use case:

I have 1500 rows of university data and I want to be able to sort and display this entire collection by the number of applications using the column header on the data table as the control(s).

https://preview.redd.it/y11m430playc1.png?width=2882&format=png&auto=webp&s=565ab5e7a5cc85abcc7770ce8275054832e53357

I've tried querying and storing all of the datait using IndexedDB but that has caused many problems and wouldn't be as good as just querying for the first 50 results that the table settings retrieves.

Seems like AG-Grid would have been the answer to my troubles with its Server-Side Row Model though I just don't think this solution is meant for a NoSQL solution, or at the least a Firebase solution.

From here I started to look into a solution with Typesense, as they have a Cloud solution that integrates with Firestore natively, which does in a way what I'd like it to do, but then your search/browse controls and results are displayed in a traditional sense, where as for my use-case the data-table is much preferred.

What do y'all think? Any experience trying to display, paginate, sort, and filter your Firestore collection using a data table?

Is what I'm trying to do possible?

I would be wiling to pay for training/mentorship in getting over this.