I stumbled upon an issue using MongoDB. I cannot save data with arbitrary precision and use aggregation as I intend it to do. I use price amounts and exchange rate fields.
MongoDB (documentation) suggests workarounds that won't work for me or are not satisfying my requirements.
In my case, MongoDB suggests storing the numbers as strings. The problem is that I cannot use aggregation on those fields and I have to do that programmatically, which is inefficient I think.
Do you know of a free NoSQL database that supports number fields similar to what we know from classical RDBMS systems (numbers with precision and scale) so that I can apply aggregate functions on them similar to a
select count(1) from table;
It does not have to a transaction database (i.e. ACID compliant). All I wish to have is arbitrary precision and the functionality to apply aggregate functions on it.