LazyDB

Go SQLite collection for lazy people.

Include these feature:

• Create SQLite database file
• Migration with fs.fs
• Auto Backup when migration
• Manual backup by call function

Note: You must has CGO enabled to compile this project.

Get Started

Run this command:

go get github.com/dark-person/lazydb

An example to use this package as:

import (
    "embed"
    "fmt"

    "github.com/dark-person/lazydb"
)

//go:embed all:schema
var schema embed.FS

func main() {
    var err error

    // Init db
    db := lazydb.New(
        lazydb.DbPath("path/data.db"),    // Database path
        lazydb.Migrate(schema, "schema"), // Migration schema location
        lazydb.BackupDir("./backup"),     // Set auto backup directory
        lazydb.Version(2),                // Specify Version
    )

    // Connect to db, which will create file if necessary
    err = db.Connect()
    if err != nil {
        panic(err)
    }
    defer db.Close()

    // Force Backup
    err = db.BackupTo("somewhere/backup.db")
    if err != nil {
        panic(err)
    }

    // Migration performed
    backup, err := db.Migrate()
    if err != nil {
        panic(err)
    }

    if backup != "" {
        fmt.Println("Auto backup as migration performed: " + backup)
    }

    // Optional: Ensure connection is success
    if !db.Connected() {
        fmt.Println("Database is not connected")
    }

    // Usage here...
}