The significance of the framework's database component driver is that the various methods of upper-layer business operations with the database do not change, and you can switch to a new database by simply modifying the database type in the configuration.

We can achieve the design of interfaces in the database component to add third-party database drivers not supported by the framework by default or customize existing drivers. The development of a driver is not about fully developing a database protocol implementation code, but rather using an existing third-party database driver and integrating it with the framework's database component by implementing its interface, ensuring consistency in upper-layer operations.

Driver Registration

We previously mentioned the Driver interface. After implementing this interface, we can register a custom driver to the gdb module through the following method:

// Register registers custom database driver to gdb.
func Register(name string, driver Driver) error

The driver name name can be an existing driver name, such as mysql, mssql, pgsql, etc. When a driver with the same name is registered, the new driver will overwrite the old one.

Driver Implementation

Developing a custom driver and registering it to the gdb module is very simple. You can refer to the database type code examples already connected in the gdb module source code: https://github.com/gogf/gf/tree/master/contrib/drivers

It should be noted that the most common way to develop or modify a driver is to directly inherit from the existing *Core type, as the Driver interface will pass this type of object, for example:

// DriverMysql is the driver for mysql database.
type DriverMysql struct {
    *Core
}

// New creates and returns a database object for mysql.
// It implements the interface of gdb.Driver for extra database driver installation.
func (d *DriverMysql) New(core *Core, node *ConfigNode) (DB, error) {
    return &DriverMysql{
        Core: core,
    }, nil
}

Considerations

A new driver should at least implement the following interface methods:

Interface Method	Description
Open	Used to create a database connection.
GetChars	Used to get the safety/escape symbols of the database.
Tables	Returns the list of tables in the current/specified database.
TableFields	Returns field list information for the specified table.