Android Firebase advanced queries

Question

Trying to build an android app with Firebase backend.

I read all about it, built an app that syncs with the backend, etc. what I can't figure out is how to make advanced queries without retrieving all the parent.

for example - say I scale to many users, and I want to retrieve only users that are 50 KM around me, I don't want to retrieve ALL the users and then manipulate the data. I want to retrieve ONLY the users I need.

I guess I'm looking for something more SQLish like "GET users WHERE users.location = bla bla bla".

can anyone help me ? thanks!

Did you see https://firebase.google.com/docs/database/android/retrieve-data#filtering_data? — Frank van Puffelen, Jul 20 '16 at 19:20
GeoFire? https://github.com/firebase/geofire-java#geo-queries — Travis Christian, Jul 20 '16 at 19:27
yes I know "equalTo()" and geofire, but they aren't enough for advanced queries like "get all users who are named 'bob' and have hair color 'black'. — Gil A, Jul 20 '16 at 19:32
That's a query on multiple values. See http://stackoverflow.com/questions/26700924/query-based-on-multiple-where-clauses-in-firebase — Frank van Puffelen, Jul 20 '16 at 19:57
thanks Frank. read that too. I think that maybe Firebase isn't right for my app. I wonder why didn't they allow simple AND query commands. — Gil A, Jul 20 '16 at 20:01

score 0 · Answer 1 · answered Jan 28 '17 at 18:05

0

I recommend you watch the Firebase Database for SQL Developers series. It helps understanding how to create queries, the same way we used to do in SQL.

answered Jan 28 '17 at 18:05

Rosário Pereira Fernandes

11,015
6
55
79

Android Firebase advanced queries

1 Answers1