Parse XML feed every hour and store the new items in the DB

I do some thing with an xml feed whereby I have a table in my database for the feeds event IDs. When I parse and loop over the feeds events I add the IDs to an array which I compare against the table using the 'whereNotIn' query clause to see which events are new since last feed parse. You would then add the new events to the table to allow for future comparisons between feed and db.

@michaeldim and how do you do it every hour?

I run an artisan command every hour using Laravel's scheduler, https://laravel.com/docs/5.2/scheduling

Thanks! @michaeldim