All Questions
710
questions
0
votes
0
answers
79
views
Struggling with SQL vs NoSQL
I've got years of experience with SQL. I'm starting on a side project with a fairly simple (to me) data model. I've read a number of posts, articles, guides, etc. over the last few weeks and am trying ...
0
votes
3
answers
111
views
Adequate database structure for mixed data
I have to create a database for sensor measurements. I have scalar data like date, serial number, firmware version, etc., but I also have array data, basically sensor data in the form of a 1000-...
0
votes
1
answer
132
views
NoSQL or SQL database for thousands of rows / items in array every day?
I would like to keep data about number of views of cca 2.000 videos per day in DB. But let's say I would like to keep the data from the whole year. It would then be 730.000 rows in SQL DB, which I ...
1
vote
1
answer
267
views
How can I find matching elements in an array using CouchDB's Mango selector?
How can I find selected only elements included value during array elements using CouchDB's Mango API?
I tried $elemMatch, but I didn't get the result I wanted
Document
{
"id": &...
1
vote
1
answer
135
views
How to get a table name inside a pg query with json?
I'm trying to get a json with a table name inside with a row, I've trying:
Create a table:
create table if not exists customer (
_id serial,
first_name varchar(50),
constraint pk_customer ...
-1
votes
1
answer
512
views
Redis sort by score and date
I'm trying to strategies how to calculate position/rank based on score and date
I have a two pieces of data with the same score shown in the image below.
If i run the command
$ZADD usersScores 11 ...
1
vote
1
answer
44
views
Cassandra table data modeling
I just started to learn about Cassandra and I have a pretty specific question.
After looking at some videos and tutorials in my understanding there is 1 primary that includes partition keys and ...
1
vote
2
answers
2k
views
Filtering a Snowflake SQL SELECT statement
I'm trying to find a good maybe subquery strategy to select a value within a document by matching another value, with multiple documents. I can execute a query, but not in a scalable methodology for ...
3
votes
1
answer
2k
views
How to handle DB connection in Go when using Repository pattern?
Let's assume I have a very simple repository interface that only reads from target database:
type UserRepository interface {
read(ctx context.Context, id WHAT_TYPE_I_SHOULD_USE_HERE) models.User
}
...
1
vote
1
answer
116
views
How to include the result of the calculated column in another calculation with Iforels
I build a business automation app with Iforels. They allow using of custom formulas in a "function" field. The question is how to use values from the related Units if the value of the ...
-1
votes
2
answers
67
views
Choose the right Database for IoT
I'm wondering if someone in the community could help me to choose the right database for my use case. I have IoT data also, I expect to have about 2000(min) or 20,000(max) lines per hour. Which ...
-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 ...
1
vote
3
answers
3k
views
SQL vs NOSQL : Explanation for few points
After reading more than 100 documents on SQL vs NOSQL, I still have two questions.
1). How latency of NoSQL DB is better than SQL DB?
2). How NoSQL DB's are auto scalable?
3). How NoSQL DB stores ...
0
votes
1
answer
967
views
Designing tags system with nosql/elastic search
I have to design a system with this schema.
{
"documentId" : 123
"documentType" : "paper"
"tags" :["abc","xyz"]
//other meta data of ...
0
votes
1
answer
125
views
How do these database management systems practically behave during a network partition?
I am looking into deploying a database management system, replicated across regions (various data centers across a country). I am currently looking into the following candidates:
MongoDB (NoSQL, CP ...