[Question] sqlite enable_load_extension #965

Activity

1. zredb

   changed the title [-]sqlite enable_load_extension[/-] [+][Question] sqlite enable_load_extension[/+] on Mar 26, 2025
2. gurza commented on Apr 28, 2025

   

   gurza

   on Apr 28, 2025

   Last edited by gurza

   More actions

   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?