# Lite-DB

**Repository Path**: wangboa/lite-db

## Basic Information

- **Project Name**: Lite-DB
- **Description**: High performance time serial and analytic database
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2024-04-25
- **Last Updated**: 2024-05-10

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Introduce

LiteDB 是一个单机、高性能的时序数据库。

# 路标

| Feature       | 优先级 | 是否完成 |
|---------------|-----|------|
| http 写入接口     | 高   | 已完成  |
| flight-sql 接口 | 高   | 实现中  |
| MemTable 引擎   | 高   | 已实现  |
| HStore 引擎     | 高   | 规划中  |

## Flight-SQL

1. DQL
2. create|show|drop database|table 语法

# Demo

```bash
# curl -X POST "http://127.0.0.1:8080/write" -d $'t,label_a=123 field_a=122'
{"Success":{"success":1,"fail":0}}%
# flight_sql_client --host 127.0.0.1 --port 8081 statement-query "select * from t"
+------------+-----------+--------------------------------+------------+
| ts_s       | ts_n      | symbol_to_string(t.$t_label_a) | $f_field_a |
+------------+-----------+--------------------------------+------------+
| 1715155726 | 161169040 | 123                            | 122        |
+------------+-----------+--------------------------------+------------+
# curl -X POST "http://127.0.0.1:8080/write" -d $'t,label_a=aaa field_a=1\nt,label_b=bbb field_a=2'
{"Success":{"success":2,"fail":0}}%
# flight_sql_client --host 127.0.0.1 --port 8081 statement-query "select * from t" 
+------------+-----------+--------------------------------+------------+
| ts_s       | ts_n      | symbol_to_string(t.$t_label_a) | $f_field_a |
+------------+-----------+--------------------------------+------------+
| 1715155726 | 161169040 | 123                            | 122        |
| 1715155950 | 48718888  | aaa                            | 1          |
| 1715155950 | 48823726  |                                | 2          |
+------------+-----------+--------------------------------+------------+
```