Compilation database generation caveats

[sim642]

This issue serves as a WIP place to collect issues and workarounds for different compilation database generators we have encounted.

compiledb

1. Doesn't properly escape -D argument values (Tmux bench#8 (comment), Other attempted projects bench#14 (comment)).
2. Errors with .deps and Makefile targets (chrony bench#17).
   • Workaround is to remove the manually.
3. Assumes English locale (GobCon 23.02.2022 notes).
4. Doesn't completely decompose multi-file targets (Compilation Database: Support for entries with multiple .c files in one command #624 (comment)).
5. Uses relative paths for preprocessing and thus in AST.

bear

1. Bear 2.3.11 from Ubuntu 18.04 produces incomplete database (OpenSSL bench#7 (comment), OpenSSL bench#7 (comment)).
   • Bear 3.0.8 seems fine.

[michael-schwarz]

Would it make sense to move this to some more permanent place (e.g. in the documentation) rather than an issue?

(An issue implies that it can at some point be resolved, which does not seem to be the case here).