Skip to main content

Questions tagged [nosql]

Databases that propose alternative solution to SQL (Relational) Database which can be document oriented, key/value, graph, objects,...

Filter by
Sorted by
Tagged with
0 votes
1 answer
58 views

Database Modeling for Application with Many Integrations

I’m working on an application that requires many 3rd-party integrations. I’m using Postgres to store these API responses but am having trouble for a number of reasons. These objects are frequently ...
Jack's user avatar
  • 109
0 votes
3 answers
93 views

Python API - store data in SQL AND NoSql

I am a student and am currently programming an API in Python. Among other things, it is possible to register, log in, create a user profile with data, etc. I would like to be able to store and ...
flo's user avatar
  • 1
0 votes
1 answer
73 views

Alternative ways to transfer records from one environment to another

I'm working on an application which has a feature of syncing records between two environments. For example, a record A is created in environment A. After a user verifies it, the user can use the sync ...
Lucifer Darknight's user avatar
1 vote
1 answer
3k views

SQL or NoSQL Database for a chat application?

currently I am working on a kind of "Chat" Application. The app consists of "threads". Each of this threads consist of "subthreads" in wich a user can send a message (...
Vito's user avatar
  • 65
1 vote
1 answer
547 views

Is DynamoDB optimistic locking with one version attribute for each field in an item a valid design pattern?

It's common to implement optimistic concurrency control in DynamoDB by giving each item in the database a top-level "version" attribute and only allowing an update of an item to succeed if ...
fblundun's user avatar
  • 111
0 votes
0 answers
212 views

How would I model my NoSQL database for a conversational bot

I'm currently developing a chatbot that will be used for booking trips. The particular party I'm interested in for now is the rider. I'm using AWS's DynamoDB, because it seemed to be the most flexible ...
AlePouroullis's user avatar
1 vote
1 answer
361 views

How to represent NoSQL entities

I've mainly studied SQL structures, and I know that the representation of the entities can look something like this: However, I'm building this app with MongoDB, so NoSQL DB. I'm aware that MongoDB ...
fel.jim's user avatar
  • 13
0 votes
1 answer
411 views

Store UUID Reference vs. storing string in Mongodb

I am trying to store user preference for notifications. One way to do is store types of notification in separate collection and store UUID of that notification type in user table. e.g. notification-...
Anonymous Creator's user avatar
1 vote
2 answers
1k views

How to document a NoSQL document-based data model?

How do you document the logical data model of a document-oriented database like MongoDB? For relational databases, Entity-Relationship diagrams or UML class diagrams are used. What is the practice for ...
ssn's user avatar
  • 71
2 votes
3 answers
487 views

Do NoSQL and non-relational refer to the exact same concept?

Question as the title says. Of course, I already tried searching online, but did not find a definite answer yet. (The sources I checked imply that the terms are interchangeable, but do not state this ...
Attilio's user avatar
  • 487
-2 votes
2 answers
195 views

Avoid redundant field using JSON type in MySQL [closed]

I have experienc with designing relational dbs but first time attempting to store JSON in a mysql table. I am using mysql 5.7.8 which has the ability to store json data type as a column. When I create ...
simgineer's user avatar
  • 139
0 votes
1 answer
75 views

Table design question - DynamoDB the right choice?

Our team has started to use AWS and one of our projects will require storing approval statuses of various recommendations in a table. There are various things that identify a single recommendation, ...
CustardBun's user avatar
0 votes
1 answer
770 views

Is it a good practice to add a range key to an AWS dynamo table even if there is no need in current specification?

I am using AWS dynamodb for my project. One can choose to use a simple key (partition key alone) or a composite key (partition key + range key) when creating a dynamo db table. But once it is created, ...
Anthony Kong's user avatar
0 votes
0 answers
96 views

Storing common data across tenants in NoSQL databases like mongoDB

We are designing a multi-tenant architecture. In our multi-tenant architecture, there are different email templates that are shared across all the tenants. Email template looks like subject: {...
Paramjeet Desai's user avatar
0 votes
2 answers
249 views

Saving & Referencing different Schema Types in MongoDB (e.g. for a CMS with Building Blocks)

Say I wanted to build my own CMS system and store data in MongoDB. I would like to have a Collection called BlogArticle. Each article can have a different structure, but will be put together by the ...
antonwilhelm's user avatar
-2 votes
1 answer
169 views

Can I manage a NoSQL database with only JavaScript?

I am creating an app with Deno (a personal project), and I manage the "database" with only the Javascript code of the Deno enviroment, modifying JSON files like any other JS object. For me, ...
Imagitori's user avatar
0 votes
1 answer
326 views

AWS Architecture: How to search in Dynamodb?

Firstly, I want to state that this is my first time trying to build an app. I am doing this for fun, mostly as an exercise to learn system design/architecture. The goal is to build an app that would ...
fractalnature's user avatar
0 votes
1 answer
539 views

Can we do domain modelling or create domain entities/models in NoSQL like Amazon DynamoDB? If yes then how?

Recently I was going through an article (link at the end) on AWS for DynamoDB NoSQL and got to know that they are suggesting to only have a single table with certain access patterns in your NoSQL ...
Pulkit Gupta's user avatar
1 vote
1 answer
206 views

Thoughts on adding a DB collection with a single record for version

I'm building an application with Google Firebase and Firestore that has its structure defined in the DB. This structure is not very big and doesn't change all that often. This structure is stored in ...
Jonathan's user avatar
  • 129
4 votes
0 answers
931 views

Relational or non-relational database for storing and querying log data?

I'm planning to extend an application with logging of user events. (Client application via REST-API to Symfony). What is the preferred type of databases? Currently the log data is stored in a ...
yellowduck's user avatar
1 vote
3 answers
3k views

When would I pick NoSQL over SQL when dealing with partly schema-less data?

so, I'm currently developing a feature for a website of mine, which aims to gather a set of financial data from the user so the user can start and take care of a budget, as well as the website ...
Sossenbinder's user avatar
-4 votes
1 answer
607 views

How to create an Event-Driven Architecture with many external sources

I work for this Accounting company - as a Product Owner - that uses several external services (one for Contract management, another one for Accounting Demands management, a third one for Financial ...
Otto Neres's user avatar
-3 votes
2 answers
55 views

Does it make sense for a large scale SaaS project to use a single all powerful SQL/RDBMS database?

Scalability seems to be a thing now. I was in a heated argument with one of my developer who insist on using MySQL for a data intensive application we are building. MySql is easy, fits the purpose and ...
user1034912's user avatar
1 vote
2 answers
649 views

What's the use of a wide-column NoSQL db such as Cassandra over a K-V store or a document based db?

Say we're making a simple photo app. This link says that we can store the image in S3 and now have a URL. Great. Next, we need a mapping of a UserID to the many images they've created. For this, it ...
user2495123's user avatar
-4 votes
1 answer
99 views

Keeping JSON in database

I'm trying to create web app(flask or django-rest) that would scrape some data and save it to JSON so that it can be viewed in the frontend (VueJS). I'm wondering if it is better to save the scraped ...
Alex T's user avatar
  • 161
-1 votes
3 answers
178 views

Can I manage thousands of concurrent connections with a non-Node stack?

I'm developing a social network with Django (Python) + Postgres SQL. My site will have a chat feature so that users can communicate to each other in real-time, and the communication will be only from ...
Fran's user avatar
  • 9
0 votes
0 answers
201 views

Creating group/application/user permissions around mongodb documents

I'm trying to find a good way to manage permissions for a high number of mongo documents. What I want to do: Apply group/user/and or application permissions to mongo documents. Idea 1: Use mysql to ...
daynok's user avatar
  • 1
-3 votes
1 answer
90 views

Saving large files like Credit Reports in Data Store - SQL/NoSQL/ObjectStore

I am working on a project to save external credit bureau reports in database. These reports are typically big and could go from 0.5MB to 5.0 MB. Number of files will grow exponentially over the time ...
RajaC's user avatar
  • 9
4 votes
1 answer
565 views

What *really* is the difference between relational and non-relational data?

Here is where I am at right now: I know that relational data, like that found in relational databases like MySQL or Postgres, is relational because there are relations between the tables. That is the ...
IchBinGrumpig's user avatar
1 vote
0 answers
57 views

Partial database synchronisation across multiple databases

Currently we are looking for a solution to sync databases across multiple locations. We a location hierarchy such as Country -> State -> District -> Center. To increase speed and reliability of the ...
Saryu Labs's user avatar
1 vote
1 answer
56 views

Storage and partitioning in Cosmos DB

I'm working on designing a system for reporting/storing information on hardware devices (IoT-like), and trying to figure out how that would best be structured in Azure's Cosmos DB. Every device will ...
Bobson's user avatar
  • 4,648
1 vote
1 answer
60 views

Firebase prefer separate collections over mixed collection?

I'm writing an education app and my current Firebase structure looks like: Course ∟ Lesson ∟ Modules (Includes video, audio, text and quiz modules in one collection) Where "Course", "...
Nolence's user avatar
  • 129
1 vote
1 answer
139 views

Query by NoSQL keys versus SQL hash

I am trying to decide between a NoSQL (MongoDB) or a SQL (Oracle) database for my project. This database will be used to store output files from a set of parameters. I can model this as a MongoDB ...
Gabriel Robaina's user avatar
1 vote
2 answers
461 views

System design for filtering/sorting objects whose properties are stored in distributed storage

Imagine that we have a storage of objects O (can be in SQL, NoSQL, doesn't matter) where the object contains some property P_1 to P_n. Some of these properties are stored in storage S1, some in ...
Aditya Santoso's user avatar
1 vote
1 answer
137 views

Uncertain of cache solutions for CAD models

I am running a personal project of offering 3D model generation as a service (in this case CAD model). Since most of the generation of 3D models take a long time, I thought about using cache to ...
Gabriel Robaina's user avatar
3 votes
1 answer
529 views

Is it recommended to use schemas on non-relational databases?

I'm trying to figure out if the use of schemas on non-relational schemaless databases like MongoDB is a recommended practice or a bad practice to be avoided. I am doing research work and am looking ...
Javier Scars's user avatar
2 votes
3 answers
108 views

How should I best structure my app when I want to sort a "parent" model by a property computed on another "child" model?

Question about OO-programming, functional programming, NoSQL, SQL databases, and software architecture Hi all, I am a intermediate-level self-taught programmer, and have been dying to get an answer ...
troglodyte's user avatar
0 votes
1 answer
770 views

Optimizing inserting/storing Large amount of data in database

We have a POST API that takes data from the Client and send it to different applications (Payment, Email, SMS). We also store all the data sent by the Client in a database for future analytics ...
Ahmad's user avatar
  • 139
2 votes
2 answers
1k views

Designing database: split into different tables or group them together?

I am fairly new to database design and now trying to build my own forum-based application. The app will have nested categories as countries > systems > levels > subjects In every subject ...
tnkh's user avatar
  • 123
0 votes
2 answers
187 views

Gathering data from JSON fields in a relational database

I'm working on a small e-commerce solution which uses MySQL. At first there was an initiative by the boss to use MongoDB but I suggested relational database because there are lot entities with ...
Nikola Stojaković's user avatar
0 votes
0 answers
75 views

What is the correct way of setting and then differentiating between paid and free user in Firebase / Firestore?

I am developing a mobile application that will have both free and paid versions. The way I see how I could differentiate between what is a paid and free user is to set a property isPaid on their ...
Edvinas's user avatar
0 votes
1 answer
34 views

Update items based on a read operations on same items is a bad practice?

DynamoDB is the database solution, I'm using to store my items. It's a NoSQL/Document database and I got a real problem on real-time updates of items. First, the saved format is like { expiredTime:...
trmaphi's user avatar
  • 101
9 votes
3 answers
2k views

How to update a NoSQL database and publish event atomically in an event-driven microservices architecture?

In an event-driven microservices architecture, services typically need to update their domain state and publish an integration event to a service bus at the same time (Either both operations complete, ...
J. Doe's user avatar
  • 101
0 votes
0 answers
25 views

Efficiently querying for a set of objects for price comparison

I am designing a system where a user can input a budget and a query returns to them sets of objects that they can afford from different vendors. The system has 100s of different combination types (i.e ...
Samuel Innocent-Primus Mungy's user avatar
4 votes
4 answers
2k views

Database agnostic DAO (NoSQL + SQL)

Background While writing a new component, I m in middle of making a decision of SQL/NOSQL database (Mongo vs Mysql) for my storage layer. As of today, mysql seems to be a perfect fit for my use-case (...
Harshit's user avatar
  • 151
-1 votes
2 answers
158 views

Some Suggestion about Data Modeling

I want to make a social game for Android. I am using NoSQL Based Database (MongoDB) and I am using NodeJs. I am using Android-Volley library to make POST and GET requests. But I am stucked on ...
Falzao's user avatar
  • 1
12 votes
5 answers
1k views

My team is scared of relational database entities with foreign key relationships and I don't understand why

I'm relatively fresh out of college so most of my familiarity with relational databases is from my databases course where anything not in BCNF or 3NF is a travesty. Certainly that's one end of the ...
MichaelCook's user avatar
1 vote
1 answer
417 views

Some Guidance on Parent-Child Relationships in Elasticsearch

I would like some guidance in setting up my document structure Elasticsearch. The company I work for has an app that stores around 20,000 new phone records each day in a SQL database. And we feel we ...
Matt Spinks's user avatar
0 votes
2 answers
561 views

Most efficient way to get unique customer count

I'm working on a system that stores details of customer purchases for several stores. One statistic that they would like is to know how many unique customers they have had over a specified day range, ...
Thomas Wormald's user avatar
2 votes
1 answer
94 views

Alternatives to RDBMS For Forecast Data

I currently capture well structured forecast data in a SQL Server. An example of this data is below: What this tells me is that each day, I receive a forecast for the next three days. Note that in ...
GinjaNinja's user avatar

1
2 3 4 5