Suppose I have two tables in my database. I want to build a service in elixir which should pick data from my database and cache each rows in redis keys. I want to use genserver and supervisor to do this. Can anyone tell me how do I go about it?

Do you really need to use Redis? If it is not mandatory to use it, then maybe just use GitHub - whitfin/cachex: A powerful caching library for Elixir with support for transactions, fallbacks and expirations · GitHub Instead.

Hi @siddhant3030 , I think that more information about your case would make it easier for people to help you with this: Why is Supervisor and GenServer a requirement? Is this an exercise/coding challenge, or you have specific needs with regards to resilience? If it’s about resilience, in order to…

[image] siddhant3030: Can anyone tell me how do I go about it? As @wanton7 suggests, cachex is fine. But I think it works best as a short term cache (like memcached). If you really want something that is still (fairly) easy to use would be to use either a new database table where you precalcu…

Before I start, is this an interview task or homework? If so, make sure that the company is ok with you sharing it here. It is quite likely that employees of companies working with Elixir hang out in this forum. That said, there are different ways to design such a service and split up responsibilit…

[image] lucaong: Before I start, is this an interview task or homework? Sounds like it. :smile:

It might very well be a learning question, I just don’t want people to get in trouble.

No. This is part of a project. I want to test a POC for this.

Then the best would be to describe more clearly the project goals, so people can help you better. What’s the end goal of your POC, or the problem you are trying to solve with it? I am asking because your description focuses on the what, but doesn’t mention the why, and that makes it difficult to de…