How to update/write DuckDB in production environment
Initial situation:
I use a DuckDB (file-based) as a data source for a Streamlit dashboard. The DuckDB is initially filled with data from a legacy database and should then receive new records from the legacy database every x minutes so that the Steamlit dashboard always has up-to-date data.