4 ms·
It's of course the translation that can contain bugs. Dumb error in a date conversion? Your accounting no longer works.
by tgv 5y ago
It's of course the translation that can contain bugs. Dumb error in a date conversion? Your accounting no longer works.
- christkv 5y agoThat and significant differences in performance for more complex operations like the aggregation framework
- tgv 5y agoCurious about that. I recently made something similar, but for SQLite w/JSON. The backend can use a local sqlite3 file instead of mongodb, while using the same queries. It can only translate the queries we actually use, but it's quite doable to translate $lookup, $group and $project to their SQL equivalents (which were the inspiration for the aggregation in the first place, IIRC). Initial evaluation shows that the performance is quite good, and the translations look decent, so it might be possible to get some mileage out of ferretdb.