#column #multiple #file #db #save #colon

colon_db

file data base with multiple columns and an id column

2 releases

0.1.1 Nov 29, 2024
0.1.0 Nov 29, 2024

#2083 in Database interfaces

Download history 208/week @ 2024-11-25 21/week @ 2024-12-02 22/week @ 2024-12-09

251 downloads per month

Apache-2.0

14KB
178 lines

colonDB | simpleDB with multiple columns support (database file store)

use in main.rs

use colon_db::ColonDB;

Methods:

find save file, or create one

let mut database = ColonDB::find_database("db.txt");

Make sure to .to_string() input values. Check example.

add item or row

database.insert_item_into_db("01".to_string(),"age".to_string(), "18".to_string());
database.insert_item_into_db("01".to_string(),"salary".to_string(), "0".to_string());

database.insert_row_into_db("02".to_string(),vec!["alan".to_string(),"12".to_string(),"23".to_string()]);

select a range from the db (0 to total number of rows, vector with column names)

let newdb = database.select_data(Some(0..4), vec!["name".to_string(),"age".to_string()].into());
// None on either selects all available range

get item by key, column

println!("{}",database.select_item("01", "age").unwrap())

delete item, row, column

database.delete_column("salary".to_string());
database.delete_item("08", "name".to_string());
database.delete_row("09");

display database in terminal

newdb.print_database();

access database (note: its an indexmap)

database.data // ... whatever action

Dependencies

~1MB
~16K SLoC