Jet is a super-flexible lightweight SQL interface

Documentation on GoDoc

Example

func main() {
  // Open database
  db, err := jet.Open("postgres", "user=postgres dbname=jet sslmode=disable")
  if err != nil {
    panic(err)
  }

  // Set a logger
  db.SetLogger(jet.NewLogger(os.Stdout))

  // Create a migration suite
  var s jet.Suite
  s.AddSQL(
    `CREATE EXTENSION IF NOT EXISTS hstore`,
    `DROP EXTENSION IF EXISTS hstore`,
  )
  s.AddSQL(
    `CREATE TABLE "fruits" ( id serial, name text, attrs hstore )`,
    `DROP TABLE "fruits"`,
  )
  s.AddSQL(
    `CREATE INDEX "fruits_name_index" ON "fruits" ( "name" )`,
    `DROP INDEX "fruits_name_index"`,
  )

  // Run all migrations. The current migration version is stored, already applied migrations are not run twice!
  if err, _ := s.Migrate(db); err != nil {
    panic(err)
  }

  // Insert rows using a transaction
  txn, err := db.Begin()
  if err != nil {
    panic(err)
  }
  txn.Query(
    `INSERT INTO "fruits" ( "name", "attrs" ) VALUES ( $1, $2 )`,
    "banana",
    map[string]interface{}{"color": "yellow", "price": 2},
  ).Run()
  txn.Query(
    `INSERT INTO "fruits" ( "name", "attrs" ) VALUES ( $1, $2 )`,
    "orange",
    map[string]interface{}{"color": "orange", "price": 1},
  ).Run()
  txn.Query(
    `INSERT INTO "fruits" ( "name", "attrs" ) VALUES ( $1, $2 )`,
    "grape",
    map[string]interface{}{"color": "green", "price": 3},
  ).Run()
  if err = txn.Commit(); err != nil {
    panic(err)
  }

  // Select some rows
  var fruits []struct {
    Name  string
    Attrs map[string]interface{}
  }
  if err := db.Query(`SELECT * FROM "fruits"`).Rows(&fruits); err != nil {
    panic(err)
  }

  fmt.Println("FRUITS:", fruits)

  // Reset db
  if err, _ := s.Reset(db); err != nil {
    panic(err)
  }
}