You had to actually read the docs to be able to use size() before. With count, you can get the count of docs without reading the docs themselves.@@javascript_developer
I build my own counter using cloud function every time a new document is added I count that doc and update the counter. Hear about official count function and pricing this is amazing. I'll use this counter function in my app.
Thanks for sharing your awesome solution! 🤗I'm so glad this video helped you figure out how to use Firestore Count in your app. 🙌
2 роки тому+8
Links to the "updated" pricing and documentation for COUNT for all platforms would be very much appreciated in the pinned comment or description. Been looking for a couple minutes and I haven't found the documentation and pricing page.
I take full credit for this feature - we had a conversation in the firestore community and it hit us that this feature didn't exist... so we made the feature request and it took a month to speed through, when feature suggestions make sense... it just clicks for everyone
@@digimbyte how did it take 5 years for someone to make this feature request?? This was one of the worst aspects of this storage option. The others are inability to JSON export from the Google console, and copy and paste/duplicate/clone documents & collections to manually create a new record off a pre-existing template
This is great, but in terms of pagination, correct me if I'm wrong but we are still unable to paginate to a certain page. Let's say I get the count and I have 100 docs and I'm limiting the actual doc read query to 25 (my page size) I would then have 4 pages I give the user the UI and they think they can click through to say, page 3. But I have no way of telling firebase the startAfter that will be doc 50 thus getting doc 50-75 I think right now the best I can present my user is a Prev/Next button and visiually show them them they're seeing batch 50-75/100 because I have no way to get a query cursor at a particular count num
You still don't get it. The count(*) that we want is based on "group by" that returns the count for each group, even together with other group columns. The result will contain multiple rows with the count(*) column, which could be set as an alias (column name), e.g. TotalItems for each category.
Subscribe for the latest → goo.gle/Firebase
I’ve waited years for this feature! 🎉
What an amazing feature, we waited so long for this and it's finally here!
we could use size() before right ?
You had to actually read the docs to be able to use size() before. With count, you can get the count of docs without reading the docs themselves.@@javascript_developer
Absolutely beautiful!
This is awesome, thanks for this feature
Excellent explanation David!
Finally! Count is very useful.
What can you suggest to fetch random document from collection in most efficient way?
Make a random propriety in document and query a random range
I build my own counter using cloud function every time a new document is added I count that doc and update the counter. Hear about official count function and pricing this is amazing. I'll use this counter function in my app.
Thanks for sharing your awesome solution! 🤗I'm so glad this video helped you figure out how to use Firestore Count in your app. 🙌
Links to the "updated" pricing and documentation for COUNT for all platforms would be very much appreciated in the pinned comment or description. Been looking for a couple minutes and I haven't found the documentation and pricing page.
It's unbelievable that such a basic feature is only released now (more than 5 years of waiting)
I take full credit for this feature - we had a conversation in the firestore community and it hit us that this feature didn't exist... so we made the feature request and it took a month to speed through, when feature suggestions make sense... it just clicks for everyone
@@digimbyte how did it take 5 years for someone to make this feature request?? This was one of the worst aspects of this storage option. The others are inability to JSON export from the Google console, and copy and paste/duplicate/clone documents & collections to manually create a new record off a pre-existing template
Is it available for flutter ?
He has a Sparky plushie on the shelf 🤗
Could some one told me the version that are support aggregation query.
0:56 is it not
GetCountDFromServer(expensesQuery) ?
¡Excelente, necesitabamos algo así!
awesome
Unity example.... Plllleeeeeaaaaassssseee! 😇 PS: Great job on this video!
This is a long waited feature, thanks!
But how come there is no documentation about it?
Specifically for Cloud Functions.
This is great, but in terms of pagination, correct me if I'm wrong but we are still unable to paginate to a certain page.
Let's say I get the count and I have 100 docs and I'm limiting the actual doc read query to 25 (my page size)
I would then have 4 pages
I give the user the UI and they think they can click through to say, page 3. But I have no way of telling firebase the startAfter that will be doc 50 thus getting doc 50-75
I think right now the best I can present my user is a Prev/Next button and visiually show them them they're seeing batch 50-75/100 because I have no way to get a query cursor at a particular count num
How does pagination work with this approach? Is using .offset() now also more convenient?
just wondering if you found answer to your question? How does pagination work this way? How Can I just query records for any N page number ?
@@MultiChinmay It is working with .offset(). But how many Reads are gone be created, I still don't know.
Do firestore awesome! again thanks
Selalu hadir suports Nya bang ful
I was excited about this but it's insanely slow.
Melissa Fenwick
Is this available in Python?
Come on guys, native text search, I trust you.
You still don't get it. The count(*) that we want is based on "group by" that returns the count for each group, even together with other group columns. The result will contain multiple rows with the count(*) column, which could be set as an alias (column name), e.g. TotalItems for each category.
thats a different feature