About Transaction Commit

[happydentist]

Cause work for data pipeline with sqlite, I must attach database, do some SQL data transformation, and vacuum to detach database. and do it over another database again

Due to need to vacuum and detach database, I must change the Transaction Commit to None(auto-commit) manually.

When do it on same sqlnb next time, I must change the Transaction Commit to None(auto-commit) manually again.

Can sqlnb to save the Commit type for do the script in the sqlnb notebook, for
(1) when open the sqlnotebook, can execute the script directly and smoothly
(2) sqlnotebookcmd command line operation execute the script directly and smoothly

Thanks for your working.