Achieve compatibility with Payload CMS

[AlekSi]

https://github.com/payloadcms/payload

Tasks

Beta Give feedback

1. Support geospatial queries #128
   0 of 2
   area/indexes code/feature not ready +3
2. Support nested arrays #3189
   code/feature not ready +2
   
3. Implement the $near geospatial query operator #3193
   code/feature not ready +2
   
4. Implement the $maxDistance geospatial query operator #3190
   code/feature not ready +2
   
5. Implement the $minDistance geospatial query operator #3191
   code/feature not ready +2
   
6. Implement $facet aggregation pipeline stage #1420
   area/aggregations code/feature +2
7. Implement fields projection for findAndModify command #1745
   code/feature not ready +2
   
8. Implement $first accumulator #2128
   area/aggregations code/feature +2

[TimHal]

Hi Alexey! I've heard about Ferret just a short time ago, thanks to Hacker news and was instantly thinking about payload.
I've been using payload for quite a bit now and if I can help you/get involved I'd be happy to pick up any tasks and let you know how it goes, once I am able to set up everything.

The only thing that concerns me a bit is that Ferret does not support nested arrays, I can try to set up a minimal breaking example based on that over the weekend I hope.

[ptrfarkas]

@TimHal of course, you are welcome to get involved, and please let us know if we can help with anything here!

[b1ron]

So far all that's required for a payload-website is #3192. #1745 is also required but the application just sends an empty fields document we can do a bare bones implementation or even a stub.

[DanRibbens]

Hello from Payload!

This is really cool to see you guys working on this!

So far all that's required for a payload-website is #3192. #1745 is also required but the application just sends an empty fields document we can do a bare bones implementation or even a stub.

There is a chance that the use of $first goes away once we get our 2.0 changes finished. The branch and code to keep an eye on is https://github.com/payloadcms/payload/tree/feat/db-adapters/packages/db-mongodb.

I'll keep you posted if anything else changes.