Recurring Date - What is the best patterns?

I need to represent "recurring event" like "each month" with the goal to create a calendar view of them. The events can be unlimited in time.
What is the best way to represent this kind of data to permit query like "search all events between the 01/01/2021 and the 23/01/2021" ?
A first approach is to generate one entry for each event instance, but I'm afraid about the amount of data that can be generated, and this approach is difficult to imagine to handle unlimited event instance in the time.

Thank you for your advice,

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.