Looking for database search engine?

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

Looking for database search engine?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [New Releases from Matrix Games] >> Command: Modern Operations series >> Looking for database search engine?

Page: [1]

Message

<< Older Topic Newer Topic >>

Looking for database search engine? - 7/23/2018 8:45:36 PM

gbethel

Posts: 47
Joined: 10/22/2014
Status: offline

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.

Post #: 1

RE: Looking for database search engine? - 7/27/2018 7:26:50 PM

Amnectrus

Posts: 80
Joined: 10/22/2015
Status: offline

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.

(in reply to gbethel)

Post #: 2

RE: Looking for database search engine? - 7/27/2018 8:56:50 PM

tjhkkr

Posts: 2428
Joined: 6/3/2010
Status: offline

quote:

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...

_____________________________

Remember that the evil which is now in the world will become yet more powerful, and that it is not evil which conquers evil, but only love -- Olga Romanov.

(in reply to Amnectrus)

Post #: 3