When building a pc many parts are stated to be used with windows. Is there a site dedicated to linux users that helps with component selection?
Unfortunately there is no single database which includes all the hardware that linux is able to use without issue. The usual approach here when investigating linux compatible hardware is to search online for the item with the query about how it may work in linux. Often a user somewhere on the internet will have reported some experience in a forum, a blog, a linux news site or a mailing list etc. Then the reader is left to evaluate what they've read, in particular to assess whether the details are sufficient for a reasonable judgement to be made about whether a particular item will work with their own set up.
Here are a number of sites covering different hardware which have been accessed from here with some success by different people, but there are no guarantees of course:
A database of all the hardware that works under linux
linux-hardware.org
This site has lots of tested computers, laptops and desktops.
www.openprinting.org
This site allows one to enter a printer to see its support.
This site has a lot of discussion and recommendations. It's anecdotal and untested but nevertheless some information can be useful.
https://wireless.docs.kernel.org/en/latest/en/users/drivers.html --- existing linux wifi drivers
USB WiFi Adapter Information for Linux. Contribute to morrownr/USB-WiFi development by creating an account on GitHub.
github.com
These sites are useful when hunting for compatible wifi devices and dongles.
This site lists supported digital cameras.
Bear in mind that there can be lots of subtleties with hardware. Sometimes manufacturers use different chipsets on models with the same model number. Version numbers of hardware can be significant despite the same general model number because different versions may use different chipsets.
For flawless linux performance on hardware, there are the companies that sell computers and laptops with linux installed, e.g. system76, tuxedo.
One way of assessing whether hardware will perform under linux is to boot a live disk on the machine and check the performance of each item of interest. One needs a cooperative companion to allow this, whether it's a colleague or other person who runs the hardware of interest. In the case of a shopkeeper who sells such hardware, one needs cooperation.
The most extensive way of seeing which hardware linux can use, is to take a vanilla kernel from kernel.org and run through its configuration operations, say with menuconfig, and actually see the numerous drivers that exist to run hardware. One can look at just the area of interest, for example, wifi drivers. Then there's the matching of chipsets with actual items which can be a laborious business. Perhaps not a task for the faint of heart. BTDTBTTS.