✅ Storing JSON and User data in a multi-tenant application
Hello!
I'm developing a multi-tenant (multiple concurrent users) application.
I require a database for storing JSON configurations and user data (users, roles, permissions).
Not sure, whether to use a single relational database, or a relational for user data and non-relational for JSON.
I believe that Redis is out of the question, as it is an in-memory database; whereas, I need a more permanent storage for JSON configurations.
I'd prefer to use EF Core to simplify development efforts; however, I've found that it doesn't have that much support for NoSQL. E.g., there is no official EF Core driver for MongoDB.
My personal wish is to allow the resulting application to use any database provider - that is why I want EF Core, as doing this manually would be quite complicated.
Is my goal realistic?
Do you have any experience with such solutions?
If it is not realistic, how should I go about this?
I'm developing a multi-tenant (multiple concurrent users) application.
I require a database for storing JSON configurations and user data (users, roles, permissions).
Not sure, whether to use a single relational database, or a relational for user data and non-relational for JSON.
I believe that Redis is out of the question, as it is an in-memory database; whereas, I need a more permanent storage for JSON configurations.
I'd prefer to use EF Core to simplify development efforts; however, I've found that it doesn't have that much support for NoSQL. E.g., there is no official EF Core driver for MongoDB.
My personal wish is to allow the resulting application to use any database provider - that is why I want EF Core, as doing this manually would be quite complicated.
Is my goal realistic?
Do you have any experience with such solutions?
If it is not realistic, how should I go about this?
