I’m comfortable with setting up a MySQL database and happy to use another sql database if that’s more convenient.
I have a situation where data is being collected across the country by volunteers, and need to import that data into my DB. My excel-based brain wants to capture this in webforms which can be generate CSVs and imported to DB from there. But is there a way users of a mobile app can directly update a SQL DB?
I can’t see an existing mobile app designed to do this. If there isn’t one, how would I go about creating one?
I looked into android and SQLite APIs so I wonder, with no previous android development experience, how hard it would be to create an app for this? It wouldn’t need to be attractive, just functional.
The data would be simple string fields plus latitude and longitude.
