|
I'm excited to share my recent Rust project: ReefDB, a lightweight, in-memory and on-disk database management system with basic SQL query capabilities and full-text search. I built it to improve my Rust skills and provide a learning resource for those interested in database systems. ReefDB's commit history offers insights into the development process and the incremental steps taken to build a working database system from scratch, making it a valuable learning tool for those diving into the world of databases. *Features:* - In-Memory or On-Disk storage options
- Basic SQL statements (CREATE TABLE, INSERT, SELECT, UPDATE, DELETE)
- INNER JOIN support
- Full-Text Search using an Inverted Index
- Custom data types (INTEGER, TEXT, FTS_TEXT) *Future Improvements:* - Support for more SQL statements, indexing and query optimization, transactions, user-defined functions, and much more
- Improved error handling, full-text search capabilities, authentication mechanisms
- Distributed database management, command-line interface, better documentation, and performance benchmarks ReefDB is licensed under MIT, and I welcome any feedback, forks, improvements, or pull requests from the community. If you like ReefDB, please give it a star on GitHub: [ReefDB](https://github.com/sachaarbonel/reefdb) Thank you for your attention, and I hope you have as much fun with ReefDB as I did building it and learning from its development process! |