Mixing
Postgres Vs Redis when you have static data
I already went through many urls like below tried to understand what can I achieved in my project. In My project, I've 25 thousand records which is pure static data which will not often gets changed. Around 90% opeations will be of GET (fetch data from using various conditions like findByUserIdAndGroupId or findByUserAndGroupId, findAddressByUserId).
Why Should I use Redis when I have PostgreSQL as my database for Django?
https://db-engines.com/en/system/PostgreSQL%3BRedis
https://dzone.com/articles/10-traits-of-redis
My current database is Postgres(around 12-15 tables only), since data is static 25K records, we're planning to move into redis (Redis as DB.. i.e., persistance store). But our current Postgres model is so complex, which has @ManyToMany, @OneToMany and @ManyToOne kind of relationships with each other*(hardly any data which has no relationship)* and business need bi-directional seaching mostly.
I found found that Redis doesn't support queries like ignoreCase, IN, LIKE etc. which would need for us as we mostly do the GET operations.
So considering above facts, I had the following queries. I know that Redisis not SQL, but I hope relationship can be done in Redis using SET to some extents. We've plan to use Spring Data Redis to perform CRUD operations instead of traditional RedisTemplate Queries.
1) How to model the data (POJO classes using @RedisHash) in order to achieve complex relationships. Since I need both ways of searching.
2) We're using PCF, so replication (Master-slave), will there be any issues to deploy redis in three diff data centers. Considering 1 Master & 2 salve?
We did not found any materials over web, which will suggest how to model data in such complex relationship or to what extents, complex modelling is possible. We know Redis is mainly support denarmalization, but what if we need relationship?
How to model Data in Redis for values Complex Data structure?
What will be the advantages of Redis over postgres under such conditions other than the Fast-Read ?..
postgresql redis jedis spring-data-redis
asked Nov 19 '18 at 18:29
PAAPAA
2,48221935
add a comment |
I already went through many urls like below tried to understand what can I achieved in my project. In My project, I've 25 thousand records which is pure static data which will not often gets changed. Around 90% opeations will be of GET (fetch data from using various conditions like findByUserIdAndGroupId or findByUserAndGroupId, findAddressByUserId).
Why Should I use Redis when I have PostgreSQL as my database for Django?
https://db-engines.com/en/system/PostgreSQL%3BRedis
https://dzone.com/articles/10-traits-of-redis
My current database is Postgres(around 12-15 tables only), since data is static 25K records, we're planning to move into redis (Redis as DB.. i.e., persistance store). But our current Postgres model is so complex, which has @ManyToMany, @OneToMany and @ManyToOne kind of relationships with each other*(hardly any data which has no relationship)* and business need bi-directional seaching mostly.
I found found that Redis doesn't support queries like ignoreCase, IN, LIKE etc. which would need for us as we mostly do the GET operations.
So considering above facts, I had the following queries. I know that Redisis not SQL, but I hope relationship can be done in Redis using SET to some extents. We've plan to use Spring Data Redis to perform CRUD operations instead of traditional RedisTemplate Queries.
1) How to model the data (POJO classes using @RedisHash) in order to achieve complex relationships. Since I need both ways of searching.
2) We're using PCF, so replication (Master-slave), will there be any issues to deploy redis in three diff data centers. Considering 1 Master & 2 salve?
We did not found any materials over web, which will suggest how to model data in such complex relationship or to what extents, complex modelling is possible. We know Redis is mainly support denarmalization, but what if we need relationship?
How to model Data in Redis for values Complex Data structure?
What will be the advantages of Redis over postgres under such conditions other than the Fast-Read ?..
postgresql redis jedis spring-data-redis
asked Nov 19 '18 at 18:29
PAAPAA
2,48221935
add a comment |
I already went through many urls like below tried to understand what can I achieved in my project. In My project, I've 25 thousand records which is pure static data which will not often gets changed. Around 90% opeations will be of GET (fetch data from using various conditions like findByUserIdAndGroupId or findByUserAndGroupId, findAddressByUserId).
Why Should I use Redis when I have PostgreSQL as my database for Django?
https://db-engines.com/en/system/PostgreSQL%3BRedis
https://dzone.com/articles/10-traits-of-redis
My current database is Postgres(around 12-15 tables only), since data is static 25K records, we're planning to move into redis (Redis as DB.. i.e., persistance store). But our current Postgres model is so complex, which has @ManyToMany, @OneToMany and @ManyToOne kind of relationships with each other*(hardly any data which has no relationship)* and business need bi-directional seaching mostly.
I found found that Redis doesn't support queries like ignoreCase, IN, LIKE etc. which would need for us as we mostly do the GET operations.
So considering above facts, I had the following queries. I know that Redisis not SQL, but I hope relationship can be done in Redis using SET to some extents. We've plan to use Spring Data Redis to perform CRUD operations instead of traditional RedisTemplate Queries.
1) How to model the data (POJO classes using @RedisHash) in order to achieve complex relationships. Since I need both ways of searching.
2) We're using PCF, so replication (Master-slave), will there be any issues to deploy redis in three diff data centers. Considering 1 Master & 2 salve?
We did not found any materials over web, which will suggest how to model data in such complex relationship or to what extents, complex modelling is possible. We know Redis is mainly support denarmalization, but what if we need relationship?
How to model Data in Redis for values Complex Data structure?
What will be the advantages of Redis over postgres under such conditions other than the Fast-Read ?..
postgresql redis jedis spring-data-redis
asked Nov 19 '18 at 18:29
PAAPAA
2,48221935
I already went through many urls like below tried to understand what can I achieved in my project. In My project, I've 25 thousand records which is pure static data which will not often gets changed. Around 90% opeations will be of GET (fetch data from using various conditions like findByUserIdAndGroupId or findByUserAndGroupId, findAddressByUserId).
Why Should I use Redis when I have PostgreSQL as my database for Django?
https://db-engines.com/en/system/PostgreSQL%3BRedis
https://dzone.com/articles/10-traits-of-redis
My current database is Postgres(around 12-15 tables only), since data is static 25K records, we're planning to move into redis (Redis as DB.. i.e., persistance store). But our current Postgres model is so complex, which has @ManyToMany, @OneToMany and @ManyToOne kind of relationships with each other*(hardly any data which has no relationship)* and business need bi-directional seaching mostly.
I found found that Redis doesn't support queries like ignoreCase, IN, LIKE etc. which would need for us as we mostly do the GET operations.
So considering above facts, I had the following queries. I know that Redisis not SQL, but I hope relationship can be done in Redis using SET to some extents. We've plan to use Spring Data Redis to perform CRUD operations instead of traditional RedisTemplate Queries.
1) How to model the data (POJO classes using @RedisHash) in order to achieve complex relationships. Since I need both ways of searching.
2) We're using PCF, so replication (Master-slave), will there be any issues to deploy redis in three diff data centers. Considering 1 Master & 2 salve?
We did not found any materials over web, which will suggest how to model data in such complex relationship or to what extents, complex modelling is possible. We know Redis is mainly support denarmalization, but what if we need relationship?
How to model Data in Redis for values Complex Data structure?
What will be the advantages of Redis over postgres under such conditions other than the Fast-Read ?..
postgresql redis jedis spring-data-redis
postgresql redis jedis spring-data-redis
asked Nov 19 '18 at 18:29
PAAPAA
2,48221935
asked Nov 19 '18 at 18:29
PAAPAA
2,48221935
edited Nov 21 '18 at 8:51
PAA
asked Nov 19 '18 at 18:29
PAAPAA
2,48221935
asked Nov 19 '18 at 18:29
PAAPAA
2,48221935
asked Nov 19 '18 at 18:29
PAAPAA
2,48221935
2,48221935
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53380651%2fpostgres-vs-redis-when-you-have-static-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53380651%2fpostgres-vs-redis-when-you-have-static-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
