(WIP) A minimal SQL DBMS written in Rust
- The document is here.
- There is a slide introduce this project.
- There is a series of articles introducing about this project: Let's build a DBMS
Before you start, you need to have Rust(>=1.31) and Cargo.
curl https://sh.rustup.rs -sSf | shThen we could get the source code.
git clone https://github.com/tigercosmos/StellarSQL
cd StellarSQLOpen the first window and run server:
cargo run [port]the default port is 23333, and you can either modify .env or run by argument [port].
Open the another window and run the client by python client/client.py and connect to the server:
command:
> create user <name> <key> # key is our feature, put any number for now
> set user <name> # second time log in
> create database <db_name> # first time create database
> use <db_name> # second time adopt the database
> <query> # now support simple sqlSQL query are not implement very well. A few simple command support for now:
- create database
- create table
- type: int, float, double, varchar, char, url
- insert into
- select {fields} from {table} where {predicate}
- not yet support join, only a table
- predicate without NULL
The default host and port are 127.0.0.1 and 23333
$ python client/client.py [host] [port]
Connect to 127.0.0.1:23333
== Welcome to StellarSQL Client! ==
StellarSQL> create user Tiger 123
Login OK!
StellarSQL> create database DB1
Query OK!
StellarSQL> create table t1 (a1 int, b1 int, c1 float);
Query OK!
StellarSQL> insert into t1 (a1, b1, c1) values (1, 2, 1.2), (2, 3, 4.5), (4, 1, 0.3);
Query OK!
StellarSQL> select a1, b1, c1 from t1 where a1 > 1;
{"fields":["a1","b1","c1"],"rows":[["2","3","4.5"],["4","1","0.3"]]}
StellarSQL> select a1, b1, c1 from t1 where a1 > 1 and c1 > 2;
{"fields":["a1","b1","c1"],"rows":[["2","3","4.5"]]}
StellarSQL> select a1, b1, c1 from t1 where not (not a1 < 2 and not (not b1 = 3 or c1 > 1.1));
{"fields":["a1","b1","c1"],"rows":[["1","2","1.2"],["2","3","4.5"],["4","1","0.3"]]}cargo buildcargo testAdd the line at the beginning of the test function.
// init the logger for the test
env_logger::init();Then run the command to see the debug information:
RUST_LOG=debug cargo test -- --nocapture {test_name}Install rustfmt, and make sure you could pass:
cargo fmt --all -- --check
cargo build
cargo testBuild and open the document at localhost
cargo rustdoc --open -- --document-private-itemsMIT
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent