Hello, I hope all are well. The past year I've been studying and implementing a variety of different databases ( see here <a href="https://github.com/guycipher">https://github.com/guycipher</a> ) and most recently I've gotten obsessed with building a relational database from the ground up, and sticking to it. I started writing AriaSQL about 7 months ago privately, studying the different concepts required to build such a system.<p>I'd like to share my current progress. Mind you Aria is still in the beta stages and early stages of building a full fledged relational database system. Having a project like this, never stops. SQL is an old language, and being added to often enough where majority of systems don't implement the entire language nor all the features.<p>Current implementation:
~ SQL1+ handwritten parser, lexer implementation<p>~ BTrees for indexes<p>~ Optimized execution engine / compiler<p>~ SQL Server (TCP Server on port 3695)<p>~ User authentication and privileges<p>~ Atomic transactions with rollback support on error<p>~ WAL (Write Ahead Logging)<p>~ Recovery-Replay from WAL<p>~ Subqueries<p>~ Aggregates<p>~ Implicit joins<p>~ Row level locking<p>~ Users and privileges<p>I hope you take the time to check it out! There is much more to come, I work on the database religiously, it's a passion project of mine.<p>Thank you for your time. Any questions I'll be sure to answer!