Home

FastoNoSQL it is GUI platform for NoSQL databases. Currently supported next databases:

• Redis
• Memcached
• SSDB
• LevelDB
• RocksDB
• UnQLite
• LMDB
• UpscaleDB
• ForestDB

All this databases can be divided into 2 groups:

Server side:

• Redis
• Memcached
• SSDB
• UpscaleDB

Local storage:

• LevelDB
• RocksDB
• UnQLite
• LMDB
• ForestDB

Redis database:

Redis server can handle 2 type of connection via unix socket(redis-server and client placed in same machine) and remote socket (redis-server and client placed on different machines, or in same but via tcp stack connection). For Redis we using hiredis.

Unix socket connection:

If you want to connect into unix socket you should specify path to it in Unix socket path field.

Direct connection:

For direct remote connection you should specify select remote radio box and specify host and port.

SSH connection:

Database path in example below used remote localhost but can be other address, for example when you connected via ssh from remote server into private ip which visible only from it(ssh server). In SSH Address field you should specify ssh address of server for example example.com or visible ip address, in other fields specified ssh connection method can be:

• Password also should be entered user name and password
• Public/Private key should be username

TLS/SSL connection:

If you have secure redis server like azure, you should check SSL checkbox and input host address and secure port.

When all of fields entered you can test your connection via test button.

Memcached database:

Memcached server have 2 type remote connection, with SASL(Secure connection) or without(Direct remote connection).

Direct connection without SASL:

For direct remote connection you should specify host and port.

Direct connection with SASL:

For direct remote connection with SASL you should specify host and port like in previous example, but also should be entered user name and password.

For all this databases we support base amount of commands:

• SET - Set the value of a key, example: SET test value
• GET - Get the value of a key, example: GET test
• DEL - Delete key, example: DEL test
• RENAME - Rename a key RENAME test test2
• DBKCOUNT - Return the number of keys in the selected database DBKCOUNT
• KEYS - Find all keys matching the given limits KEYS a z 100 (for Redis: KEYS *)
• SCAN - Incrementally iterate the keys space SCAN 0
• FLUSHDB - Remove all keys from the current database FLUSHDB

Short example:

SET test value => OK
GET test => value
RENAME test test2 => OK
GET test2 => value
SET test3 value3 => OK
GET test3 => value3
DBKCOUNT => 2
KEYS a z 100 => test2\ntest3
SCAN 0 => test2\ntest3
DEL test2 => 1
FLUSHDB => OK