Access to the data is via the Web Query tool on this site or though applications residing on your machine. Directly accessing the database is possible using the following methods:
If you would like to save or manipulate the data without using any of the above three methods, the Web Query tool allows saving the query results as a comma delimited file or it can directly load the data into an Excel spreadsheet.
Since the data resides within a relational database, some knowledge of SQL is required to access the data unless a non-SQL based front-end tool is used. Microsoft Access®, Microsoft Query®, Brio®, etc. are examples of some available tools that do not require the use of SQL. To learn how to use SQL or if general SQL help is required, try a Web search engine (Google, Alta Vista, Yahoo, etc.) with the phrase learn sql.
The site uses Postgres (currently at version 8.0.2) as its database management system. For more information regarding SQL as implemented by Postgres, see their web site.
AviationDB will be happy to build a custom user interface, design and run database analysis routines, and/or help with the installation of client software should those services be required. See Custom Services for more information.
The client configuration parameters for any of the options below to connect to AviationDB are:
A simple program is available as an example and for verification. Note the connection parameters coded (see the above listing) as you will need these for your own program.
