I am new to this community, and ODK in general. I am working in the pharmaceutical industry, and have limited coding knowledge. I started learning python and recently moved into web-development and other front-end stuff.
Apache, Tomcat, virtual debian machine, Aggregate
So far, I have been able to load numerical data from the SQL rows associated with certain forms, but I cannot seem to do that with the images. I have also found several question/ask sites stating that images should never be retrieved directly from a database, but rather just the file-path should be retrieved, and then the images should be stored in a directory on the server. As I understand the MySQL/Aggregate behaviour, the BLOB image is really the data, but is a binary file that needs to be reconstructed in order to get the full image?? In that case my question is this:
The questions I have
- Is there some API-tool to acces form-data (automatically! Remember I need the website to update with new submissions without retyping any code, as long as the forms stay the same).
- How do I acces and/or reconstruct image-data stored in the MySQL database, so that I can display it on my website.
PS: I have to keep everything offline, so anything including google fusion tables etc. won't do
Thank you so much!