Looking for database search engine?

[gbethel]

Is there a way to search the database by component properties? For example, a way to list weapons that are capable vs. seaskimmers or to list ships that are capable of replenishing/refueling ships at sea.

[Amnectrus]

If you know SQL, you can open the database file in a program like SQuirreL or other SQLite client and then run queries on it, and get back all the info you want. I've done a fair amount of poking around and you can find interesting stuff like what the stealthiest planes are, or which planes have LPI radar, or which units have the most sensitive ESM gear, or which IRST or camera systems are the best. The tables are pretty well normalized but can be confusing until you learn how they're all related. It's disappointing that none of the CMANO unit database sites so far have had that kind of searching, and some don't even show all the data that's actually available for each item, but I haven't been motivated to write a better one myself yet... When I need to find a specific thing, I still just fire up SQuirreL.

[tjhkkr]

ORIGINAL: Amnectrus
If you know SQL, you can open the database file in a program like SQuirreL or other SQLite client and then run queries on it, and get back all the info you want. I've done a fair amount of poking around and you can find interesting stuff like what the stealthiest planes are, or which planes have LPI radar, or which units have the most sensitive ESM gear, or which IRST or camera systems are the best. The tables are pretty well normalized but can be confusing until you learn how they're all related. It's disappointing that none of the CMANO unit database sites so far have had that kind of searching, and some don't even show all the data that's actually available for each item, but I haven't been motivated to write a better one myself yet... When I need to find a specific thing, I still just fire up SQuirreL.

Thank you for this... this is great... it is useful to know who has what and because of why...