Friday, October 10, 2025
HomeGolangIs there a package deal that implements the sql.DB interface and shops...

Is there a package deal that implements the sql.DB interface and shops the database in a file? – Getting Assist


I’m searching for a Go package deal that implements the official sql interface however shops all the pieces in a single file as I don’t want superior features.

It doesn’t have to behave like a SQL database requiring queries, drivers, or the like.

I imagine you’re searching for SQLite:

https://www.sqlite.org/index.html

And right here’s an article to get you began:

https://astaxie.gitbooks.io/build-web-application-with-golang/content material/en/05.3.html

@Willy I discovered https://github.com/mattn/go-sqlite3 a ache to make use of on some platforms as a result of it requires cgo.
Fortunately there’s a conversion of this db-driver to pure go: https://pkg.go.dev/modernc.org/sqlite.

Many tutorials don’t point out this selection.

how do I affirm that modernc.org/sqlite implements the sql.DB interface? i don’t see it at a look.

AFAIK it’s a drop-in alternative of mattn/go-sqlite3.
Right here’s a easy instance from the gitlab-repo: examples/example1/foremost.go · grasp · cznic / sqlite · GitLab

I’ve began utilizing GitHub – glebarez/go-sqlite: pure-Go SQLite driver for Go (SQLite embedded), didn’t understand there have been so many choices…

I had by no means discovered that one. Appears to be a fork of modernc with slight modifications to make it extra appropriate with GORM: https://github.com/glebarez/go-sqlite/points/96.

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments