Strategy help needed: storing data from another site.

Discussion in 'Programming' started by sarahk, Apr 13, 2020.

  1. #1
    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?
     
    sarahk, Apr 13, 2020 IP
  2. loki781

    loki781 Greenhorn

    Messages:
    25
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    13
    #2
    Save the data in your own db tables they will be much easier to query/search than serialized arrays.
     
    loki781, Apr 30, 2020 IP
    sarahk likes this.