Support capped collections and tailable cursors

[ferretdb-bot]

https://www.mongodb.com/docs/manual/core/capped-collections/
https://www.mongodb.com/docs/manual/core/tailable-cursors/

Blocks #76.

Tasks

Beta Give feedback

1. Make collStats calculate collection size accurately after deletions of documents #3483
   area/diag backend/pg backend/sqlite code/chore not ready +5
   
2. Enable all tests for capped collections dance#604
   code/chore +1
   
3. Implement Collection.Compact for SQLite #3469
   area/admin area/oplog backend/sqlite code/chore community good first issue hacktoberfest +7
   
4. Implement Collection.Compact for PostgreSQL #3484
   area/admin area/oplog backend/pg code/chore +4
   
5. Implement compact command #3466
   area/admin area/oplog code/feature community good first issue hacktoberfest +6
   
6. Add test for tailable cursor with non-capped collection #3462
   area/cursors area/oplog code/chore +3
   
7. Call ANALYZE less often #3518
   area/diag code/chore community good first issue hacktoberfest +5
   
8. Support create for capped collections #3458
   area/oplog backend/pg backend/sqlite code/feature +4
   
9. Support InsertAll and FindAll for capped collections #3490
   area/oplog backend/pg backend/sqlite badly estimated code/feature +5
   
10. Support finds showRecordId #3467
    area/oplog code/feature +2
    
11. Enable all tests for tailable cursors dance#605
    code/chore +1
    
12. Support DeleteAll for capped collections #3498
    area/oplog backend/sqlite code/chore +3
    
13. listCollections.cursor document should contain more fields #2815
    area/cursors area/indexes area/oplog code/enhancement +4
    
14. Improve validate diagnostic command #419
    area/diag code/feature good first issue +3
    
15. Allow sorting by $natural #3638
    area/oplog code/feature not ready +3
    
16. Support capped collection clean-up #3459
    area/oplog code/feature +2
    
17. Add tests for cursors #3818
    2 of 2
    area/cursors code/chore +2
    
18. Support tailable cursors #2283
    3 of 3
    area/cursors area/oplog code/feature not ready +4
    
19. Investigate CursorNotFound error #3739
    area/cursors code/chore +2
    
20. Propagate maxTimeMS of find and aggregate to getMore #2983
    area/cursors area/oplog code/enhancement not ready +4
    
21. Support maxTimeMS in getMore command parameter #2984
    area/cursors area/oplog code/enhancement not ready +4
    

[AlekSi]

The first version with capped collections and tailable cursors is out! See https://github.com/FerretDB/FerretDB/releases/tag/v1.18.0