With next plugin version we allow you to run shell commands with SQLite3 within the plugin. This way you can easily script import/export things and use all the commands the SQLite3 command line tool offers.
dim arguments() as string dim f as FolderItem = SpecialFolder.Desktop.Child("test.sqlite") dim o as FolderItem = SpecialFolder.Desktop.Child("out.csv") arguments.Append "sqlite3" // path to app arguments.Append f.NativePath arguments.Append "-csv" arguments.Append "-header" arguments.Append "-cmd" arguments.Append ".output "+o.NativePath arguments.Append "-cmd" arguments.Append "select * from Documentation;" dim n as integer = InternalSQLiteLibraryMBS.Shell(arguments) BreakAs our plugin supports encryption (SEE), JSON extension and full text indexing (FTS5), you can benefit from those, too. I think a few things can easily be automated in Xojo using this new interface. Please make sure you have the same database not open in your Xojo app the same time to avoid cache issues when writing to database.