sqlite

A pure-go wrapper for database/sql using logoove/sqlite

Usage

1. Replace modified sqlite lib in your go.mod

replace modernc.org/sqlite => github.com/fumiama/sqlite3 v1.29.10-simp
replace modernc.org/libc => github.com/fumiama/libc v0.0.0-20240530081950-6f6d8586b5c5

2. Use it

typerowstruct {
IDint// pkNamestring
}
db:=&sql.Sqlite{DBPath: "demo.db"}
err:=db.Open(time.Hour)
iferr!=nil {
panic(err)
}
err=db.Create("demotable", &row{})
iferr!=nil {
panic(err)
}
err=db.Insert("demotable", &row{ID: 123, Name: "Anna"})
iferr!=nil {
panic(err)
}
varrrowerr=db.Find("demotable", &r, "WHERE ID=123")
iferr!=nil {
panic(err)
}
fmt.Println(r)