c/driver_manager: driver manager searches /etc/adbc on macOS by default

[amoeba]

What happened?

Sorry if I misreading the code and docs.

It looks like the behavior on macOS when LOAD_FLAG_SEARCH_SYSTEM is set is for the driver manager to search /etc/adbc:

arrow-adbc/c/driver_manager/adbc_driver_manager.cc

Lines 295 to 297 in 6a8c2ae

	#ifndef _WIN32
	// system level for windows is to search the registry keys
	const std::filesystem::path system_config_dir("/etc/adbc");

This isn't an expected location for macOS. On macOS, the more conventional location would be /Library/Application Support/ADBC I think. See https://developer.apple.com/library/archive/documentation/MacOSX/Conceptual/BPFileSystem/Articles/WhereToPutFiles.html.

If the resources apply to all users on the system, such as document templates, place them in /Library/Application Support. If the resources are user-specific, such as workspace configuration files, place them in the current user’s ~/Library/Application Support directory.

Am I reading the docs and code right? If so, I'd like to propose changing the behavior of this on macOS and updating the docs.

Stack Trace

No response

How can we reproduce the bug?

No response

Environment/Setup

No response

[amoeba]

cc @zeroshade

[lidavidm]

Agreed that we should follow macOS convention.