ldbsh

A simple LevelDB cli utility.

Installation

go install github.com/QuietSugar/ldbsh@1.0

Interactive mode

Following command will be open specified LevelDB dir, or create it if not exists.

$ ldbsh <LevelDB dir>

Basic commands

get <key>         :: Get value from DB
put <key> <value> :: Put key-value pair to DB
list              :: (no arguments) Print all entries in DB
list <prefix>     :: List entries in DB with given prefix
load <filename>   :: Load tsv file (see Batch mode)
join <filename>   :: Join key list file (see Batch mode)

Examples

$ ldbsh <LevelDB dir>
> put somekey somevalue
> get somekey
somevalue
> put anotherkey anothervalue
> list
somekey somevalue
anotherkey anothervalue

Batch mode

You can give a command from program arguments like this:

$ ldbsh <LevelDB dir> <command>

Batch commands

You can use basic commands (see above) and following additional commands.

load :: (no arguments) Load tsv data from stdin
join :: (no arguments) 
  SQL Join like operation. 
  Read key list data from stdin and output key-value pair.
dump :: (no arguments) Alias to 'list'

Examples

Prepare files for example

data.tsv (A tab separated file with 2 colums)

a 1
b 2
c 3
d 4

keys.txt

a
c

# You can load key-value pair from tsv.
$ ldbsh <LevelDB dir> load data.tsv
# Check the result.
$ ldbsh <LevelDB dir> list
a 1
b 2
c 3
d 4
$ ldbsh <LevelDB dir> join keys.txt
a 1
c 3
# Read from stdin when no arguments given.
$ ldbsh foo join <<EOS
> b
> d
> EOS
b 2
b 4

License

MIT