始终不知道如何优雅地关闭conn

[WalkCharlie]

[manzt]

Hi! I'm not entirely sure what the question is, but it looks like you're trying to close a previous conn before reopening it.

That's expected: marimo deletes a cell's own variables before it re-runs (it's a reactive notebook, not Jupyter). Since this cell defines conn, it can never see its own previous value, so globals().get('conn') is always None here.

The good news is you usually don't need to close it manually. When the cell re-runs, marimo drops the old connection and DuckDB closes it on garbage collection. Also with read_only=True, DuckDB allows multiple concurrent read connections to the same file anyway, so a lingering shouldn't lock you out. So this should be all you need:

conn = duckdb.connect(file_browser.path(index=0), read_only=True)

[WalkCharlie]

Thank you very much!

[WalkCharlie]

如果用marimo的同时使用duckdb -ui 还是不能正常关闭就连接，上图估计是办法