I am currently planning a movie recommendation application. Within this context, the user can fill out a form including different information (e.g. title, description, etc.). The new entry gets then saved to an external database.
Amongst those fields, I also would like to include a category input where autocompletion suggestions are based upon previous category choices from other users. Adding a new category is also feasible and should appear as a new suggestion for later entries. In my current iteration, I included the categories as another table within my original database, but was unsure if this is the ideal approach (since a new query needs to be made to the external DB each time a new form is about to get filled)
Is my current approach too limiting (making unnecessary frequent requests to the DB)? Would an approach including Redis (or another key-value store) be a more suitable approach? I would really appreciate any critical feedback or alternative suggestions.