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
git clone https://github.com/KipData/KipSQL.git
Install rust toolchain first.
cargo run
Example
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;
blog;
(id
Using KipSQL in code
let kipsql = with_kipdb.await?;
let tupes = db.run.await?;
Storage Support:
- KipDB
Features
- ORM Mapping:
features = ["marcos"]
implement_from_tuple!;
- 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
- Table
- Index
- Drop
- Table
- Index
- Truncate
- Create
- DQL
- Select
- SeqScan
- IndexScan
- Where
- Distinct
- Alias
- Aggregation: count()/sum()/avg()/min()/max()
- SubQuery(from)
- Join: Inner/Left/Right/Full Cross(x)
- Group By
- Having
- Order By
- Limit
- Select
- DML
- Insert
- Insert Overwrite
- Update
- 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 to strike a balance between open contributions and allowing you to use the software however you want.
Thanks For
- Fedomn/sqlrs: Main reference materials, Optimizer and Executor all refer to the design of sqlrs
- systemxlabs/bustubx
- duckdb/duckdb