How to enable load extension

[playaround88]

Hi, I use gorm sqlite(underlay use go-sqlite3) as my project's sql driver , and when I try to load an extension like below

db, err = gorm.Open(sqlite.Open(conf.Dsn), &gorm.Config{})
if err != nil {
	fmt.Println(err)
	panic(err)
}
db.Exec("SELECT load_extension('" + path.Join(execDir, "libsqliteipv4.so") + "')")

I got an error.

2025/01/02 11:01:08 /**/app/dao/db.go:58 not authorized
[0.026ms] [rows:0] SELECT load_extension('/**/libsqliteipv4.so')

but when I connect db file use shell cmd, use .dbconfig can see load_extension is default on, and exec SELECT load_extension('./libsqliteipv4.so') is OK!

sqlite>.dbconfig
      ...
     load_extension on

I have check that go-sqlite default is enabled load extension, but why I got this exception? and how can I fix, pls help

[rittneje]

I have check that go-sqlite default is enabled load extension

This is not quite true - extension loading itself is disabled by default. However, if you load an extension via SQLiteConn.LoadExtension or via SQLiteDriver.Extensions, then extension loading will be enabled temporarily.

These two are the only supported mechanisms. Consequently, attempting to use load_extension in your SELECT query is not supported.

I do not personally use gorm, but I suspect you'll need to do something like:

func init() {
    sql.Register("sqlite3_with_extension", &sqlite3.SQLiteDriver{
         Extensions: []string{ "libsqliteipv4.so" },
    })
}

// ...

db, err := gorm.Open(sqlite.New(&sqlite.Dialector{DriverName: "sqlite3_with_extension", DSN: conf.Dsn}), &gorm.Config{})

[playaround88]

@rittneje I tried, it works! THX very much！