Is this an Anaplan competitor? If so, what are your key differences, value props?
What are you using as persistence layer? Postgresql? Mysql? Commercial? How well would it compose with existing ETL and BI tools? What is the concurrency model esp with regard to planned permissioning model? What happens when two differently permissions users run the same formulas?
Just curious: if one of the product differentiators is that its semantics more closely resemble a relational database, then why not power it with a relational database?
Mongo is good for store-and-retrieve, and aggregation along a single dimension, and not as strong at the operations mentioned above.
Have you benchmarked Mongo against a relational db for analytic operations on a multidimensional model? The results could be interesting and perhaps different from what you would expect.[1]
Many new OLAP products are implemented on pure relational databases for performance reasons. Some databases with columnar indices are even faster for OLAP type operations.
[1] That said, Mongo could be a good choice for latency reasons. If your spreadsheet is doing lots of small calculations, then it makes sense to use something that can return results quickly.
Nice work though! Keen to test it out. Hopefully a mobile version is on the roadmap.
And if users drill up/down does sqlite do the aggregation or is that done by your application?
I haven't used kv stores before