Problem
I wanted a library to abstract copying data from MySQL + Postgres to Redis for the purpose of caching, none were present at the time.
Solution
Introducing, redisql, a Go module and command-line tool that allows you to convert SQL tables to a desired Redis datatype with one method call.
Example
Let's start with a celebrity table:
mysql> DESCRIBE celebrity;
+-------+------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------+------+-----+---------+-------+
| name | text | YES | | NULL | |
| age | int | YES | | NULL | |
+-------+------+------+-----+---------+-------+
2 rows in set (0.01 sec)
Now we incorporate redisql:
package main
import (
"github.com/DGKSK8LIFE/redisql"
)
func main() {
config := redisql.Config{
SQLType: "mysql",
SQLUser: "user",
SQLPassword: "password",
SQLDatabase: "celebrities",
SQLHost: "localhost",
SQLPort: "3306",
SQLTable: "celebrity",
RedisAddr: "localhost:6379",
RedisPass: "password",
}
err := config.CopyToString()
if err != nil {
panic(err)
}
}
In redis-cli:
127.0.0.1:6379> get celebrity:0:name
"Jaden Smith"
If we wanted to copy to other datatypes:
// copy to redis list
config.CopyToList()
// copy to redis hash
config.CopyToHash()
Top comments (0)