All Questions
2,872
questions
-2
votes
0
answers
18
views
How do I implement friendships between users in cloud firestore? [closed]
I'm using Node.js. I currently have a collection with users and I want to model friendships between them. The frontend should be able to query all the friends of a user with the profile picture and ...
- 9
-2
votes
1
answer
41
views
How does Tinder gives me only new profiles? [Database design]
I have probably swiped 10k profiles either left or right.
If I open the app tomorrow I will get 10 profiles I have never seen.
How can these profile be queried efficiently?
For sure an SQL query of ...
- 317
-2
votes
0
answers
27
views
Designing a MongoDB Schema for Efficiently Managing and Querying Ordered Sequential Values [closed]
I have a mongoDB collection findings which contains the following documents
{
name: "finding1",
group: "group1"
},
{
name: "finding2",
group: "group1"
},...
- 161
0
votes
1
answer
35
views
Setting primary key in Realm MongoDB
I am trying to make a collection of cocktail recipes. In this case, every recipeName field in Realm object is unique. Then can I set recipeName to be the primary key so that I can call useObject() ...
- 11
0
votes
0
answers
45
views
Database integrity in mongo DB with hooks
I am trying to use mongo DB for my MERN app. So far I have used SQL databases where database integrity has never been an issue.
But mongo being No-SQL does not support foreign key relation which is ...
1
vote
2
answers
62
views
What is the most suitable data type for a column in a table?
Currently I'm trying to develop a PostgreSQL database schema, it has only 2 tables, one of which contains usernames. The difficulty is that for certain reasons I cannot store the username directly, so ...
- 1,245
0
votes
0
answers
46
views
MongoDB: Filter array field based on entry from the same array
Given the following collection
db.playground.insertMany([
{ "id": 1, "tags": [{"t": "T1", "v": "t11", "c": 1 }, {"t": &...
- 3,003
1
vote
0
answers
33
views
Error Installing griddb-c-client on macOS Ventura v13.0 with Homebrew
I am trying to install the griddb-c-client on my macOS Ventura v13.0 using Homebrew in order to set up GridDB on my device. However, I am encounter the following error:
Error: griddb/griddb-c-client/...
- 21
0
votes
0
answers
33
views
which database is suitable
I have a postgres as main database. Couple tables are huge, they store approximately 5 million rows. So my query usually contains couple joins which are super expensive, so I decided to denormalize ...
- 23
0
votes
0
answers
17
views
i already created the usersdb but it does not show
i already created the usersdb but it does not show
mongo
MongoDB shell version v3.6.19
connecting to: mongodb://127.0.0.1:27017/?gssapiServiceName=mongodb
Implicit session: session { "id" : ...
0
votes
1
answer
25
views
Failed to search a substring in mongodb text search
I have implemented search functionality in my application where the user able to search across the database. So for that I have applied text index on one of the field named title. I am using the below ...
- 3,161
0
votes
0
answers
26
views
PlanExecutor error during aggregation :: caused by :: Exceeded memory limit for $group, but didn't allow external sort. Pass allowDiskUse:true
I'm working on a project where I need to calculate TF-IDF scores for news articles stored in a MongoDB collection. I've implemented a MongoDB aggregation pipeline to perform this calculation, but I'm ...
- 33
0
votes
0
answers
41
views
Cascade delete from linked models in Isar database flutter
so i implemented a todo model in isar , where each todo task can have a taskgroup, while each taskgroup can have multiple tasks, i used links as stated in the documentation. But my issue now is how to ...
- 3
1
vote
0
answers
12
views
Bug in GridDB code: Incorrect calculation results when querying data
I'm working on a project that utilizes GridDB, a high-performance NoSQL database optimized for IoT and big data applications. In my project, I'm implementing a feature that involves querying data from ...
0
votes
0
answers
25
views
etcd transaction Commit() returned "Succeeded: false", but value was stored?
I have an issue with etcd transaction, I have following piece of code:
for attempt := 1; ; attempt++ {
resp, err := kv.Tnx(ctx).
If(clientv3util.KeyMissing(key)).
Then(clientv3.OpPut(key, ...
- 264