At-event database submission concept

[jkleiber]

Summary
We need a way to submit data to the database defined in #19 and created in #20.

The following contingencies need to be considered and mitigated appropriately:

• Computer power loss / failure
• WiFi loss / unavailability
• LTE outages

Work Scope

• Craft a proposal for submitting data that is robust to the above scenarios
• Add the proposal to the repo as a markdown document

[PChild]

Do we want a QR scanner for this? They're not that expensive and are a good option for wifi / LTE being trash.

[jkleiber]

@PChild I was thinking that could be good if we do decide to do something like this:

Depending on what device is being scouted on, it could be good to have the scouts try to submit to the database directly over LTE and if that fails fall back on QR codes.

[linglejack06]

@jkleiber Would the data just be populated into a spreadsheet? from the QR Code or were we envisioning something more complex?

[jkleiber]

@linglejack06 basically if the app isn't able to connect to the server it would show a QR code. Then we could scan the QR code into a spreadsheet (would need an app/python script that does this) and upload when internet is available

I think @TheLumpiest had some ideas about using powersync to automatically upload when data is available but I'll let him explain his idea with that