Using a big amount of data in JSON files make it hard to perform complex searches.
Following the aviation series, I’ve used the information provided by the aviation-json package and performed a migration to a PostgreSQL database.
Created a module that manages the migrations for the JSON files into an SQL database, designed the structure of the databases and it’s relations.
With a single command creates the database, the user, and performs the migration.
You just need to clone the repository and execute
make from the command line.
Remember you first need to have a PostgreSQL database running.