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.
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!