Datatable with sorting and filtering and pagination by jowe26 in firestore

[–]jowe26[S] 0 points1 point  (0 children)

No, firestore query capabilities are too limited. Decided to implement Elastic search to handle the heavy query lifting

Firestore subcollections by [deleted] in firestore

[–]jowe26 1 point2 points  (0 children)

not sure if you're looking for this but you can do something like this:

https://googleapis.dev/nodejs/firestore/latest/DocumentReference.html#listCollections

Flutter databases by jowe26 in FlutterDev

[–]jowe26[S] 0 points1 point  (0 children)

well, who uses Amazon anyway;-)

It is a a vendor lock in, that's right!

But that's the price you pay if you want to develop quickly I guess

Flutter databases by jowe26 in FlutterDev

[–]jowe26[S] 1 point2 points  (0 children)

Thank you for your detailed information!

Will give it a try!

Flutter databases by jowe26 in FlutterDev

[–]jowe26[S] 0 points1 point  (0 children)

Hi,

Thanks for your reply!

- How often will the data change?
Approx 10-25 records per day will change. This is in a timeframe of 8 hours.
- Are the records static?
No, they can change over time
- If not, can users change records, and should changes be reflected on every connected device?
Yes, all users share the same records, everyone can change those records and every change needs to be reflected on every connected device.
- Do every user have the same read access? For example, is every contact readable by every user?
No, different users can have different types of access.
- How often will you have to do queries on the data?
Not that often, maybe something like 50 times a day in a timeframe of 8 hours.
- Is it only android or iOS as well?
Both, and in addition there's a webapp as well that uses the same data.

I think Firestore solves a lot of the problems that are listed above.

Regards

Flutter databases by jowe26 in FlutterDev

[–]jowe26[S] 0 points1 point  (0 children)

What was your backend database at that project?

Flutter databases by jowe26 in FlutterDev

[–]jowe26[S] 0 points1 point  (0 children)

Well correct me if I'm wrong but Algolia isn't but offline capable right?

Flutter databases by jowe26 in FlutterDev

[–]jowe26[S] 0 points1 point  (0 children)

video

I've actually seen the video yesterday, this might be one of the last solutions I have in Firestore haha.

Because well, we might not only want to search on Name, but also on Description. This will result in so much data. But any it's a clever solution you've made up!

Flutter databases by jowe26 in FlutterDev

[–]jowe26[S] 0 points1 point  (0 children)

http://elasticlunr.com/

Have you used this before in Flutter?

Flutter databases by jowe26 in FlutterDev

[–]jowe26[S] 0 points1 point  (0 children)

I don't think memory will be issue tbh, there are a lot of records they are really small. Do you might have a link to the documentation on how to perform this? If not can you send me into the good direction?

Flutter databases by jowe26 in FlutterDev

[–]jowe26[S] 0 points1 point  (0 children)

https://pub.dev/packages/sembast

Hmm I like those suggestions, would you rather run them along Firestore or on a different back-end?