redisql

redisql copied to clipboard

redisql

support Query Cmds

• use databasename
• show databases
• show tables
• show index from tablename
• create database databasename
• create table tablename(field1 type1, ...);
• create index indexname on tablename(field);
• insert into tablename(field1 ...) values(value1 ...)
• select
• Limit
• Other Comming soon

how to use

make

//build parse sql lib 'libparse.so' 
> cd redisql/redisql_parse/yacc
> make

//copy 'libparse.so' to redisql_cli or your project
//build client, need 'libparse.so'.
> cd redisql/redisql_cli
> go build

启动

报错

# ./redisql_cli 
./redisql_cli: error while loading shared libraries: libparse.so: cannot open shared object file: No such file or directory

解决方案： 把上面编译的libparse.so 拷贝到/usr/local/lib下，执行

export LD_LIBRARY_PATH=/usr/local/lib:$LD_LIBRARY_PATH

client

call by golang

redisql.Connect("127.0.0.1", "6379", "", "tcp", 5, 120)
redisql.Selectdb(0)
res, err := redisql.Query("show databases")
if err != nil {
	fmt.Println(err)
	return
}
...