The Blitzar is a timeseries database with sql syntax. The data storing in the b+tree data structure on the disk.
The database doesn't support permissions yet.
There is only a capability to create User with login and password to manage databases and tables.
User is able to create databases and tables inside of them.
- short (2 bytes)
- int (4 bytes)
- long (8 bytes)
- varchar(n bytes)
The tables are support primary (clustered) indexes.
That's why there is capability of creation only 1 index per table. Index is able to contain 1 to N columns.
User can insert, select data with conditions like (>, <, =, <>, >=, <=).
The join syntax is not available because there are no relations between tables.
For now there is ability only to insert data, the update and delete operations are not supported on the data yet.
create database database_name;
use database_name;
create table database_name (time long not null primary key, value long not null);
insert into database_name (time , value) values (30000, 200);
select * from database_name;
select * from database_name where time = 30000;
select value from database_name where time > 30000 and time < 40000;
The efficiency of the library wasn't the goal of blitzar that's why there are no high expectations.
- Storing databases
- Storing tables
- Server
- Service discovery
- Process sql queries
- Thread safe version of database
- Bloom filter
- Buffer pool
- User managment
- Batch insert
- Benchmarks
- Query specification (byte protocol)
- Multicolumn indexes
- Integration tests
- Add and remove columns