sqlite

README

sqlite

This package provides support for native Go SQLite3 as well as various functions to provide compatibility with other databases.

The level of compatibility is based on our internal needs. Just because a function is missing doesn't mean that it can't be added. Submit a PR to add more support.

Targeted databases:

1. MySQL
2. BigQuery

Do The Right Thing

To get full compatibility with as much as possible, simply import this package:

import (
	_ "github.com/tekkamanendless/sqlite"
)

Specific Support

Due to the way that the https://gitlab.com/cznic/sqlite (modernc.org/sqlite) package works, we can only have one global implementation registered.

To manually register functions, you can use:

import (
	"github.com/tekkamanendless/sqlite/compatibility"
)

err := compatibility.Register(
	compatibility.OptionMySQL(),
	compatibility.OptionBigQuery(),
)

Gorm Driver

To use this with Gorm, use the Gorm driver.

import (
	"github.com/tekkamanendless/sqlite/driver/gorm/sqlite"
	"gorm.io/gorm"
)

connectionString := "file:testdatabase.db?mode=memory"
db, err := gorm.Open(sqlite.Open(connectionString), &gorm.Config{})