Quick Start⚓︎
Docker container⚓︎
Pull the last image of Siodb⚓︎
docker pull siodb/siodb
docker run siodb/siodb
Connect to the instance in the container⚓︎
[email protected]:/$ siocli --host localhost --port 50000 --user root --identity-file ~/.ssh/id_rsa
Siodb client v.0.6.0
Copyright (C) 2019-2020 Siodb GmbH. All rights reserved.
siocli> show databases ;
NAME UUID
---------------------------------------- ----------------------------------------
SYS 68ba038e-b704-2cb9-1d0d-b91864c819cd
Installation on Linux⚓︎
Get the bootstrap script and run it⚓︎
wget https://siodb.io/packages/InstallSiodb.sh
chmod u+x ./InstallSiodb.sh
sudo ./InstallSiodb.sh
Connect to the instance⚓︎
Connect to the Siodb instance as siodb
:
sudo -u siodb siocli --host localhost --port 50000 --user root --identity-file ~/.ssh/id_rsa
- or (simplified)
sudo -u siodb siocli --user root
Create your first database⚓︎
create database myapp ; -- Creates an encrypted database with the default cipher AES128
Create your first table⚓︎
use database myapp ;
create table employees ( firstname text, lastname text, salary float, hire_date timestamp) ;
insert into employees ( firstname, lastname, salary, hire_date)
values
( '马', '云', 249000.00, '1964-09-10' ),
( 'Юрий', 'Гагарин', 49000.00, '1934-03-09' ),
( 'Barack', 'Obama', 149000.00, '1961-08-04' )
;
REST API⚓︎
Add a token access to root user⚓︎
TOKEN=$(siocli --user root <<< 'alter user root add token TOKEN1' | grep 'Server: token:' | awk '{print $3}')
POST Request⚓︎
curl -k -X POST \
-d '[
{ "firstname": "马","lastname": "云","salary": "249000.00","hire_date": "1964-09-10"},
{ "firstname": "Юрий","lastname": "Гагарин","salary": "49000.00","hire_date": "1934-03-09"},
{ "firstname": "Barack","lastname": "Obama","salary": "149000.00","hire_date": "1961-08-04"}
]' \
https://root:${TOKEN}@localhost:50443/databases/myapp/tables/employees/rows
Returns:
{
"status": 200,
"affectedRowCount": 3,
"trids": [1, 2, 3]
}
GET Request⚓︎
curl -s -k https://root:${TOKEN}@localhost:50443/databases/myapp/tables/employees/rows
Returns:
{
"rows" : [
{
"FIRSTNAME" : "马",
"HIRE_DATE" : "1964-09-10",
"LASTNAME" : "云",
"SALARY" : 249000,
"TRID" : 1
},
{
"FIRSTNAME" : "Юрий",
"HIRE_DATE" : "1934-03-09",
"LASTNAME" : "Гагарин",
"SALARY" : 49000,
"TRID" : 2
},
{
"FIRSTNAME" : "Barack",
"HIRE_DATE" : "1961-08-04",
"LASTNAME" : "Obama",
"SALARY" : 149000,
"TRID" : 3
}
],
"status" : 200
}