This is a very interesting project! Thank you for posting it.

Having read both this post and the documentation for TrailDB, I don’t think they are comparable past very simple use cases. This post seems to be covering a complete database system with a query parser, planner, and (previously?) a storage engine. TrailDB is more like a storage engine you can push certain kinds of filters down into, but performs neither query parsing nor planning for you.

True. But the latest blog post for TrailDB mentions two new query interfaces, trck and reel.

I also wouldn't be surprised if someone has done a sqlite backend for it.

Interesting project, however it looks like the last commit is from September 2017 so either it is just very stable or not maintained anymore?