CeresDB is a high-performance, distributed, schema-less, cloud native time-series database that can handle both time-series and analytics workloads.
Status
The project is currently under rapid development. This early stage is not production ready and may incur data corruptions.
RoadMap
See our RoadMap
Get started
Clone the repository
Clone this repository by git and enter it:
git clone [email protected]:CeresDB/ceresdb.git
cd ceresdb
Run ceresdb in docker
Ensure that docker is installed in your development environment, and then build the image with the provided Dockerfile:
docker build -t ceresdb .
Start the ceresdb container using the built docker image:
docker run -d -t --name ceresdb -p 5440:5440 -p 8831:8831 ceresdb
Compile and run CeresDB
Install dependencies
In order to compile CeresDB, some relevant dependencies(including Rust toolchain) should be installed.
Dependencies(Ubuntu20.04)
Assuming the development environment is Ubuntu20.04, execute the following command to install the required dependencies:
apt install git curl gcc g++ libssl-dev pkg-config cmake
It should be noted that the compilation of the project actually has version requirements for some dependencies such as cmake, gcc, g++, etc. If your development environment is an old Linux distribution, it is necessary to manually install these dependencies of a higher version.
Rust
Rust can be installed by rustup. After installing rustup, when entering the CeresDB project, the specified Rust version will be automatically downloaded according to the rust-toolchain file.
After execution, you need to add environment variables to use the Rust toolchain. Basically, just put the following commands into your ~/.bashrc or ~/.bash_profile:
source $HOME/.cargo/env
Compile and run
Compile CeresDB by the following command:
cargo build --release
Then you can run CeresDB using the default configuration file provided in the codebase.
./target/ceresdb-server --config ./docs/example.toml
Write and read data
CeresDB supports custom extended SQL protocol. Currently, you can create tables and read/write data with SQL statements through http service.
Create table
curl --location --request POST 'http://127.0.0.1:5440/sql' \
--header 'Content-Type: application/json' \
--data-raw '{
"query": "CREATE TABLE `demo` (`name` string TAG, `value` double NOT NULL, `t` timestamp NOT NULL, TIMESTAMP KEY(t)) ENGINE=Analytic with (enable_ttl='\''false'\'');"
}'
Write data
curl --location --request POST 'http://127.0.0.1:5440/sql' \
--header 'Content-Type: application/json' \
--data-raw '{
"query": "INSERT INTO demo(t, name, value) VALUES(1651737067000, '\''ceresdb'\'', 100)"
}'
Read data
curl --location --request POST 'http://127.0.0.1:5440/sql' \
--header 'Content-Type: application/json' \
--data-raw '{
"query": "select * from demo"
}'
Show create table
curl --location --request POST 'http://127.0.0.1:5440/sql' \
--header 'Content-Type: application/json' \
--data-raw '{
"query": "show create table demo"
}'
Drop table
curl --location --request POST 'http://127.0.0.1:5440/sql' \
--header 'Content-Type: application/json' \
--data-raw '{
"query": "DROP TABLE demo;"
}'
Contributing
Any contribution is welcome!
Read our Contributing Guide and make your first contribution!
Architecture and Technical Documentation
Our technical documents(still under writing and polishing) describes critical parts of ceresdb in the docs.
Acknowledgment
Some design of CeresDB references influxdb_iox, and some specific module implementations reference tikv and other excellent open source projects, thanks to InfluxDB, TiKV, and any other referenced great open source projects.
Licensing
CeresDB is under Apache License 2.0.
Community
- Check our community materials.
- Join the user group on the DingTalk: 44602802
- Contact us via Email: [email protected]
Next, use create table sql to create a new table:
Last view effect
5k Jan 9, 2023
38 Jan 2, 2024
8.3k Dec 30, 2022
3.7k Jan 2, 2023
2 Apr 5, 2022
306 Dec 28, 2022
32 Jul 25, 2022
2 Sep 4, 2022
3 Nov 29, 2022
5 Jul 24, 2023
1.7k Jan 7, 2023
12.4k Jan 3, 2023
19 Dec 2, 2021
16.9k Jan 8, 2023
4.6k Jan 8, 2023
5 Apr 26, 2022
2 Jan 6, 2022
1.4k Dec 25, 2022
1.4k Dec 29, 2022