[Question] sqlite enable_load_extension

[zredb]

For the SQLite database in SQLX, Do you support the enable_load_extension function? how can i load sqlite extension when i use Sqlx?

[gurza]

You can access the underlying sqlite driver to enable and load extensions.

Using mattn/go-sqlite3

import (
        ....
	"github.com/jmoiron/sqlx"
	_ "github.com/mattn/go-sqlite3"
        "github.com/mattn/go-sqlite3"
)

you can do

err = conn.Raw(func(driverConn interface{}) error {
	sqliteConn, ok := driverConn.(*sqlite3.SQLiteConn)
	if !ok {
		return fmt.Errorf("failed to get SQLiteConn")
	}
	if err := sqliteConn.LoadExtension("/path/to/your/extension.so", ""); err != nil {
		return fmt.Errorf("failed to load extension: %v", err)
	}
	return nil
})
if err != nil {
	// handle error
}

@zredb does this approach suit you?