Page 1 of 1
Looking for database search engine?
Posted: Mon Jul 23, 2018 5:45 pm
by 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.
RE: Looking for database search engine?
Posted: Fri Jul 27, 2018 4:26 pm
by 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.
RE: Looking for database search engine?
Posted: Fri Jul 27, 2018 5:56 pm
by 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...