@Marty_Flickinger While we’re waiting on him to reply, I have a related Q.
Under what circumstances would you have all Patients loaded into an app variable, vs. making REST calls to show Patients in a list?
In your 1st two paragraphs (of your reply), you mention 2 strategies, neither of which I use or am familiar with:
-
“If each patient is stored as an object in a local storage instance” - haven’t got there yet - but am wondering what considerations would be to do it this way? My data is in MSSQL - so is this something for that backend (I thought REST API was the way to get to this data, ala Xano) or is this something for GoogleSheets, firebase, etc.?
-
ok, you contrast this to “local storage”. So if Patients are NOT in local storage, then where are they?
And if in the cloud, then they were fetched when the app started all into a List?
…but then you say to “save the results to your local storage” - so I’m kinda confused.
Again, I’m a ‘real’ developer, not a no-coder. So I’m using REST API to get to my MSSQL data. And I have thought about loading data all into memory (so to speak) so I didn’t have to fetch each record constantly from the db for lists and detail pages.
Since you think Patients could be done this way, what would be the conditions where you would adopt this?
Can you manage 1000 Patients in this Object List? 10,000 ?
Would you load the Patient image too?
Or maybe just a thumbnail into the List?
If the client must be both iPhone and Android, is there a limit imposed by the OS on how big this List can be - and do we know how to calculate the exact storage requirements so I’d know what my Max COUNT of Patients could be?
If 1000 Patients is doable, and you know you’re only in a 400-person facility, then would you definitely adopt this approach?
Is it because its read-only?
Would accessing data be virtually instant? (vs. dependent on network)
To stay with the Patient example… what if I wanted to add notes. The majority of data IS read only, but I have a 500 character Note field in the main record. I may need to add something to this. I’m sure I can ask for the new note text, then POST that to the backend. Is it easy enough to re-GET that one field/record from SQL and update just that field in the List?
ok, sorry, lots of Qs. Skip them if you don’t have time and I’ll post a new thread.
thx
Jaymer…