Popularity
2.2
Stable
Activity
0.0
Stable
32
4
2

Programming language: Go
License: MIT License
Tags: Database    
Latest version: v1.4.3

gosql alternatives and similar packages

Based on the "Database" category.
Alternatively, view gosql alternatives based on common mentions on social networks and blogs.

Do you think we are missing an alternative of gosql or a related project?

Add another 'Database' Package

README

GoSQL

Go Reference codecov

Query builder with some handy utility functions.

Documentation

For full documentation see the pkg.go.dev.

Examples

// Open database and create connection
sqliteDB, _ := sql.Open("sqlite3", "my-db.sql")
db := gosql.New(sqliteDB)

// Define a struct that includes a primary key
type User struct {
    ID       int `idx:"primary"`
    Email    string
    IsActive bool
}

// Insert a row into the table
db.Insert(&User{
    ID: 1,
    Email: "[email protected]",
    IsActive: true,
})

// Select a row from the table
var user User
db.Select("*").Where("id = ?", 1).Get(&user)

// Update the row in the table
user.Email = "[email protected]"
db.Update(&user)

// Delete the row from the table
db.Delete(&user)

Benchmarks

BenchmarkInsert-10                  5637        209484 ns/op         448 B/op         23 allocs/op
BenchmarkUpdate-10                 90866         12887 ns/op         576 B/op         27 allocs/op
BenchmarkSelect-10                 90318         13125 ns/op         768 B/op         41 allocs/op
BenchmarkSelectMany-10             12435         96761 ns/op       10640 B/op        838 allocs/op
BenchmarkSelectManyPtrs-10         10000        100512 ns/op       11248 B/op        938 allocs/op

Contribute

Make a pull request