Open connects to database by specify database url and ping it.

Rebind a query from the default driverName(mysql) to the target driverName.

DefaultTimeout for all database operations.

Bindvar types supported by Rebind, BindMap and BindStruct.

MySQL errors https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html.

PG errors https://www.postgresql.org/docs/current/errcodes-appendix.html.

Bindvar types supported by Rebind, BindMap and BindStruct.

SQLite errors https://www.sqlite.org/rescode.html.

Bindvar types supported by Rebind, BindMap and BindStruct.

TODO: benchmark performance of regexp match VS map access the code below could be simplified by using regexp, but declare it in a map should result in better performance in theory.

Column represents a table column with name and type.

DB is a wrapper of the golang database/sql DB struct with a DriverName to handle generic logic against different SQL database.

Error converts database error to http code.

e.g.

Table represents a table in database with name and columns.

e.g.