When I have time I dip into a wee project I'm building for my husband. Was urgent, covid19 makes it much, much less so. So, today I've had some time and my next step is working out a data strategy. My little project pulls data from Xero and aims to eliminate some of the steps to getting data and adding some functionality such as SMS reminders. We don't do a lot of transactions but even so some of our requests will exceed their limits, a bit of digging and it seems I'm expected to save a local copy of the records and just request records that have changed. Hmm, ok. That'll speed things up. so do I a) save each type of data in a serialised array and just work with that when I need it or b) create my own copies of their tables (smaller, I'll be storing less detail) and maintain them I was going with a) but thinking b) might be more work now but future proofed Has anyone worked on a project with that kind of data handling?