Download the PHP package aifrus/fc2s without Composer

On this page you can find all versions of the php package aifrus/fc2s. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of aifrus/fc2s

Informations about the package fc2s

FAA CSV to SQL (FC2S)

This project, FC2S (FAA CSV to SQL), is designed to convert Federal Aviation Administration (FAA) data from Comma Separated Values (CSV) format to Structured Query Language (SQL). The project intends to download the latest aeronautical data published by the FAA on a 28-day cycle, which they publish in CSV format. The process includes downloading the data, unzipping it, creating a new database, creating the tables (based on the current schema provided by the FAA with the download), importing the data, and then exporting the data as one large .sql file with all the tables. The final step is to zip them up and make them available to anyone who wants the data in SQL format.

FMI: https://www.faa.gov/air_traffic/flight_info/aeronav/aero_data/NASR_Subscription/

If you are only looking for the final data in SQL format you can download every available cycle from our repository:

https://github.com/aifrus/nasr_sql_zips

Acronyms

Process

  1. Download the latest aeronautical data published by the FAA in CSV format.
  2. Unzip the downloaded data.
  3. Create a new database.
  4. Create tables based on the current schema the FAA provides with the download.
  5. Import the data into the newly created tables.
  6. Export the data as one large .sql file with all the tables.
  7. Zip the .sql file.

Installation

To install the package, run the following command:

Usage Example

Below is an example of how to use the package to get the current data:

Documentation

For detailed documentation on using the library, refer to the following:

Notes

You must set mysqli.allow_local_infile = On in php.ini to allow LOAD DATA LOCAL INFILE operations within PHP scripts.

All versions of fc2s with dependencies

PHP Build Version
Package Version
Requires php Version ^7.1 || ^8.0
ext-curl Version *
ext-dom Version *
ext-mysqli Version *
ext-zip Version *
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package aifrus/fc2s contains the following files

Loading the files please wait ....