FlintDB (PHP Version)
Projects — — Links: Documentation — Github Repo
A lightweight, flat-file NoSQL database management system built with PHP. This open-source project showcases my skills in backend development and data management.
FlintDB is a lightweight and robust NoSQL database management system built to solve a critical need for simple, high-performance data storage. This version, written entirely in PHP, demonstrates the ability to build and implement complex database concepts in a language commonly used for web applications.
The Problem
While many lightweight data storage solutions exist, they often sacrifice essential database features like data integrity, security, and transaction support. FlintDB was created to provide a simple, flat-file alternative that does not compromise on core database principles, showcasing that a full-fledged database is not always necessary for robust data management.
Key Contributions
- Implemented ACID transactions in a stateless environment to ensure data integrity and reliability. - Engineered a custom file-based cache in PHP to improve read performance and optimize resource management. - Designed a Transparent Data Encryption (TDE) layer with a two-tier key system, demonstrating a strong understanding of security principles. - Developed a lazy garbage collection system to automate the deletion of expired cache data and improve performance.
Technology Used
- PHP: The core language for the entire system. - JSON: The underlying data storage format.
