Firebase Realtime Database: Do I need extra container for my queries?2019 Community Moderator ElectionFirebase and indexing/searchQuery based on multiple where clauses in FirebaseHow Firebase realtime database works?How to order Firebase ListView (FirebaseUI) by custom property (not database value)What's the difference between Cloud Firestore and the Firebase Realtime Database?firebase realtime database queryHow to query thousands of values and only return ones in array - Firebase SwiftFirebase Database Reference doesn't detects the currently added nodeQuery for Realtime Database FirebaseQuery and Update Realtime Database in Cloud FunctionCan't get the return value from a method that retrieves data from Firebase Realtime database to use it in following line of code
Has a sovereign Communist government ever run, and conceded loss, on a fair election?
Why is there an extra space when I type "ls" on the Desktop?
Should I use HTTPS on a domain that will only be used for redirection?
Should we avoid writing fiction about historical events without extensive research?
Replacing tantalum capacitor with ceramic capacitor for Op Amps
Affine transformation of circular arc in 3D
The need of reserving one's ability in job interviews
Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?
Is "cogitate" an appropriate word for this?
PTIJ: Aliyot for the deceased
Why won't the strings command stop?
What is Tony Stark injecting into himself in Iron Man 3?
Learning to quickly identify valid fingering for piano?
I've given my players a lot of magic items. Is it reasonable for me to give them harder encounters?
I can't die. Who am I?
Where is the fallacy here?
Integrating function with /; in its definition
Is being socially reclusive okay for a graduate student?
How do you make a gun that shoots melee weapons and/or swords?
Why would the IRS ask for birth certificates or even audit a small tax return?
What's the best tool for cutting holes into duct work?
Can a space-faring robot still function over a billion years?
What is the meaning of option 'by' in TikZ Intersections
Using the imperfect indicative vs. subjunctive with si
Firebase Realtime Database: Do I need extra container for my queries?
2019 Community Moderator ElectionFirebase and indexing/searchQuery based on multiple where clauses in FirebaseHow Firebase realtime database works?How to order Firebase ListView (FirebaseUI) by custom property (not database value)What's the difference between Cloud Firestore and the Firebase Realtime Database?firebase realtime database queryHow to query thousands of values and only return ones in array - Firebase SwiftFirebase Database Reference doesn't detects the currently added nodeQuery for Realtime Database FirebaseQuery and Update Realtime Database in Cloud FunctionCan't get the return value from a method that retrieves data from Firebase Realtime database to use it in following line of code
I am developing an app, where I retrieve data from a firebase realtime database.
One the one hand, I got my objects. There will be around 10000 entries when it is finished. A user can select for each property like "Blütenfarbe" (flower color) 1 (or more) characteristics, where he will then get the result plants, on which these constraints are true. Each property has 2-10 characteristics.
Is querying here powerful enough, to get fast results ? If not, my thought would be to also setup container for each characteristic and put every ID in that, when it is a characteristic of that plant.
This is my first project, so any tip for better structure is welcome. I don't want to create this database and realize afterwards, that it is not well enough structured.
Thanks for your help :)
"Pflanzen" :
"Objekt" :
"00001" :
"Belaubung" : "Sommergrün",
"Blütenfarbe" : "Gelb",
"Blütezeit" : "Februar",
"Breite" : 20,
"Duftend" : "Ja",
"Frosthärte" : "Ja",
"Fruchtschmuck" : "Nein",
"Herbstfärbung" : "Gelb",
"Höhe" : 20,
"Pflanzengruppe" : "Laubgehölze",
"Standort" : "Sonnig",
"Umfang" : 10
,
"00002" :
"Belaubung" : "Sommergrün",
"Blütenfarbe" : "Gelb",
"Blütezeit" : "März",
"Breite" : 25,
"Duftend" : "Nein",
"Frosthärte" : "Ja",
"Fruchtschmuck" : "Nein",
"Herbstfärbung" : "Ja",
"Höhe" : 10,
"Pflanzengruppe" : "Nadelgehölze",
"Standort" : "Schatten",
"Umfang" : 10
,
"Eigenschaften" :
"Belaubung" :
"Sommergrün" : [ "00001", "00002" ],
"Wintergrün" : ["..."]
,
"Blütenfarbe" :
"Braun": ["00002"],
"Blau" : [ "00001" ]
,
performance firebase firebase-realtime-database
edited yesterday
KENdi
5,8392921
asked yesterday
Tjard LTjard L
32
add a comment |
I am developing an app, where I retrieve data from a firebase realtime database.
One the one hand, I got my objects. There will be around 10000 entries when it is finished. A user can select for each property like "Blütenfarbe" (flower color) 1 (or more) characteristics, where he will then get the result plants, on which these constraints are true. Each property has 2-10 characteristics.
Is querying here powerful enough, to get fast results ? If not, my thought would be to also setup container for each characteristic and put every ID in that, when it is a characteristic of that plant.
This is my first project, so any tip for better structure is welcome. I don't want to create this database and realize afterwards, that it is not well enough structured.
Thanks for your help :)
"Pflanzen" :
"Objekt" :
"00001" :
"Belaubung" : "Sommergrün",
"Blütenfarbe" : "Gelb",
"Blütezeit" : "Februar",
"Breite" : 20,
"Duftend" : "Ja",
"Frosthärte" : "Ja",
"Fruchtschmuck" : "Nein",
"Herbstfärbung" : "Gelb",
"Höhe" : 20,
"Pflanzengruppe" : "Laubgehölze",
"Standort" : "Sonnig",
"Umfang" : 10
,
"00002" :
"Belaubung" : "Sommergrün",
"Blütenfarbe" : "Gelb",
"Blütezeit" : "März",
"Breite" : 25,
"Duftend" : "Nein",
"Frosthärte" : "Ja",
"Fruchtschmuck" : "Nein",
"Herbstfärbung" : "Ja",
"Höhe" : 10,
"Pflanzengruppe" : "Nadelgehölze",
"Standort" : "Schatten",
"Umfang" : 10
,
"Eigenschaften" :
"Belaubung" :
"Sommergrün" : [ "00001", "00002" ],
"Wintergrün" : ["..."]
,
"Blütenfarbe" :
"Braun": ["00002"],
"Blau" : [ "00001" ]
,
performance firebase firebase-realtime-database
edited yesterday
KENdi
5,8392921
asked yesterday
Tjard LTjard L
32
Firebase Database queries can only order/filter on a single property. In many cases it is possible to combine the values you want to filter on into a single (synthetic) property. So in your case you could add:"Blütenfarbe_Blütezeit": "Gelb_Februar"and filter on that. For another example of this and other approaches, see my answer here: stackoverflow.com/questions/26700924/…
– Frank van Puffelen
yesterday
But even with such an approach there's a limit to the querying capabilities of Firebase, as it only has the querying capabilities that it can maintain under its main focus: scalable realtime data synchronization. If you need broader querying consider another/additional solution, such as Elasticsearch or Algolia. See stackoverflow.com/a/10559689/209103
– Frank van Puffelen
yesterday
add a comment |
I am developing an app, where I retrieve data from a firebase realtime database.
One the one hand, I got my objects. There will be around 10000 entries when it is finished. A user can select for each property like "Blütenfarbe" (flower color) 1 (or more) characteristics, where he will then get the result plants, on which these constraints are true. Each property has 2-10 characteristics.
Is querying here powerful enough, to get fast results ? If not, my thought would be to also setup container for each characteristic and put every ID in that, when it is a characteristic of that plant.
This is my first project, so any tip for better structure is welcome. I don't want to create this database and realize afterwards, that it is not well enough structured.
Thanks for your help :)
"Pflanzen" :
"Objekt" :
"00001" :
"Belaubung" : "Sommergrün",
"Blütenfarbe" : "Gelb",
"Blütezeit" : "Februar",
"Breite" : 20,
"Duftend" : "Ja",
"Frosthärte" : "Ja",
"Fruchtschmuck" : "Nein",
"Herbstfärbung" : "Gelb",
"Höhe" : 20,
"Pflanzengruppe" : "Laubgehölze",
"Standort" : "Sonnig",
"Umfang" : 10
,
"00002" :
"Belaubung" : "Sommergrün",
"Blütenfarbe" : "Gelb",
"Blütezeit" : "März",
"Breite" : 25,
"Duftend" : "Nein",
"Frosthärte" : "Ja",
"Fruchtschmuck" : "Nein",
"Herbstfärbung" : "Ja",
"Höhe" : 10,
"Pflanzengruppe" : "Nadelgehölze",
"Standort" : "Schatten",
"Umfang" : 10
,
"Eigenschaften" :
"Belaubung" :
"Sommergrün" : [ "00001", "00002" ],
"Wintergrün" : ["..."]
,
"Blütenfarbe" :
"Braun": ["00002"],
"Blau" : [ "00001" ]
,
performance firebase firebase-realtime-database
edited yesterday
KENdi
5,8392921
asked yesterday
Tjard LTjard L
32
I am developing an app, where I retrieve data from a firebase realtime database.
One the one hand, I got my objects. There will be around 10000 entries when it is finished. A user can select for each property like "Blütenfarbe" (flower color) 1 (or more) characteristics, where he will then get the result plants, on which these constraints are true. Each property has 2-10 characteristics.
Is querying here powerful enough, to get fast results ? If not, my thought would be to also setup container for each characteristic and put every ID in that, when it is a characteristic of that plant.
This is my first project, so any tip for better structure is welcome. I don't want to create this database and realize afterwards, that it is not well enough structured.
Thanks for your help :)
"Pflanzen" :
"Objekt" :
"00001" :
"Belaubung" : "Sommergrün",
"Blütenfarbe" : "Gelb",
"Blütezeit" : "Februar",
"Breite" : 20,
"Duftend" : "Ja",
"Frosthärte" : "Ja",
"Fruchtschmuck" : "Nein",
"Herbstfärbung" : "Gelb",
"Höhe" : 20,
"Pflanzengruppe" : "Laubgehölze",
"Standort" : "Sonnig",
"Umfang" : 10
,
"00002" :
"Belaubung" : "Sommergrün",
"Blütenfarbe" : "Gelb",
"Blütezeit" : "März",
"Breite" : 25,
"Duftend" : "Nein",
"Frosthärte" : "Ja",
"Fruchtschmuck" : "Nein",
"Herbstfärbung" : "Ja",
"Höhe" : 10,
"Pflanzengruppe" : "Nadelgehölze",
"Standort" : "Schatten",
"Umfang" : 10
,
"Eigenschaften" :
"Belaubung" :
"Sommergrün" : [ "00001", "00002" ],
"Wintergrün" : ["..."]
,
"Blütenfarbe" :
"Braun": ["00002"],
"Blau" : [ "00001" ]
,
performance firebase firebase-realtime-database
performance firebase firebase-realtime-database
edited yesterday
KENdi
5,8392921
asked yesterday
Tjard LTjard L
32
edited yesterday
KENdi
5,8392921
asked yesterday
Tjard LTjard L
32
edited yesterday
KENdi
5,8392921
edited yesterday
KENdi
5,8392921
edited yesterday
KENdi
5,8392921
5,8392921
asked yesterday
Tjard LTjard L
32
asked yesterday
Tjard LTjard L
32
asked yesterday
Tjard LTjard L
32
32
Firebase Database queries can only order/filter on a single property. In many cases it is possible to combine the values you want to filter on into a single (synthetic) property. So in your case you could add:"Blütenfarbe_Blütezeit": "Gelb_Februar"and filter on that. For another example of this and other approaches, see my answer here: stackoverflow.com/questions/26700924/…
– Frank van Puffelen
yesterday
But even with such an approach there's a limit to the querying capabilities of Firebase, as it only has the querying capabilities that it can maintain under its main focus: scalable realtime data synchronization. If you need broader querying consider another/additional solution, such as Elasticsearch or Algolia. See stackoverflow.com/a/10559689/209103
– Frank van Puffelen
yesterday
add a comment |
Firebase Database queries can only order/filter on a single property. In many cases it is possible to combine the values you want to filter on into a single (synthetic) property. So in your case you could add:"Blütenfarbe_Blütezeit": "Gelb_Februar"and filter on that. For another example of this and other approaches, see my answer here: stackoverflow.com/questions/26700924/…
– Frank van Puffelen
yesterday
But even with such an approach there's a limit to the querying capabilities of Firebase, as it only has the querying capabilities that it can maintain under its main focus: scalable realtime data synchronization. If you need broader querying consider another/additional solution, such as Elasticsearch or Algolia. See stackoverflow.com/a/10559689/209103
– Frank van Puffelen
yesterday
Firebase Database queries can only order/filter on a single property. In many cases it is possible to combine the values you want to filter on into a single (synthetic) property. So in your case you could add:
"Blütenfarbe_Blütezeit": "Gelb_Februar" and filter on that. For another example of this and other approaches, see my answer here: stackoverflow.com/questions/26700924/…– Frank van Puffelen
yesterday
Firebase Database queries can only order/filter on a single property. In many cases it is possible to combine the values you want to filter on into a single (synthetic) property. So in your case you could add:
"Blütenfarbe_Blütezeit": "Gelb_Februar" and filter on that. For another example of this and other approaches, see my answer here: stackoverflow.com/questions/26700924/…– Frank van Puffelen
yesterday
But even with such an approach there's a limit to the querying capabilities of Firebase, as it only has the querying capabilities that it can maintain under its main focus: scalable realtime data synchronization. If you need broader querying consider another/additional solution, such as Elasticsearch or Algolia. See stackoverflow.com/a/10559689/209103
– Frank van Puffelen
yesterday
But even with such an approach there's a limit to the querying capabilities of Firebase, as it only has the querying capabilities that it can maintain under its main focus: scalable realtime data synchronization. If you need broader querying consider another/additional solution, such as Elasticsearch or Algolia. See stackoverflow.com/a/10559689/209103
– Frank van Puffelen
yesterday
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55022538%2ffirebase-realtime-database-do-i-need-extra-container-for-my-queries%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55022538%2ffirebase-realtime-database-do-i-need-extra-container-for-my-queries%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Firebase Database queries can only order/filter on a single property. In many cases it is possible to combine the values you want to filter on into a single (synthetic) property. So in your case you could add:
"Blütenfarbe_Blütezeit": "Gelb_Februar"and filter on that. For another example of this and other approaches, see my answer here: stackoverflow.com/questions/26700924/…– Frank van Puffelen
yesterday
But even with such an approach there's a limit to the querying capabilities of Firebase, as it only has the querying capabilities that it can maintain under its main focus: scalable realtime data synchronization. If you need broader querying consider another/additional solution, such as Elasticsearch or Algolia. See stackoverflow.com/a/10559689/209103
– Frank van Puffelen
yesterday