{"repo":"sachaarbonel/reefdb","free":true,"listed":false,"github":"https://github.com/sachaarbonel/reefdb","clone":"git clone https://github.com/sachaarbonel/reefdb.git","description":"ReefDB is a minimalistic, in-memory and on-disk database management system written in Rust, implementing basic SQL query capabilities and full-text search.","language":"Rust","stars":88,"topics":["database","disk","memory","rust","sql","search"],"license":"MIT","category":"databases-storage","readme_excerpt":"ReefDB ReefDB is a minimalistic, in-memory and on-disk database management system written in Rust, implementing basic SQL query capabilities and full-text search. Usage To use ReefDB, you can choose between an in-memory storage ( InMemoryReefDB ) or on-disk storage ( OnDiskReefDB ). Basic Example On-Disk Storage Features Core Database Features - ✅ In-Memory and On-Disk storage modes - ✅ Basic SQL statements (CREATE, INSERT, SELECT, UPDATE, DELETE) - ✅ ALTER TABLE with ADD/DROP/RENAME column support - ✅ DROP TABLE functionality - ✅ INNER JOIN support - ✅ Primary key constraints - ✅ Basic error handling system - ✅ Rich data type support (INTEGER, TEXT, BOOLEAN, FLOAT, DATE, TIMESTAMP, NULL) Data Types - ✅ INTEGER: Whole number values - ✅ TEXT: String values with support for escaped quotes - ✅ BOOLEAN: TRUE/FALSE values - ✅ FLOAT: Decimal number values - ✅ DATE: Date values in 'YYYY-MM-DD' format - ✅ TIMESTAMP: Datetime values in 'YYYY-MM-DD HH:MM:SS' format - ✅ NULL: Null values - ✅ TSVECTOR: Full-text search optimized text type Full-Text Search - ✅ TSVECTOR data type - ✅ Inverted index implementation - ✅ Basic tokenization - ✅ Memory and disk-based index storage - ✅ @@ operator for text search Transaction Support - ✅ Basic transaction structure - ✅ Transaction isolation levels (ReadUncommitted, ReadCommitted, RepeatableRead, Serializable) - ✅ Write-Ahead Logging (WAL) - ✅ Transaction manager with locking mechanism - ✅ Full ACID compliance - ✅ Deadlock detection - ✅ MVCC implem","default_branch":null,"files":null,"tree":[],"storefront":"/r/sachaarbonel","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/sachaarbonel/reefdb/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}