233 questions
0
votes
1
answer
51
views
Efficiently read Firestore's document reference field contents
I'm trying out Firestore with this data model:
a collection of pokemon, where a pokemon is { name: string, move?: Ref<move> }
collection of moves, where a move is { name: string }
I have data ...
- 798
2
votes
1
answer
4k
views
How many databases are allowed in a single mongodb cluster?
I'm working with a system that requires multiple databases for multiple organisation. A monolithic node Js server connects to these databases. The challenge is I may have 5000 organisation.
I wanted ...
- 176
0
votes
1
answer
103
views
Getting more useful data from a lookup on a many-to-many relationship in Fauna
I have a users collection and an invitations collection. Users can invite multiple users. Records in the invitations collection document these invites. Each record in invitations is shaped like this:
&...
- 11.7k
0
votes
0
answers
22
views
Document stores (e.g. Firebase) - smaller documents or more updates?
I am learning Firebase after many years of using SQL RDBMSs. This is definitely a challenge.
Say, I have a collection of objects. Each object can belong to any number of categories. Categories have ...
- 9,484
0
votes
1
answer
783
views
How does DocumentDB failover happen if the the reader instance and writer instance have different instance types?
I have a DocumentDB cluster with exactly one replica instance ( db.r5.16xlarge ) and a primary instance ( db.r5.24xlarge ).
If something happens to the primary instance and a failover occurs, the ...
0
votes
1
answer
309
views
How to delete nested collections from an empty document in Firestore?
I have the following structure for one of my collections on Firestore:
main_database/root/comments/{commentId}/message: str
main_database/root/comments/{commentId}/replies/{replyId}/message: str
I ...
- 7,004
-2
votes
2
answers
245
views
Storing layered objects in a grid
Let's say I have a canvas where there are various objects I can add in, such as a/an:
Drawing
Image
Chart
Note
Table
For each object I need to store the dimensions and the layer order, for example ...
- 111k
0
votes
2
answers
134
views
Remove a child object in Fauna DB
I need to remove a child object in FQL. Let me demonstrate with the following example:
{
"1": {
"name": "test"
},
"2": {
"name&...
- 157
0
votes
1
answer
305
views
Full Text Search in OrientDB JSON Data
I have following data in OrientDB 3.0.27 where some of the values are in JSON Array and some are string
{
"@type": "d",
"@rid": "#57:0",
"@...
- 632
0
votes
1
answer
2k
views
How can I reduce the size of this JSON record?
I'm working on reducing the size of my database records. Each record is on average around 5Kb of which 97% is used by an single array property.
This array describe object on an image and their ...
- 2,008
1
vote
0
answers
113
views
$match in lookup stage without removing local documents in mongoDB
Right now I have a lookup stage that matches a collection of answers with their respective questions. The problem I'm having is that on the $match if the question does not having a matching answer ...
1
vote
1
answer
351
views
How to un-nest and group collections in mongoDB
I'm don't understand how to unwind and then nested collections in mongoDB. basically I have two collections that are structured like this:
questions doc:
{
"_id" : 1,
"questions&...
0
votes
1
answer
465
views
Save data to tinydb from android studio app
I have not used tinydb before. I am trying to insert some data to tinydb database using the android app.
I have checked many videos and blogs but still confused about how to use it.
How can I create a ...
- 446
0
votes
1
answer
427
views
How to query data from nested document in mongodb?
I'm struggling with this nested document too much. I tried to read the document and also follow other SO responses to see if it works for me, but I'm not getting the results that I'm looking for. I ...
- 865
5
votes
2
answers
901
views
How does MongoDB cursor behave when the collection is being changed?
Suppose I'm using the cursor to iterate a subset of the documents, ordered by some field let's say.
What happens if while iterating, a new document is being inserted or a current one is being deleted?
...
- 2,590