Convert big MySQL select to Firebase?


#1

Hi,

i would like to know, whether firebase is intended for big “select” statements with many “AND”/“OR” 's ?

I have a few big MySQL Select statements like:

"SELECT * ... WHERE .. X BETWEEN 1 AND 100 
                  AND  Y BETWEEN 100 AND 1000 AND Z BETWEEN 30 AND 150 AND ... AND ... AND... OR ... AND ... AND ... AND ...  GROUP BY ..."

Now i would like to switch from MySQL to Firebase if its possible to perform such select statements ?

Thank you :slight_smile:

Kind regards


#2

I would not recommend you to switch to Firebase (NoSQL).
All those select statements meens that you need a lot of relations so It would make more sense to use a RDBMS like which you are already using.