dbvs is a playground for benchmarking different db against each other through a basic rest api interface.

it's surprisingly hard to find benchmarks.

this isn't a comprehensive benchmark of databases, use cases or scalability across hundreds of servers.

1. run selected api (as seen in subdir/README)
2. run tests as in methodology

schema can be described with the following go type, however it may differ slightly based on implementation:

type Item struct {
	ID          int        `json:"id"`
	Name        string     `json:"name"`
	Description string     `json:"description"`
	CreatedAt   *time.Time `json:"createdAt"`
}

tests consist of running bombardier:

1. bombardier -c 100 -n 10000 -l -m POST -b '{ "name": "lorem ipsum item name", "description": "is existing"}' http://localhost:8090/v1/items
2. bombardier -c 100 -n 10000 -l -m GET http://localhost:8090/v1/items/<ID>
3. bombardier -c 1 -n 100 -l -m GET http://localhost:8090/v1/items
4. bombardier -c 100 -n 10000 -l -m GET http://localhost:8090/v1/items

1. creating 10000 objects with 100 simultaneous connections
2. get one item 10000times/100conn
3. get list of 1000 items sorted by date descending (reverse order to insert) 100 times sequentially
4. 3 but 10000times/100conn

never forget to cache expensive requests

• joins
• combined r/w workload
• multi node db
• automate benchmark suite

everything may or may not change ¯\_(ツ)_/¯