Not exactly what you are asking for, but did you consider using sqlite in memory?
On Sat, 7 Aug 2021 at 23:23, Esteban Maringolo <emaring...@gmail.com> wrote: > I've been doing exactly that. It is, creating a new DB file for each > test, and I was having the same problem as you. > > I suggested a change to the driver to cover that situation: > https://github.com/pharo-rdbms/Pharo-SQLite3/pull/22/files > > Try applying that change and see if that works. > > I still prefer to recreate the database, it will give you a full fresh > start, and if you want you can halt before the deletion of the db, to > analyze its internal state. > > Best regards! > > > Esteban A. Maringolo > > On Sat, Aug 7, 2021 at 11:13 PM <vin...@gmail.com> wrote: > > > > Hi > > > > Actually I will just do a bunch of > > > > DROP TABLE IF EXISTS > > > > instead of dropping the db altogether. > > > > Thanks, Vince >