How to proper close database? after colse statement still exists about dart-sqlite HOT 2 OPEN

You (and, of course, mostly an authors of this software) should learn how works the sqlite and how to properly use sqlite.
Your problem not in your code, the problem which you are experiencing only in that the authors of this software does not provided the correct way to use sqlite.
If they are professionals then I think they will be able to find the problem in a few minutes.

from dart-sqlite.

Thanks @mezoni for the stellar comment, this is super helpful.

@HannesRammer could you give more insight into what doStuff does? IIRC there will be issues if you get a stream of rows and do not reach the end of the stream (which takes care of disposing the underlying resources). You might need to get a StreamSubscription and cancel when you're done with it.

from dart-sqlite.