Hi,
I have a postgree database connected to my apps and have structure like this (In reality, my database have more than 3 binary files on that table)
So, this table was getting the data from user input. In reactive web app i have no problem to do that. Just create multiple upload widget and assign manually to each field. But i've encountered problem when develop the mobile app.
The users want this form have autosave feature and offline mode. So i created new entity in local storage to accomodate that. My plan was to create exact replica of my postgre database in local storage, so i will have no problem when syncing the data to server db. But since os only allow just 1 field with binary type attribute, i can't sync the data seamlessly.
I have read post here , but is it efficient to implement that to my case (external db with more than 1 binary file field in one table)?
It's obvious you cannot have a 1:1 model of your external db, so why don't you split the entity in two? Something like this:
Where BinaryType is something like this: