[rmnclmnt]

Me too, and that lead to developing the « datasette-dashboards » plugin[0]. I use this for my company where all the data is gathered by connectors scheduled in CI, storing data in Git, and triggering a SQLite db build and Datasette deployment. « BI as Code » if you will

[0] https://github.com/rclement/datasette-dashboards

[pzmarzly]

How often do you refresh the data (how often your CI runs)?

[rmnclmnt]

Depends on the nature of the data and the requirements, can be every hour or once a day.

Most people and organizations have small/mid data and most of all slow data: you do not need fresh data every hour. If you do, you need a way heavier real time analytics data