13,121 questions
-1
votes
0
answers
73
views
Migrate aws dynamo db from one region to another [closed]
I have a service running on aws fargate. This service is using dynamo db hosted in x region. I want to migrate my dynamo db from one aws region (x) to another (y).
If our services can accomodate ...
- 11
Advice
0
votes
1
replies
66
views
How to Install ScyllaDB Manager?
I'm new to ScyllaDB and I'm trying to install ScyllaDB Manager. However, I’m having trouble following the instructions on the official website because some steps seem to be missing.
Can anyone point ...
- 13
0
votes
2
answers
155
views
Randomly slow MongoDB queries
I have been experiencing slow mongo queries suddenly. The execution times varies very randomly. Initially I was suspecting this expensive aggregation operation :-
{
"appName": "XXXXXX&...
- 51
0
votes
0
answers
38
views
Smart way to get latest values in AceBase
My vehicle logbook app stores the data of the trips. It should also store the changes made to a specific trip; thus, anyone can see if and what data has been changed after the first entry of the trip. ...
- 76
0
votes
2
answers
77
views
Can a partial multikey index in MongoDB index only certain subdocuments of an array?
I have a MongoDB collection with documents containing an array of subdocuments. For example:
{
"_id": 1,
"addresses": [
{ "city": "New York", "...
0
votes
1
answer
52
views
How to model a many-to-many relationship in DynamoDB with composite keys and enforce unique (id, ruleId) pairs?
I have a DynamoDB table defined as follows:
Partition key: id (string)
Sort key: ruleId (string)
Example item:
{
"id": "123",
"ruleId": "abc"
}
What I want is ...
0
votes
0
answers
28
views
Datastax Graph Got "This notebook uses graph 'food_qs', but a Graph connection has not been made."
I have installed Datastax Enterprise 6.8, and installed Datastax Studio. When I go to Notebook "DataStax Graph QuickStart v6.8.0", I got error says "DataStax Graph QuickStart v6.8.0&...
- 3,682
2
votes
0
answers
127
views
Why do I get NULL values when fetching rows?
I’m testing GridDB Cloud with the C client. I insert a couple of rows into a container, but when I query them back, the row values sometimes come out as NULL (empty), even though I just inserted data.
...
- 21
0
votes
1
answer
63
views
Referencing by SHA256 unique documentID vs. referencing by the field that generated the unique SHA256 unique documentID [closed]
I’ve been working on a React/Firebase app for the past 10 months, and things have been smooth so far. Recently, I decided to do some refactoring.
I switched from using user-generated fields as unique ...
- 53
0
votes
0
answers
40
views
Cassandra5 BATCH Atomicity and Isolation
I'm trying to reason about the consistency model of BATCH in Cassandra 5. The official documentation has contradictory statements in multiple places and the behavior does not appear to be well defined ...
1
vote
1
answer
53
views
How should I model a DynamoDB entity with partially unique external IDs
We're using DynamoDB with the Single Table Design pattern for our system, and I need help modeling the Response entity.
Context
Our platform allows users to create Panels for recruiting participants ...
- 137
0
votes
1
answer
37
views
Return all calls between 2 date in dynamoDB
I want to select all calls happened or at least started or ended between 2 date range in dynamodb. Partition key is some id and sort key is leftRoom. Is it correct approach? left is end time, started ...
1
vote
1
answer
89
views
How does DynamoDB's LIMIT parameter work exactly?
Extending from DynamoDB Limit on query.
I have a use case where the need is to fetch the latest available exchange rate from table. I've considered the following setup:
partition key as currency_pair ...
- 15
0
votes
2
answers
82
views
Are use cases of Redis mutually exclusive? E.g is Redis either a cache or a DB or something else but not all at once?
I have not used Redis but from what I have read it can be either an application level cache or can be used as a durable storage i.e. a primary NoSQL DB.
Also in my understanding it is a in-memory ...
- 4,529
-4
votes
1
answer
57
views
Any workarounds for simulating multiple full-text indexes per collection in MongoDB?
Currently 2025, MongoDB community edition is about only 1 full-text index per collection.
The scenario is this:
Collection C already has full-text for 3 fields: FieldA, FieldB, FieldC
Need to search ...
- 8,779
0
votes
0
answers
55
views
Auditing Api Request
I have many rest api(s) implemented in different spring boot applications, called by customers. There is common requirement to
Audit each customer request with outcome (success, no data, validation ...
- 305
0
votes
1
answer
77
views
OCI NoSQL query: PREPARE: Illegal Argument: The driver or SDK being used does not support complex query in python
I try to write a query to nosql Oracle Cloud with statement have count like below
nosql_client = oci.nosql.NosqlClient(config)
query = """
declare
$orgKey string;
SELECT count(*) FROM ...
1
vote
0
answers
26
views
How to fix 305009 SQL_PROC_MULTIPLE_TUPLE error in GridDB when using scalar subqueries?
I'm working with GridDB and have encountered an error that I'm struggling to resolve. The error message is:
305009 SQL_PROC_MULTIPLE_TUPLE ERROR SQL execution failed. Data operation may be duplicated. ...
- 91
1
vote
0
answers
14
views
How to resolve 305010 SQL_PROC_UNSUPPORTED_TYPE_CONVERSION error in GridDB?
I'm currently working with GridDB and encountered an error that I can't seem to resolve. The error message is:
305010 SQL_PROC_UNSUPPORTED_TYPE_CONVERSION ERROR SQL execution failed. Argument of data ...
- 91
0
votes
1
answer
48
views
Requesting clarity on PyMongo's maxIdleTimeMS parameter
per the official PyMongo's documentions for maxIdleTimeMS
maxIdleTimeMS (optional): The maximum number of milliseconds that a connection can remain
idle in the pool before being removed and ...
- 14
0
votes
0
answers
23
views
How to ensure data consistency for denormalized data in NoSQL?
I'm working on an event planning app using a NoSQL database that follows a denormalization strategy to avoid expensive joins. However, I'm facing a potential issue when updating denormalized data.
...
- 13
1
vote
1
answer
87
views
MongoDB: Creating an Index for Efficient Regex Search on a Text Field
I have a MongoDB collection where I store values as concatenated object references in a single string field. The values are structured like this:
{
"resource": {
"fields": {
...
- 43
0
votes
1
answer
83
views
Query objects by overlapping time ranges accross multiple categories
10M+ Markers (Time Ranges in certain )
300k+ Referenced Objects (Videos)
Markers having a structure like this:
{
id: 123,
category: 2,
object: 'A',
start: 10,
end: 25
}
...resulting in ...
- 15.1k
1
vote
2
answers
94
views
How do I wait for Elasticsearch to finish cloning an index?
I'm doing Elasticsearch reindexing as a multistep process using the JavaScript client library:
Clone index named "old" to a new index named "new"
Delete "old" index
...
- 1,017
1
vote
0
answers
54
views
Unexpected Behavior with TimeWindowCompactionStrategy in ScyllaDB 6.1 Open Source
I’m using ScyllaDB 6.1 Open Source and have a table configured to store 30 days of data with the following compaction strategy:
compaction = {
'class': 'TimeWindowCompactionStrategy',
'...
0
votes
0
answers
24
views
How to have the search term also work on the referenced models in mongodb
I am trying to write a service which should be also capable to search across the referenced model. i.e,
async getAllSubmissions(
paginationDto: PaginationDto,
sortDto: SortDto,
...
- 23
0
votes
1
answer
40
views
How to efficiently list recently active group chats for users without fan-out writes in 1000+ member groups?
I'm using a two-collection approach (userChats and chats) for quickly accessing a user's group chats as opposed to the use of an extremely long participant array of user IDs. However, I am struggling ...
- 111
0
votes
0
answers
23
views
How to ensure cosmosDb noSql atomicity across multiple different document write collections
In our noSql database we have multiple collections like users, posts etc.
In some mutations in our backend we would like to do write operations on both the users and posts collection, however if one ...
1
vote
1
answer
455
views
MongoDB Compass Update fails with
I'm using Mongo's Update functionality to flip a simple flag from 25 records matching a specific criteria. The database contains 50 million records.
Matching criteria:
{ 'profile_merge.success': false,...
- 3,307
0
votes
0
answers
131
views
Configuring an elasticsearch8 cluster with a token
Please, I would like to install an Elasticsearch 8 cluster on 3 servers running on Ubuntu 20.04.
I started by installing Elasticsearch8 on the first server:
wget -qO - https://artifacts.elastic.co/GPG-...
- 55
3
votes
1
answer
98
views
Keeping Data In Denormalized NoSql Databases (Cassandra/ScyllaDb) Tables In Sync?
I am new to NoSql databases like Cassandra/ScyllaDb and trying to wrap my head around NoSql database tables design and how to keep duplicated data in multiple tables in sync. I just read this post ...
- 3,361
1
vote
0
answers
32
views
MongoDB and celery configuration
I am new to celery and there isn't alot of great documentation to follow esepcially with mongodb.
I am essentially trying to have celery post messages to two different collections based on where ...
0
votes
0
answers
45
views
How to Handle Database-Agnostic Queries for Relationships in Spring Data JPA?
I’m working on a Spring Boot application where I need to fetch groups associated with a user based on their ID. Currently, I’m using the following approach in my repository:
@Query("SELECT g FROM ...
- 33
0
votes
1
answer
38
views
In DynamoDb, how do I optimize away extra joins when accesing data records that are often fetched together
Let's say that I am running a forum, where each user can make multiple posts.
So I structured my database the following way: (with unrelated columns omitted)
PK
SK
STRING_0
POST,post_id
thread,seq_num
...
- 4,948
2
votes
2
answers
277
views
DynamoDB Conditional Delete When Item Might Not Exist
I’m trying to perform a DeleteItem operation in DynamoDB with the following conditions:
If the item with a given primary key (PK) does not exist, the delete operation should succeed.
If the item ...
- 129
0
votes
0
answers
57
views
Why does my MongoDb query in Node.js not return any results?
I have the following cookie cutter code, that just simply looks to select records with a specific field value (that I know exist in my database) with a MongoClient:
await client.connect()
const db = ...
- 23
0
votes
1
answer
46
views
Efficiently Querying Firestore for Newsfeed with Large Followed User Lists to Reduce Costs
I’m working on a Firestore-based social app where users can see a newsfeed of posts. The feed includes:
Public posts (sourcePrivacyStatus === PUBLIC).
Newsfeed type posts (newsfeedType === NEWS_FEED)....
- 49
0
votes
1
answer
48
views
How to Optimize DynamoDB Data Model. Please advise
I'm currently working on a DynamoDB data model for an application that manages workout plans - to try get more knowledge of DynamoDB.
Each plan has multiple workouts, and each workout has multiple ...
- 3
1
vote
2
answers
57
views
MongoDB Query with Multiple $or Operators Not Returning Expected Results
Original Query Works but Adding Additional $or Condition Fails
I have a MongoDB query that successfully returns 2 results:
{
"state": "Review",
"type": "Test&...
- 106
0
votes
1
answer
57
views
How to find co-connected nodes with 'k' relationships? - Neo4j
I'm having a large Neo4j database, below is the small subset of nodes and relationships.
I have 3 different kind of nodes:
(Pink) Customers
(Blue) Transactions
(Yellow) Terminals
It's easy to find ...
- 36
0
votes
1
answer
46
views
Dynamodb NON-distributed service: worthwhile to use low cardinality ID as partition key and high cardinality ID as sort key?
I understand the concept of hot keys in Dynamodb: if there is a video game database and country_code is used as partition key while player_id is used as sort key, then when everyone from the same ...
- 159
1
vote
1
answer
308
views
Cassandra SAI (Storage Attached Indexes) on Cassandra 5, Free Version
We want to utilize SAI on Cassandra Free version. To enhance search capabilities, we have gone through Apache Solr => Apache Startio => Cassandra Lucene Index. But these are not maintained, ...
- 123
1
vote
1
answer
39
views
How to remove the "_deleted_conflicts" field from the document?
When I called CouchDB with HTTP POST /{db}/_design/{designDoc}/_view/{view} I received a document with the field "_conflicts": ["{conflictRev}"].
So I used HTTP POST /{db}/...
0
votes
1
answer
154
views
multiple lambda trying to update DynamoDB, how to make sure that its consistent?
I have a situation where 8-10 lambdas are constantly reading and writing in same DynamoDB table and often same record. How to avoid race condition in this situation ?
The scale of operation is in ...
0
votes
1
answer
70
views
Using Django JSONField Like a NoSQL Database for a Quiz Application [closed]
I'm developing a Django-based quiz website and would like to use a JSONField in the Quiz model to store questions in a manner similar to NoSQL databases like MongoDB. My plan is to store questions as ...
- 83
1
vote
0
answers
63
views
MongoDB Aggregations: Why is $group slow with indexed string fields but not on date?
Setup
Imagine this document shape:
{
dateString: "2024-10-31", // type string
realDate: ISODate("2024-10-31"), // type date
}
Assume both fields are indexed separately.
...
- 1,091
0
votes
0
answers
10
views
Rank of a document in firebase sorted collection [duplicate]
I am implementing a leaderboard where the users can see the top 10 users with highest points. This is easily doable by ordering the users collection with points and fetching the top 10. But I'd also ...
2
votes
2
answers
336
views
How to insert an ObjectId into a document in mongo and golang
I'm having a problem inserting an ObjectId into a doc.
this is the collection sale model
type Sale struct {
ID primitive.ObjectID `bson:"_id,omitempty"`
Client primitive....
- 23
-1
votes
1
answer
45
views
How should the device store save the groupId if you have a new device and an account? [closed]
App users are stored in collection users and groups in collection groups. At a high level a user is part of one group. When you log in you are asked to either join or create a group.
I store the ...
- 967
1
vote
0
answers
47
views
Does MongoDB discard and delete a batch from memory after being loaded and processed?
Actually I was trying to learn about the behavior of itcount() method and the impact of its behavior on the time that it takes to respond.
I thought that after using itcount(), at the end, all the ...
