All Questions
14
questions
0
votes
1
answer
578
views
Use of secondary indexes in a redis database in comparison with SQL statements
I'm working with a redis database. I have already implemented Python code to access the redis server. The problem is that the code implemented is complex and not easy maintainable.
Secondary indexes ...
-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 ...
0
votes
3
answers
7k
views
How to make a 100% sure conditional update of a Redis key without lua?
I want to update a Redis key, but only if its value by the time of the update is equal to certain value.
Similar question has been asked on SO here and what I found were suggestions about a Lua ...
0
votes
1
answer
75
views
What's the best approach to showcase benefits from SQL - NoSQL environment?
I was asked to create a little environment showcasing benefits from using NoSQL - SQL hybrid over only SQL database. Since my background is mostly Admin/DevOps I have basic knowledge about databases, ...
1
vote
1
answer
347
views
For a key-value pair with simple values, is n't a relational database as good as a No-SQL database such as Redis?
Consider a key value pair in which both keys and values are strings. eg..
A key value pair that maps from long URL to short URL and vice-versa.
Long URL->Short URL.
A main advantage of no-SQL is ...
0
votes
1
answer
2k
views
Complex sorting for Redis on multiple keys. Building Activity Feed
I have a table with columns of data that use in SQL to sort a list of events by Id. We use this to show activity feeds of these events on our site but would like to move all this to redis. We've ...
2
votes
1
answer
4k
views
Porting from MySql to Redis
This is probably more of a two part question, but the main focus is really how to port data from MySql into Redis. I've read over [the process here][1] but its a bit over my head in terms of how that ...
0
votes
1
answer
441
views
NoSQL Design Principles vs. Joins
I have a set of users (user_id, user_name), and a set of attributes (attribute_id, user_id, attribute_key, attribute_value), so that each user has a username and key-value attributes.
In SQL, when I ...
0
votes
1
answer
299
views
Making Redis sets for fast lookup
I have query to find counts out of the table,
SELECT count(1) from table where
c1 in (1,2,3)
and c2 in (6,7,8)
-- and c1 != c2
Now, I would like to do same thing but using Redis (possibly ...
24
votes
8
answers
49k
views
Design Redis database table like SQL?
Suppose my database table structure is like this
id name college address
1 xxx nnn xn
2 yyy nnm yn
3 zzz nnz zn
If i want to get the student details based on the name in sql ...
0
votes
1
answer
1k
views
Convert SQL based application to Redis
I have a MS SQL based application, which main goal is to search through a table of companies.
This company table has several columns on which one could search. Like CompanyName, Address, PostalCode, ...
1
vote
1
answer
445
views
Should I use SQL or NoSQL to store a very large number of unique strings or integers?
I want to store a very large number (1,000,000s) of unique strings or integers for quick reference (this string exists in db/store or not).
There is no complex data relationships, just an ever ...
2
votes
1
answer
179
views
Opensource stat server?
I've been looking for an opensource stat server that supports the following requirements:
Local proxy to aggregate 100s stats per second, and sends those stats out to a central cluster (or single ...
1
vote
2
answers
649
views
relating data stored in NoSQL DB to data stored in SQL DB
Whats the best way to use a SQL DB along side a NoSQL DB? I want
to keep my users and other data in postgres but have some data that
would be better suited for a NoSQL DB like redis.
I see a lot ...