beedb mysql_Golang(7)Database Layer

Golang(7)Database Layer

5.1 database/sql Interface

sql.Register

Register(name string, driver driver.Driver) register the driver you add to the golang system.

https://github.com/mattn/go-sqlite3

func init() {

sql.Register(“sqlite3”, &SQLiteDriver{})

}

https://github.com/mikespook/mymysql

var d = Driver{proto: “tcp”, raddr: “127.0.0.1:3306” }

func init() {

Register(“SET NAMES utf8”)

sql.Register(“mymysql”, &d)

}

For example

import (

“database/sql”

_ “github.com/mattn/go-sqlite3"

)

If we import this package, it will automatically call the init method in that package.

driver.Driver

type Driver interface {

Open(name string) (Conn, error)

}

The name parameter will be used to retrieve the database connection info.

We can use this Conn to do one go routine execution, but you can not use it twice.

driver.Conn

type Conn interface {

Prepare(query string) (Stmt, error)

Close() error

Begin() (Tx, error)

}

Tx is short for transaction.

driver.Stmt

type Stmt interface {

Close() error

NumInput() int

Exec(args []Value) (Result, error)

Query(args []Value) (Rows, error)

}

driver.Tx

type Tx interface {

Commit() error

Rollback() error

}

driver.Execer

type Execer interface {

Exec(query string, args []Value) (Result, error)

}

driver.Result

The response and return value of Update/Insert

type Result interface {

LastInsertId() (int64, error)

RowsAffected() (int64, error)

}

driver.Rows

Return value of Query

type Rows interface {

Columns() []string

Close() error

Next(dest []Value) error

}

Columns is the Column information from Table

driver.RowsAffected

type RowsAffected int64

driver.Value

type Value interface{}

It can hold all the different types of values. For example: int64, float64, bool, []byte, string, time.Time

driver.ValueConverter

driver.Valuer

database/sql

type DB struct {

driver driver.Driver

dsn     string

mu      sync.Mutex

freeConn     []driver.Conn

closed     bool

}

5.2 Using MYSQL DB

https://github.com/go-sql-driver/mysql

5.3 Using Sqlite DB

https://github.com/mattn/go-sqlite3

Sqlite3 administrator tool

http://sqliteadmin.orbmu2k.de/

5.4 Using PostgreSQL DB

https://github.com/lib/pq

5.5 BeeDB

5.6 NoSQL (Not Only SQL)

redis, mongoDB, Cassandra, Membase

…todo…

References:

https://github.com/astaxie/build-web-application-with-golang/blob/master/ebook/05.0.md

Redis 1~ 6

http://sillycat.iteye.com/blog/1549504

http://sillycat.iteye.com/blog/1553507

http://sillycat.iteye.com/blog/1553508

http://sillycat.iteye.com/blog/1553509

http://sillycat.iteye.com/blog/2028180

http://sillycat.iteye.com/blog/2033094

MongoDB 1 ~ 5

http://sillycat.iteye.com/blog/1547291

http://sillycat.iteye.com/blog/1547292

http://sillycat.iteye.com/blog/1547294

http://sillycat.iteye.com/blog/1965857

http://sillycat.iteye.com/blog/1965880