Other functions from modernc.org/sqlite

[zakaria-chahboun]

Hi! First of all Thank you for this project 🌷

How i can benefit from other features with the modernc.org/sqlite driver?

For example, I can create a custom SQLite function by writing this:

import sqlite "modernc.org/sqlite"

func main() {
// register a new sqlite function! easily: (e.g SELECT new_id();)
sqlite.MustRegisterScalarFunction("new_id", 0, newID)

// ....

}

But this function (and others) doesn't appear in your driver.

Thanks 🤗

[glebarez]

Sure,
you must directly use the underlying driver, which is a slight fork of modernc.org/sqlite

import (
   sqliteDriver "github.com/glebarez/go-sqlite"
  "github.com/glebarez/sqlite"
  "gorm.io/gorm"
)

// register a new sqlite function! easily: (e.g SELECT new_id();)
sqliteDriver.MustRegisterScalarFunction("new_id", 0, newID)

// create GORM DB
db, err := gorm.Open(sqlite.Open("sqlite.db"), &gorm.Config{})

[zakaria-chahboun]

Thanks!