Danny Hutson

50 thoughts on “Firebase Database Querying 101 – The Firebase Database For SQL Developers #3

  1. All of you who are planning on starting your projects with firebase, should know that you can not use a query like you would in SQL:
    select .. where d=1 AND d=2
    you can only use equal_to once and do the other filtering within the client code.

  2. David, I'm studying Firebase right now, and I think I still miss the big picture.
    It looks like Firebase is very easy to use, flexible, and whatever, but the advantage of NOT having and intermediate server layer makes the whole thing fall short when we want to realize a really secure and protected application.
    For example, what if I would like to prevent users from inserting data on Sundays, or if I have to issue an external web api request to see if the user is allowed to edit data…
    It looks like there is some javascript interpreter, to execute the rules in Firebase, but (please correct me!) I don't think this is done to let developers write really complex scenarios, it would really be overkill.
    Please, can you help me in understanding better?
    Thanks

  3. No.
    These queries are just not responding to my requests! I've tried rectifying every possible error!
    Still i ain't able to get desired result, and retrieve correct data.
    Please help if possible. 🙂

  4. how can I query for a specific node in my realtime database that has been created using push() method using one of the values stored within that node(e.g. city = new york),
    Will the following query work:
    mRef.child("restaurants").orderByChild("city").equalTo("New York");

  5. When I add ".orderByChild('myproperty')" to my query, I get an error" Using an unspecified index. Consider adding ".indexOn": "myproperty"? Can't I use this without messing with rules? Not ready for that just yet…

  6. how to display recently added data to database on top once you call from database? I mean recently added data first in the list view.

  7. Am i the only one to spot the SQL queries use "==" which is incorrect. ?
    SQL syntax is just a single "="

  8. Nicely presented but VERY disappointing. The last query was a joke. Where are the LIKE statements? Firebase team, PLEASE sort this out. What you're offering here just isn't up to the job.

  9. Hey dude . Would you mind to make tutorial about How to Filter Firebase Query RecyclerView with SearchView ?

  10. Firebase looks cool, but am finding a big problem implementing %like% for searching as it is easily done in sql. can some one help me please

  11. Hello sir, thank you for your explanation, really help me as junior programmer. Can you explain me how to convert query like this one:

    SELECT * FROM Event WHERE name="a" AND job="b"

    into query format in firebase?
    Thank you…

  12. So for more advanced filtering we need to send all the objects in the child to the client and have their copy of the code do the work? If that is the case wouldn't there be security issues? Like if I have an array of sensitive documents assigned to different people but also could be assigned to more than one person I would have to send a list of all the documents and then trust that the client code sorts out only the ones they are allowed to view. Would it not be better for the data server to only send what is necessary? I'll keep watching and maybe the answer will show up.

  13. how can i use orderByKey and orderByChild in the same query?
    For example : i need to get next question of specific category (1). but i know current question id value (10).
    “`firebase.database().ref('/questions').orderByKey()
    .startAt("10")
    .orderByChild('category_id')
    .startAt("1")
    .limitToFirst(1).once('value').then(function(snapshot)“`

  14. when the damn hipsters gather in one place they create something like Firebase. I can't even imagine how it got popular. I'm praying each day so there could be someone who can create something like Parse. When comparing Parse vs Backendless vs Firebase it is same if you compare JS Bach vs Sinatra vs my neighbour that sometimes sing in his bath. Horrible logic, 0 guides.

  15. I try to sort a list alphabetically (asc) for Turkish app, but letters like ö,ç,ş,I,ğ,ü goes to end of the list. How can I fix it? Thank you

  16. how can i query data by the data text i made a video because its kinda hard for me to explain https://www.youtube.com/watch?v=BW7jWxNfeE0&t=61s

  17. It would be good if they could use the find() method as seen in MongoDB, but for some reason, even though Firebase is essentially a fork of MongoDB, it doesn't contain any such method.

  18. why its not working in realtime in searchview? Query text = productreff.orderBy("Name").whereEqualTo("Name", searchView.getQuery()); after this step, my app has crashed

  19. Hello, it seems there is an error in the code shown at 4m19s. It should be const events = db.ref().child('events'); instead of const events = db.child('events'); (or const events = db.ref('events');)

  20. So let's say I have a books database and I want to search a substring in the books titles. Not clear if it's even possible !

  21. It's a evil query sintax I cannot found a simple query like this : select * from events where eventname like '%MEET%' and de case sensitive is a other evil Heeeellllpppppp

  22. https://stackoverflow.com/questions/57624782/how-to-retrieve-multiple-data-using-specific-field-in-firebase-database

Leave a Reply

Your email address will not be published. Required fields are marked *