Hi
I like to develop my db schema as I develop the code - TDD-style. So I need to
keep dropping the database each and every time I need to update the schema and
rerun the code. The problem is that even though I close the connection using
#ensure: the reference remains and I cannot delete the database file
immediately.
```
buildSchema
```
```
| fp |
```
```
```
```
(fp := self dbFilePath asFileReference) exists
```
```
ifTrue: [ fp delete ].
```
```
```
```
[
```
```
self db beginTransaction.
```
```
self writeSchema; writeData.
```
```
self db commitTransaction ] ensure: [ self cleanUp ]
```
I even tried running this before everything else to no avail:
```
SQLite3Connection allInstancesDo: [ :each | each close ].
```
```
SmalltalkImage cleanUp.
```
```
SmalltalkImage current garbageCollect.
```
I keep getting a #CannotDeleteFileException because there is still a reference
to the database file. If I do wait a seemingly random amount of time, the
reference is cleared.
How can I get the VM to release the reference to the database file immediately?
Pharo 8/64-bit, Windows 10
Regards, Vince
