[Pharo-users] Re: Pharo-SQLite3: closing connections immediately and deleting the database file

[vinref]

Hi

Looking at SQLite3Connection>>#close:

"Let FFIExternalResourceManager take care."

        "dbHandle ifNotNil: \[ library close: dbHandle \]."

        dbHandle := nil.

        isOpen := false.

The commented out lines means that SQLite3Library>>#apiClose is not called when 
calling SQLite3Connection>>#close. 

But looking at https://www.sqlite.org/c3ref/close.html and 
FFIExternalResourceManager it seems like it should take care of releasing 
resources (i.e., finalizing prepared queries etc) before calling 
SQLite3Library>>#apiClose.

So this is by design?

I will have a go at finalizing everything and call SQLite3Library>>#apiClose, 
at least while developing.

Vince