[DRAFT] feat: Default to LMDB backend on macOS

[dist1ll]

Description

.

How Has This Been Tested?

.

Checklist:

• [x] The title of this PR complies with Conventional Commits.
• [x] I have edited the CHANGELOG accordingly.
• [x] I have made corresponding changes to the documentation.