mirror of
https://gitee.com/johng/gf
synced 2026-06-06 02:25:47 +08:00
Database drivers
Powerful database drivers for package gdb.
Installation
Let's take mysql for example.
go get github.com/gogf/gf/contrib/drivers/mysql/v2@latest
# Easy for copying:
go get github.com/gogf/gf/contrib/drivers/clickhouse/v2@latest
go get github.com/gogf/gf/contrib/drivers/dm/v2@latest
go get github.com/gogf/gf/contrib/drivers/gaussdb/v2@latest
go get github.com/gogf/gf/contrib/drivers/mariadb/v2@latest
go get github.com/gogf/gf/contrib/drivers/mssql/v2@latest
go get github.com/gogf/gf/contrib/drivers/oceanbase/v2@latest
go get github.com/gogf/gf/contrib/drivers/oracle/v2@latest
go get github.com/gogf/gf/contrib/drivers/pgsql/v2@latest
go get github.com/gogf/gf/contrib/drivers/sqlite/v2@latest
go get github.com/gogf/gf/contrib/drivers/sqlitecgo/v2@latest
go get github.com/gogf/gf/contrib/drivers/tidb/v2@latest
Choose and import the driver to your project:
import _ "github.com/gogf/gf/contrib/drivers/mysql/v2"
Commonly imported at top of main.go:
package main
import (
_ "github.com/gogf/gf/contrib/drivers/mysql/v2"
// Other imported packages.
)
func main() {
// Main logics.
}
Supported Drivers
MySQL
import _ "github.com/gogf/gf/contrib/drivers/mysql/v2"
MariaDB
import _ "github.com/gogf/gf/contrib/drivers/mariadb/v2"
TiDB
import _ "github.com/gogf/gf/contrib/drivers/tidb/v2"
OceanBase
import _ "github.com/gogf/gf/contrib/drivers/oceanbase/v2"
GaussDB
import _ "github.com/gogf/gf/contrib/drivers/gaussdb/v2"
SQLite
import _ "github.com/gogf/gf/contrib/drivers/sqlite/v2"
cgo version
When the target is a 32-bit Windows system, the cgo version needs to be used.
import _ "github.com/gogf/gf/contrib/drivers/sqlitecgo/v2"
PostgreSQL
import _ "github.com/gogf/gf/contrib/drivers/pgsql/v2"
SQL Server
import _ "github.com/gogf/gf/contrib/drivers/mssql/v2"
Note:
InsertIgnorereturns error if there is no primary key or unique index submitted with record.- It supports server version >=
SQL Server2005 - It ONLY supports
datetime2anddatetimeoffsettypes for auto handling created_at/updated_at/deleted_at columns, because datetime type does not support microseconds precision when column value is passed as string.
Oracle
import _ "github.com/gogf/gf/contrib/drivers/oracle/v2"
Note:
- It does not support
LastInsertId. InsertIgnorereturns error if there is no primary key or unique index submitted with record.
ClickHouse
import _ "github.com/gogf/gf/contrib/drivers/clickhouse/v2"
Note:
- It does not support
InsertIgnore/InsertAndGetIdfeatures. - It does not support
Save/Replacefeatures. - It does not support
Transactionfeature. - It does not support
RowsAffectedfeature.
DM
import _ "github.com/gogf/gf/contrib/drivers/dm/v2"
Note:
InsertIgnorereturns error if there is no primary key or unique index submitted with record.
Custom Drivers
It's quick and easy, please refer to current driver source. It's quite appreciated if any PR for new drivers support into current repo.