Up to date, it can work with many MySQL applications such as MySQL console, MySQL command line utilities, MediaWiki, SonarQube, DBeaver, phpMyAdmin, Squirrel SQL etc. I've benchmarked it with YCSB. It is significantly faster than mainstream relational databases. Results can be found at http://www.antsdb.com/?p=171.
I started this project a few years ago with a couple of questions in my mind: (1) why do you need a front-end database if all it does can be done by a middleware (2) I like the scalability of Hadoop but I hate missing the nice features from the traditional relational database. Why can't I have both? (3) How far can you go with Java?
Now I believe I have limited success with my experiment and I'd like to share it with the community. The project is open source. GitHub url is https://github.com/waterguo/antsdb.
You are welcome to try it out or use the code in your own projects. I will be very grateful if you can give me some feedback.