Thanks to the help and advice I’ve recruited from this wonderful community over the past few years, my confounder @jeffdc and I have been able to build gallformers.org and accomplish a lot for the study of gall inducing organisms. Unfortunately, right now we’ve run into a bit of trouble and I’d like to ask for your help once again.
A month or so ago, our database mysteriously lost a small but indeterminate amount of data. Since then we have placed a moratorium on adding or editing the site, which is of course a significant barrier to progress on the work we’d like to do. The alternative risks data being permanently lost without knowing how or when or why. Unfortunately, Jeff is the only person on our team with the skills to diagnose and fix the issue, and he is unable to do that work for the foreseeable future.
At this point we’ve been crowdfunding money on Patreon for a year and have some funds accumulated for situations like this (whether to pay for new tools and services or for labor). Still, I don’t think we can afford to hire someone at market rates. If anyone in the iNat community (or someone you know) is able to help out, we would be very happy to pay what we can . I’d really like to get the site up and running again soon without losing confidence in the security of the data.
The technical specs for the site are here: https://github.com/jeffdc/gallformers
I would like to
- develop some idea of what happened to the data
- fix that underlying issue if feasible
- have a backup system that mitigates potential data loss
- have a system to log changes so that we have more information if this happens in the future
- have a system that compares backups to alert us to discrepancies
I don’t have a sense of how ambitious or arduous each of those steps are individually or together but any help with any of those issues would be much appreciated.
Thanks for any suggestions or connections you have!