This package is a wrapper of many third party database drivers. The goal of this abstraction is to provide a common, simplified, consistent layer for working with different databases without the need of SQL statements.

You can read our online documentation at gosexy.org.

Use go get to download and install gosexy/db.

$ go get github.com/gosexy/db

This package provides shared interfaces and datatypes only, in order to connect to an actual database a wrapper is required.

• mongo
• mysql
• postgresql
• sqlite

You may want to read a more descriptive reference on how to connect to databases using gosexy/db.

Once you've installed a driver, you need to import it into your Go code:

import "github.com/gosexy/db/mysql"

We are going to use the mysql driver in our examples. If you want to use another driver (such as mongo) just replace mysql with the name of your driver and everything should work the same.

sess := mysql.Session(
  db.DataSource{
    Host:     "localhost",
    Database: "test",
    User:     "myuser",
    Password: "mypass",
  },
)

The db.DataSource is a generic structure than can store connection values for any database in a consistent way.

// Connection and authentication data.
type DataSource struct {
  Host     string
  Port     int
  Database string
  User     string
  Password string
}

Use your recently configured db.Database to request the driver to actually connect to the selected database using db.Database.Open().

// Setting up database.
sess := mysql.Session(
  db.DataSource{
    Host:     "localhost",
    Database: "test",
    User:     "myuser",
    Password: "mypass",
  },
)

err := sess.Open()

// Don't forget to close the connection when it's not required anymore.
if err == nil {
  defer sess.Close()
}

To know how to query the database you've just connected, please read the online reference.

You can also read gosexy/db documentation from a terminal

$ go doc github.com/gosexy/db

This is an evolving project, there are still some things to do:

• Add db.Upsert and db.Modify for SQL databases.
• Add CouchDB support.

2012/09/21 - Changing some methods parameters and return values, improving error handling and testing many data types.
2012/08/29 - Created the main site docs and moved the repo to "http://github.com/gosexy".
2012/07/23 - Splitted database wrappers into packages. Changed ``db.Where`` to ``db.Cond``.
2012/07/09 - First public beta with MySQL, MongoDB, PostgreSQL and SQLite3.