Database ShortDB
[!NOTE]
This database with support SQL language.
Docs
Feature
- REPL interface
- save history (by default last 100 commands)
- navigation by history commands
- SQL-parser
- SELECT, INSERT INTO, CREATE TABLE, etc...
- Engine:
- API
Example work with REPL
> create table users (id integer, name string, active bool);
> insert into users ('id', 'name', 'active') VALUES ('1', 'Ivan', 'false');
> select id, name, active from users;
Docker build
$> docker buildx build --platform=linux/amd64,linux/arm64 --load -t shortdb -f ops/dockerfile/shortdb.Dockerfile .
Reference
Benchmark Engine
cpu: Intel(R) Core(TM) i3-7300 CPU @ 4.00GHz
Name |
Count |
ns/op |
CREATE_TABLE |
|
|
CREATE_TABLE-4 |
8199 |
143758 |
INSERT INTO |
|
|
INSERT_INTO_USERS-4 |
14222 |
83524 |
SELECT USERS |
|
|
SELECT_USERS-4 |
13066 |
91571 |
SELECT_USERS_WITH_WHERE_id=99_AND_LIMIT_2-4 |
6096 |
210703 |
SELECT_USERS_FULL_SCAN-4 |
202 |
5813380 |
Benchmark Parser
cpu: Intel(R) Core(TM) i3-7300 CPU @ 4.00GHz
Name |
Count |
ns/op |
CREATE_TABLE |
|
|
CREATE_TABLE-4 |
10000 |
105080 |
SELECT |
|
|
SELECT-4 |
11912 |
90804 |
INSERT INTO |
|
|
INSERT_INTO-4 |
16987 |
70963 |