All Questions
60
questions
0
votes
0
answers
23
views
database design for react native application with in app purchase
I want to design database schemas for react native applications that have in app purchase and free with ads. Can you help me or give me a link to a document or book about that issue? I'm so grateful
...
-2
votes
1
answer
123
views
What Would Be a Best Practice to Uniquely specify an Entry With a Boolean Flag in the Database?
Let's assume that we have a collection (or table) that is called students, and in our system, we need to persist the best student of all time, which is going to be one and only one among all the ...
- 11
-2
votes
1
answer
67
views
Store this data model as non-relational?
I am currently in a situation where I think of redesigning one of my classic relational database tables into a non-relational design and I am not sure if I should do it or not. Reason is that ...
0
votes
1
answer
807
views
Is the time complexity of querying an indexed column O(1)?
Let's suppose that table A has a column named X which is numeric and indexed.
If the query is something like:
find all rows where X is greater than some value
Is the time complexity of retrieving the ...
-2
votes
1
answer
814
views
Multiple tables vs one table with more columns
My chosen database is MongoDB. But the question should be independent.
So for example, each row of record will have a flag that can take 1 of 2 possible values.
What is the pro and con of:
Having 1 ...
-1
votes
1
answer
162
views
NoSQL or SQL for Data Structure [closed]
I'm building an app, and this is my first time working with databases. I went with MongoDB because originally I thought my data structure would be fitting for it. After more research, I've become a ...
- 661
-2
votes
1
answer
237
views
What is the best Database Model for Directed Graph Data structure? [closed]
Relational database systems or document-oriented database systems?
If you want to choose between SQL and NoSQL which database systems will you prefer for a family tree,
Are there any advantages of ...
- 2,198
0
votes
0
answers
70
views
Schema for logging music stream events
I have a music application with albums, playlists, and songs. I would like to be able to track streaming events (like plays) by user and stream location (album or playlist).
For example songs can be ...
- 1,811
1
vote
1
answer
82
views
Creating a DB for comment sections with multiple page tags
I'm having a tough time choosing the correct database (SQL, NoSQL) for this use case even though it's so common.
This is the main record -
Page:
Contains a number of fields (which will probably ...
- 1,910
0
votes
1
answer
259
views
Database Choice for a CSV file
I have a CSV file.
It has 5 columns, 4000 rows.
The database will have a single table, and each year I will add a new table to the database.
The tables itself will never be updated, they will be ...
- 157
0
votes
1
answer
2k
views
Custom user defined database fields, what is the best solution?
To keep this as short as possible I'm going to use and example.
So let's say I have a simple database that has the following tables:
company - ( "idcompany", "name", "createdOn" )
user - ( "iduser",...
1
vote
1
answer
440
views
Is it good to use DynamoDB for read-only write-once data?
I got a database of my country postal code with its respective district. (https://github.com/pentagonal/Indonesia-Postal-Code/blob/master/Json/postal_array.json )(about 13 MB in JSON)
Is it good to ...
- 1,995
0
votes
2
answers
400
views
Database design for not repeating items in user-feed
I'm working on a Data-modelling exercise, the objective of the exercise is to create a data model for a news-feed where posts do not repeat themselves.
If user A has seen post X, then post X should ...
- 1
0
votes
2
answers
245
views
Database design for partially changing data points, with history and snapshot functionality?
I'm looking for a best practice or solution, on a conceptual level, to a problem I'm working on.
I have a collection of data points (around 500) which are partially changed, by a user, over time. It ...
- 100
1
vote
2
answers
2k
views
Correct DB design to store huge amount of stock cryptocurrencies data in DB
I want to store large amount of cryptocurrencies data in db. Then I want to show nice javascript price graphs with historical prices on webpage.
Problem is that I am not sure what database design is ...
- 1,204