What is SableDb?

SableDb is a key-value NoSQL database that utilizes RocksDb as its storage engine and is compatible with the Redis protocol. It aims to reduce memory costs and increase capacity compared to Redis. SableDb features include Redis-compatible access via any Redis client, up to 64K databases support, asynchronous replication using transaction log tailing and TLS connectivity support.

Oh, and it's written in Rust :)

Building

SableDb is supported on all major OS: Linux, macOS and Windows

Linux /macOS

git clone https://github.com/sabledb-io/sabledb.git
cd sabledb
cargo build --release
cargo test --release

Windows

On Windows, we require MSYS2 terminal for building SableDb.

git clone https://github.com/sabledb-io/sabledb.git
cd sabledb
CFLAGS="-D_ISOC11_SOURCE" cargo build --release
cargo test --release

Running SableDb

./target/release/sabledb

Usage:

$target/release/sabledb [sabledb.ini]

Supported features

• Persistent data using RocksDb - use SableDb as a persistent storage using Redis's API
• TLS connections
• Replication using tailing of the transaction log
• Highly configurable, but comes with sensible default values
• Use the sb command line utility (target/release/sb) for performance testing
• Transactions ( MULTI / EXEC )

Benchmark tool - sb

SableDb uses its own benchmarking tool named sb ("SableDb Benchmark"). sb supports the following commands:

• set
• get
• lpush
• lpop
• rpush
• rpop
• incr
• ping
• hset

Run sb --help to get the full help message.

Below is a simple ( ping ) test conducted locally using WSL2 on Windows 10 (same machine is running both SableDb and sb...):

set test, on the same set-up (local machine, WSL2 on Windows 10):

Supported commands

IMPORTANT

SableDb is under constant development, if you are missing a command, feel free to open an issue and visit this page again in couple of days

---

String commands

Command	Supported	Fully supported?	Comment
append	✓	✓
decr	✓	✓
decrby	✓	✓
get	✓	✓
getdel	✓	✓
getex	✓	✓
getrange	✓	✓
getset	✓	✓
incr	✓	✓
incrby	✓	✓
incrbyfloat	✓	✓
lcs	✓	x	Does not support: IDX, MINMATCHLEN and WITHMATCHLEN
mget	✓	✓
mset	✓	✓
msetnx	✓	✓
psetex	✓	✓
set	✓	✓
setex	✓	✓
setnx	✓	✓
setrange	✓	✓
strlen	✓	✓
substr	✓	✓

List commands

Command	Supported	Fully supported?	Comment
blmove	✓	✓
blmpop	✓	✓
blpop	✓	✓
brpop	✓	✓
brpoplpush	✓	✓
lindex	✓	✓
linsert	✓	✓
llen	✓	✓
lmove	✓	✓
lmpop	✓	✓
lpop	✓	✓
lpos	✓	✓
lpush	✓	✓
lpushx	✓	✓
lrange	✓	✓
lrem	✓	✓
lset	✓	✓
ltrim	✓	✓
rpop	✓	✓
rpoplpush	✓	✓
rpush	✓	✓
rpushx	✓	✓

Hash commands

Command	Supported	Fully supported?	Comment
hset	✓	✓
hget	✓	✓
hmget	✓	✓
hmset	✓	✓
hgetall	✓	✓
hdel	✓	✓
hlen	✓	✓
hexists	✓	✓
hincrby	✓	✓
hincrbyfloat	✓	✓
hkeys	✓	✓
hvals	✓	✓
hrandfield	✓	✓
hscan	✓	✓
hsetnx	✓	✓
hstrlen	✓	✓

Sorted Set (ZSET) commands

Command	Supported	Fully supported?	Comment
bzmpop	✓	✓
bzpopmax	✓	✓
bzpopmin	✓	✓
zadd	✓	✓
zcard	✓	✓
zincrby	✓	✓
zcount	✓	✓
zdiff	✓	✓
zdiffstore	✓	✓
zinter	✓	✓
zintercard	✓	✓
zinterstore	✓	✓
zlexcount	✓	✓
zmpop	✓	✓
zmscore	✓	✓
zpopmax	✓	✓
zpopmin	✓	✓
zrandmember	✓	✓
zrangebyscore	✓	✓
zrevrangebyscore	✓	✓
zrangebylex	✓	✓
zrevrangebylex	✓	✓
zrange	✓	✓
zrangestore	✓	✓
zrank	✓	✓
zrem	✓	✓
zremrangebylex	✓	✓
zremrangebyrank	✓	✓
zremrangebyscore	✓	✓
zrevrange	✓	✓
zrevrank	✓	✓
zunion	✓	✓
zunionstore	✓	✓
zscore	✓	✓
zscan	✓	✓

Generic commands

Command	Supported	Fully supported?	Comment
del	✓	✓
ttl	✓	✓
exists	✓	✓
expire	✓	✓

Server management commands

Command	Supported	Fully supported?	Comment
info	✓	✓	SableDb has its own INFO output format
ping	✓	✓
replicaof	✓	✓
slaveof	✓	✓
command	✓	✓
command docs	✓	x
flushall	✓	✓
flushdb	✓	✓
dbsize	✓	✓	Data is accurate for the last scan performed on the storage

Transaction

Command	Supported	Fully supported?	Comment
multi	✓	✓
exec	✓	✓
discard	✓	✓
watch	✓	✓
unwatch	✓	✓

Connection management commands

Command	Supported	Fully supported?	Comment
client id	✓	✓
client kill	✓	x	supports: client kill ID <client-id>
select	✓	✓
ping	✓	✓

Benchmarks

Command set

Payload size (bytes)	rps	p50 (ms)	p90 (ms)	p99 (ms)
64	448K	1.127	1.279	1.423
128	420K	1.199	1.375	1.551
256	363K	1.375	1.567	1.799

Command get

Payload size (bytes)	rps	p50 (ms)	p90 (ms)	p99 (ms)
64	950K	0.495	0.671	1.087
128	907K	0.511	0.695	1.111
256	905K	0.519	0.711	1.119

Command mset

Note: Each mset command is equivalent of 10 set commands

Payload size (bytes)	rps	p50 (ms)	p90 (ms)	p99 (ms)
64	116K	3.8	4.6	6.3
128	72K	6.375	7.039	54.111
256	41.5K	0.432	7.279	226.943

Command incr

The increment command is unique because it uses a "read-modify-update" in order to ensure the atomicity of the action which in a multi-threaded environment causes a challenge

Payload size (bytes)	rps	p50 (ms)	p90 (ms)	p99 (ms)
N/A	443K	1.127	1.295	1.383

Network only (ping command)

Command	rps	pipeline	p50 (ms)	p90 (ms)	p99 (ms)
ping_inline	1.05M	1	0.407	0.775	1.143
ping_inline	6.65M	20	0.855	1.551	1.815
ping_mbulk	1.05M	1	0.399	0.727	1.127
ping_mbulk	7.96M	20	0.807	1.471	1.711

---

Command executions can be seen here