Databases in this category are some of the most popular ones in the world with good reason. The only way you can scale is to adopt a query-free architecture.
It feels tedious at first but once you develop some good habits and frameworks around denormalization it becomes easy to do that from day one.
>> The only way you can scale is to adopt a query-free architecture
This is not really the case. There are database systems that can handle large scale and complex queries. Allthough usually at the price of providing reduced consistency guarantees.
It feels tedious at first but once you develop some good habits and frameworks around denormalization it becomes easy to do that from day one.