shortdb/

directory
v0.0.0-...-31aa68c Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: May 22, 2024 License: MIT

README

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:
    • file
  • 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;

asciicast

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

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL