Add implementation for MySQL

[philippgille]

While PostgreSQL is more popular among Gophers and maybe generally among projects with higher requirements (performance, features), MySQL is still the most popular open source relational database (management system).

It's SQL, so not a key-value store, but that doesn't keep us from creating a table like Item with a k text column as primary key and v blob column, or something like that.

It might be of use for people who already run MySQL and want to use gokv for simple key-value storage.

Also, TiDB is compatible with the MySQL protocol, so as long as there aren't any major differences (some required client-side configuration for example) and it works, this would be a plus (TiDB is a popular "NewSQL" databases).

[philippgille]

As Go offers database/sql as abstraction and you use drivers for specific databases, it might make sense to have a sql package with the main logic and a mysql, postgresql etc. package that just loads the appropriate driver and the package that's imported by a gokv package user.

But maybe it's best to first implement everything in one package and later just refactor when implementing PostgreSQL.

[philippgille]

Links:

• MySQL Reference Manual: https://dev.mysql.com/doc/refman/8.0/en/introduction.html
• Go SQL drivers: https://github.com/golang/go/wiki/SQLDrivers
• Go MySQL driver: https://github.com/go-sql-driver/mysql
  • https://godoc.org/github.com/go-sql-driver/mysql
  • https://github.com/go-sql-driver/mysql/wiki/Examples
• Tutorial: http://go-database-sql.org/