Kiln

Kiln is a relational database implemented in Rust. Unlike databases like PostgreSQL and SQLite, Kiln does not operate on a client-server model. Instead, it is a stand-alone library that allows it to be used with zero runtime dependencies.

This is a very early version of the database. So far the only thing done is the format the database stores tables.

Features implemented so far

• Creating databases
• Creating tables
  • table! macro shorthand allows for easy definitions
• Inserting rows into tables with runtime type checking
  • IDs are hardcoded. Need to implement some sort of hashing for random IDs.
• Get row by ID
• DB structure allows for future O(1) look up of rows by value.

Usage

Here is a simple example of working with one simple table. The structure of the queries is very different from how it would be accomplished in a tradition SQL database. This unique structure makes it possible to easily interact with the database using expressive, declarative Rust code.

#[macro_use]
extern crate kiln;

fn main() {
    // Create a new database in the `data` dir
    let db = kiln::Db::new("data").expect("Failed to create or access db");

    // Create or access a table "users" with col types int and string
    let users = db.table("users", table!{
        age: i32,
        name: str
    }).expect("Table with same name exists with different spec");

    // Insert a row into the users table
    users.insert(row!{
        name: "Bob",
        age: 24
    }).expect("Could not insert row");

    // Get back a row where the name = "Bob"
    let users = users.get("name", "Bob");

    // Select just the ages from these rows
    for age in select!(users => age) {
        // Age is an Option because all columns can be empty
        println!("Bob is {:?} years old", age.unwrap());
        //=> Bob is I32(24) years old
    }
}