Hi @gmiliotis,
If I understand your question correctly, this isn’t specific to SQLite – it’s just about streaming the data. If so, you’d probably want to use some combination of st.experimental_rerun and the strategies described in the following threads:
- How to build a real-time live dashboard with Streamlit
- “Streamlit Streaming”
- Continuously updating dashboard
Caroline