Thank you very much @rudo for this very complete and informative presentation of your ODK story, and for the resources you pointed out.
We started at the same time with the same tools and the same desire to use self-hosted and opensource tools!
A few comments on automation and reporting in a SQL context :
We used to directly read data from Aggegate's PostgresSQL database. As all our tools are connected to our own 15 years old PostgresSQL database, things were pretty easy and close to real-time access.
Since we switched to Central, we've developed PostgresSQL functions to automate data transfer from Central to our database and cron jobs to schedule them:
- central2pg in 2021
- and recently an alternative that makes use of pyODK : pl/pyodk.
Now that the magic ODK Team has made possible to filter OData subtables, we will be able to increase frequency of the cron tasks and we will be very close to real-time data access.
A few years ago, we needed to create web dashboards to display charts about chemical and physical characteristics of coastal lagoons.
We chose Redash (because it can export chart as images), but other tools were envisaged .
We didn't tried superset and we now have a lot of queries and dashboard in Redash.
AS Redash is now restarted as a community project, I think we'll continue a moment with it.
And even if we intensively use Redash, I really appreciate Metabase which can be installed as a server or as a desktop tool.
Both Redash or Metabase (I don't know for superset) miss an Odata connector that may be a game changer. A opensource dashboard tool easily connected to Central would be great.
Thanks again for you inspiring post !