TingoDB API and features designed to be close compatible with MongoDB. As an additional proof for this concept we managed to implement experimental driver for Mongoose.js ODM libary. Work is still in progress, but basic functions work, and we hope to make it usable for real applications. For TingoDB this means that it gets a lot of additional tests from complex tool and it will help to improve its quality.
It is trivial thing and we never used it. But others do, and now it is implemented. As usual it fully support indexes where appropriate. $exists operation is available starting from version 0.1.7
Initially we didn’t implement it because it is kind of useless for in-proc implementation as you always can do any post filtering with same efficiency.
However based on user feedback we decided to implement it for compatibility purposes.
The $where clause is available starting from version 0.1.5
While implementing our app we come to situation when multiple indexes on same collection significantly slowdown search. In our example we have collection that store information about financial transactions. To speedup app we need to maintain separate helper collection that holds links between accounts and transaction splits. This helper collection holds account and transaction ids with some derivative information like date and sum. It has indexes for both account and transaction ids. During update we use search query that include both ids and by default TingoDB tries to use both indexes. It found ranges and then intersect them. With some experimentation we found that using only single transaction id index can speedup thing a lot. This happens because transactions usually consists from few splits (usually two). So, using only one transaction index to fetch those few records with additional check of account id fields appears to be much faster that using both indexes.
Probably this is good example why MongoDB support search hint option which you can use to point exact index you want to use. So it was easy to add this support and we did it.
Hints option is available in TingoDB since version 0.1.3
After about 3 months of work we proud to announce first public release of TingoDB.
Module is pushed to npm repository and some initial documentation is ready.
So far we successfully integrated it into our application and it works for us the same good as Mongodb.
Take a look, and give it a try !