All Questions
22
questions
-1
votes
1
answer
511
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 ...
0
votes
0
answers
115
views
Should I store an attribute with only 2 possible values has a Boolean, Number, or String in MongoDB?
So I have an attribute for a table that can either take on the values of yes or no.
What are some reasons I should store it as a Boolean: yes -> true, no -> false.
What are some reasons I should ...
1
vote
2
answers
246
views
Joining in Mongo DB?
For a hotel booking website, in SQL - let's assume I would have 2 tables
Booking
BookingId
startdate
enddate
cost
HotelId(fk)
Hotel
HotelId
Name
Location
etc
In SQL I would inner join Booking with ...
0
votes
1
answer
51
views
How to model a database with many users and a lot of rows for each user
I have an application in development which works with the last.fm API to retrieve a lot of information for a given last.fm user. For the moment I'm using MYSQL and working with a single user for the ...
1
vote
1
answer
154
views
Possibility of the conversion of sql data to nosql with nodejs
Is there any possibility of converting sql data to nosql schema and then saving it in mongo collections with nodejs??
0
votes
0
answers
181
views
Is conceptually wrong to use SQL with Node.JS?
I am starting to learn Node.JS and being an old school developer I grew up surrounded by SQL.
Now I have read that NoSQL (specifically MongoDB) is the perfect companion for Node.JS and so I was ...
3
votes
0
answers
487
views
The best approach to make a Document store on top of a Key/Value store?
There are some projects on GitHub which use a key/value store like leveldb and rocksdb to make a NoSQL/SQL store. For example levelgraph is a graph DB written in Nodejs and uses leveldb under the hood....
0
votes
3
answers
125
views
Using a database for a Node.js application that runs in the terminal
I'm currently writing a program that is a To-Do list that just runs locally on my machine in the terminal screen(written in node.js, no extra dependencies). I've set up everything and it works totally ...
2
votes
2
answers
4k
views
insert statement in nodejs for loop?
I am trying to insert multiple values into the nosql database cassandra, using an array, but when I use the code below, instead of adding a row for each of the values stored in foo5 it only ends up ...
0
votes
0
answers
194
views
How to design a Teacher-Parent database to cope with scale?
We are trying to build a teacher and parent communication platform. We have around 500 schools, 300,000 students, 30,000 teachers and 500,000 parents on the platform for the first-year.
Features ...
2
votes
1
answer
320
views
How should I make a follow system sql or nosql?
I'd like to programm a system where a user can follow another user but I don't know if I should do it with a nosql db like mongodb or any other or is it better with a sql (postgres)?
I know that with ...
0
votes
1
answer
266
views
node embed databases with faster search speed
Actually im using SQlite to store some list of "files" with some attributes, no relational data only one file with multiple data, so i think any relational or nosql DB is valid for me.
The problem ...
0
votes
1
answer
96
views
How to make choice between NoSQL and SQL? [closed]
My question is that I want to learn nodejs/express, and make a super simple web project. It would be a database with tables : users, video_games, categories.
The web site will just show list of games ...
0
votes
1
answer
202
views
NoSQL to SQL adapter design pattern
I have 2 existing applications that I'd like to bridge somehow. Both have similar domains (Product Catalogs), but the first application uses a NoSQL document store for records, and the 2nd application ...
1
vote
1
answer
72
views
DB Architecture in a Node.js environment
Say we have an app that allows people to like or dislike pictures.
This looks like a data-intensive application, as you would expect a huge amount of (dis)like requests, so say we chose Node.js for ...