mysqlx

More Badages

Supported Go version

• Go 1.19+

Supported MySQL data types

• Signed Integers:
  • bigint(n), int(n), smallint(n), tinyint(n)
• Unsigned Integers:
  • bigint(n) unsigned: Should be configured as ubigint(n) in struct tag
  • int(n) unsigned: Should be configured as uint(n) in struct tag
  • smallint(n) unsigned: Should be configured as usmallint(n) in struct tag
  • tinyint(n) unsigned: Should be configured as utinyint(n) in struct tag
• Boolean:
  • BOOL
• String:
  • varchar(n)
  • char(n)
• Date / Time Types:
  • timestamp
  • datetime, datetime(n)
  • time, time(n)
  • date
  • year

Notes

Error sql: **** unsupported Scan, storing driver.Value type []uint8 into type *time.Time

reference: Stackoverflow

This is because sqlx does not parse *time.Time by default. Add "parseTime=true" parameter then opening MySQL with sqlx.

Changelog

Click here

Simple Benchmask Test Result

Please refer to benchmark test file. Temporally only SELECT is tested. Several conditions among mysqlx, sqlx and gorm(v1) are tested.

Benchmark test statement: go test -bench=. -run=none -benchmem -benchtime=10s. Test table sise: 100000.

Select by main key

Select a record by auto-increment main key. This is the most basic way to reading record. We use statements for each package conditions:

• mysqlx: db.Select(&res, mysqlx.Condition("id", "=", id))
• sqlx (with "= 1234"): db.Select(&res, "SELECT * FROM t_student WHERE id=" + idStr)
• sqlx (with "= ?"): db.Select(&res, "SELECT * FROM t_student WHERE id=?", id)
• gorm (with 'Find' function): d.Where("id = ?", id+1).Find(&res)
• gorm (with 'First' function): d.First(&res, id)

Select By A VARCHAR Field

One of the t_student field is generated by uuid. We use statements for each packages:

• mysqlx: db.Select(&res, Condition("name", "=", name))
• sqlx (with "= 'Alice'"): db.Select(&res, "SELECT * FROM t_student WHERE name='" + name + "'")
• sqlx (with "= ?"): db.Select(&res, "SELECT * FROM t_student WHERE name=?", name)
• gorm (with 'Find' function): d.Where("name = ?", name).Find(&res)
• gorm (with 'First' function): d.Where("name = ?", name).First(&res)