Built by @KipData
██╗ ██╗██╗██████╗ ███████╗ ██████╗ ██╗
██║ ██╔╝██║██╔══██╗██╔════╝██╔═══██╗██║
█████╔╝ ██║██████╔╝███████╗██║ ██║██║
██╔═██╗ ██║██╔═══╝ ╚════██║██║▄▄ ██║██║
██║ ██╗██║██║ ███████║╚██████╔╝███████╗
╚═╝ ╚═╝╚═╝╚═╝ ╚══════╝ ╚══▀▀═╝ ╚══════╝
-----------------------------------
Embedded SQL DBMS
The Lightweight Embedded OLTP Open-source Database
### What is KipSQL
KipSQL is designed to allow small Rust projects to reduce external dependencies and get rid of heavy database maintenance,
so that the Rust application itself can provide SQL storage capabilities.
If you are a developer of the following applications, we very much welcome you to try using KipSQL
and provide your experience and opinions on using it.
- personal website
- desktop/mobile application
- learning database
- platform bot
Welcome to our WebSite, Power By KipSQL: **http://www.kipdata.site/**
### Quick Started
Clone the repository
``` shell
git clone https://github.com/KipData/KipSQL.git
```
Install rust toolchain first.
```
cargo run
```
Example
```sql
create table blog (id int primary key, title varchar unique);
insert into blog (id, title) values (0, 'KipSQL'), (1, 'KipDB'), (2, 'KipBlog');
update blog set title = 'KipData' where id = 2;
select * from blog order by title desc nulls first
select count(distinct id) from blog;
delete from blog where title like 'Kip%';
truncate table blog;
drop table blog;
```
Using KipSQL in code
```rust
let kipsql = Database::with_kipdb("./data").await?;
let tupes = db.run("select * from t1").await?;
```
Storage Support:
- KipDB
### Features
- ORM Mapping: `features = ["marcos"]`
```rust
#[derive(Debug, Clone, Default)]
pub struct Post {
pub post_title: String,
pub post_date: NaiveDateTime,
pub post_body: String,
}
implement_from_tuple!(Post, (
post_title: String => |post: &mut Post, value: DataValue| {
if let Some(title) = value.utf8() {
post.post_title = title;
}
},
post_date: NaiveDateTime => |post: &mut Post, value: DataValue| {
if let Some(date_time) = value.datetime() {
post.post_date = date_time;
}
},
post_body: String => |post: &mut Post, value: DataValue| {
if let Some(body) = value.utf8() {
post.post_body = body;
}
}
));
```
- Execute
- Volcano
- Codegen on LuaJIT: `features = ["codegen_execute"]`
- MVCC Transaction
- Optimistic
- SQL field options
- not null
- null
- unique
- primary key
- SQL where options
- is null
- is not null
- like
- not like
- in
- not in
- Supports index type
- Unique Index
- Supports multiple primary key types
- Tinyint
- UTinyint
- Smallint
- USmallint
- Integer
- UInteger
- Bigint
- UBigint
- Varchar
- DDL
- Create
- [x] Table
- [ ] Index
- Drop
- [x] Table
- [ ] Index
- [x] Truncate
- DQL
- [x] Select
- SeqScan
- IndexScan
- [x] Where
- [x] Distinct
- [x] Alias
- [x] Aggregation: count()/sum()/avg()/min()/max()
- [x] SubQuery(from)
- [x] Join: Inner/Left/Right/Full Cross(x)
- [x] Group By
- [x] Having
- [x] Order By
- [x] Limit
- DML
- [x] Insert
- [x] Insert Overwrite
- [x] Update
- [x] Delete
- DataTypes
- Invalid
- SqlNull
- Boolean
- Tinyint
- UTinyint
- Smallint
- USmallint
- Integer
- UInteger
- Bigint
- UBigint
- Float
- Double
- Varchar
- Date
- DateTime
- Optimizer rules
- Limit Project Transpose
- Eliminate Limits
- Push Limit Through Join
- Push Limit Into Scan
- Combine Filters
- Column Pruning
- Collapse Project
## License
KipSQL uses the [Apache 2.0 license][1] to strike a balance between
open contributions and allowing you to use the software however you want.
[1]:
### Thanks For
- [Fedomn/sqlrs](https://github.com/Fedomn/sqlrs): Main reference materials, Optimizer and Executor all refer to the design of sqlrs
- [systemxlabs/bustubx](https://github.com/systemxlabs/bustubx)
- [duckdb/duckdb](https://github.com/duckdb/duckdb)