The problem of closing the connection

[ussoft2011]

How should I close the connection? I couldn't find the close method. Please help me, thank you.

const instance = await DuckDBInstance.create(backPath, {
threads: '4'
});
const connection = await instance.connect();

[jraymakers]

There isn't a way to explicitly close a connection right now. See #55.

However, if you just drop your reference to the connection, say by setting it to null, it will be automatically closed when it is garbage collected. This usually happens in under a second.

[jraymakers]

Duplicate of #55.

[ussoft2011]

Thank you for your reply. My code environment is Windows 11, Node.js, and I'm using @duckdb/node-api in an Electron application to create a local DuckDB file, write data, and after performing a SELECT query, I delete the DuckDB file. According to your method, after writing data to DuckDB, I set instance and connection to null. However, the DuckDB file is still occupied when I try to delete it. Please help me, thank you

const instance = await DuckDBInstance.create(backPath, {
threads: '4'
});

const connection = await instance.connect();

} finally {

    if (instance) instance = null;
    if (connection) connection = null;
    if (pgClient) await pgClient.end();

}

[jraymakers]

For this use case, I think it'll work better to DETACH the database before you delete it. According to DuckDB's documentation, closing a connection won't fully disassociate DuckDB from any attached databases.