Recurring Events (dates)

Need help Database
1

Hi all,

I’ve done some research today but most the items I found are quite old, so I wanted to reach out to see if there is a new way of managing recurring events.

What I mean is, in my app, I want people to be able to create an event, say a pub quiz, that runs every Friday.

I’ve not started work on this yet, I’ve left it until the end so I wanted to see what the most efficient and easy to manage way to handle this is?

What are your thoughts.

Also, what is the most optimal way to store the information, i.e. creating an event for several years on every Friday for a particular venue seems like the basic way, but will this lead to bloat in the DB that would cause potential performance issues.

I will be clearing down events that have passed but it will still create a lot of entries.

Is there a plugin that people can recommend?

Thanks for any advice in advance.

Chris

2

Just store each instance of an event in the database.

will this lead to bloat in the DB that would cause potential performance issues.

no (that’s what databases are for)…

Are you sure you want to do that?..

3

Ok thanks, that makes sense from a DB perspective.

Has anyone implemented this before? Trying to get my head around the rules and how that would work in a workflow. I mean, I get the simple use cases of every 1 week. Take the start date of the first event and create another 7 days later. I get lost when I start to pick multiple days a week.