Database with VFS and Adiantum

[tatar6607]

	app := pocketbase.NewWithConfig(pocketbase.Config{
		DBConnect: func(dbPath string) (*dbx.DB, error) {
			const pragmas = "&_pragma=busy_timeout(10000)&_pragma=journal_mode(WAL)&_pragma=journal_size_limit(200000000)&_pragma=synchronous(NORMAL)&_pragma=foreign_keys(ON)&_pragma=temp_store(MEMORY)&_pragma=cache_size(-16000)"
			const vfsParams = "?vfs=adiantum&textkey=mySuperSecretKey123"

			dsn := "file:" + dbPath + vfsParams + pragmas

			fmt.Println("Opening DB with DSN:", dsn)
			return dbx.Open("sqlite3", dsn)
		},
	})

I want to use this on pocketbase and I am creating it using VFS and Adiantum. Can I manually open this database in any database browser, such as DBeaver?

[ncruces]

Short answer is no. You'd need whatever database browser you want to use to use this (ncruces) driver with the Adiantum VFS installed.

Long answer is it should be possible to port the VFS and make an SQLite runtime loadable extension for it; then you might be able to use that from other apps.

Porting the encryption code from Go to C would be moderately challenging, using github.com/psanford/sqlite3vfs and just adapting the Go code might be easier.

[tatar6607]

Thanks for your answer. There seems to be no other fast option than SqlCipher for use with database browsers.