spin_sdk::sqlite::Connection::Close() not exist

[seungjin]

Based on this doc: https://spinframework.dev/v3/sqlite-api-guide#using-sqlite-storage-from-applications-close,
the set of operations is common across all SDKs: open, execute and close.
But close is not exist in sqlite/libsql. (ref: https://docs.rs/spin-sdk/latest/spin_sdk/sqlite/struct.Connection.html)
(AS of April 7, 2025).

I am connecting libsql.
The connection is not closed. So my raw connection query from libsql shell are all blocked.

I believe there should be close() method in sqlite::Connection.
Am I wrong?

[rylev]

The docs are a bit misleading here. There is no explicit close method on a sqlite connection. The underlying connection will be closed when the Connection wit resource is dropped. In Rust, this is done automatically when the Rust struct is dropped. So, you shouldn't need to do anything for the connection to be closed.

Now, you're saying that you're seeing the underlying connection not actually being closed. That would be a bug then. How are you configuring your sqlite connection? Is this the "default" connection or are you using a runtime-config.toml file to configure how you're connecting to sqlite?

[seungjin]

Using multiple database with runtime-config.toml.
Let me confirm tomorrow whether it's a connection-closing issue or some delay caused by libsql that I'm currently experiencing.

[seungjin]

Seems I had some delay from libsql/sqld(Turso one) yesterday.
I can see external insert statement working - meaning spin closes its connection properly.

Seems documentation needs update. Not all SDK.

[itowlson]

Docs update has landed spinframework/spin-docs#86