Monday, January 08, 2024
In November 2023, I obtained a JSON formatted data file containing the 2020
CIA World Factbook.
The World Factbook data I maintain in my local development environment is a MySQL database from 2013.
When I first downloaded the 2013 data it was stored as a MySQL compressed (GZ) database file. I did not want to maintain all of the data in my local development environment so I went through each table, only extracting and importing the data I wanted to use with my application.
Though I completed work on the JDBC Java Servlet for the World Factbook Quick Reference Tool sometime ago, the amount of work I had to do to get the data I wanted was no minor task. Therefore, I never installed the online version of the application fearing those with access to my servers would want to use the data elsewhere.
The following video, produced in August 2022 demonstrates the World Factbook Quick Reference Tool running in my local developmental environment starting about 1:21 minutes into the video.
Because the CIA World Factbook data I am using for demonstration purposes is now over 10 years old and I have more recent data in my possession, I decided to install the World Factbook Quick Reference Tool on the WiredPages Reference page.
I have some minor cleanup work on the servlet and I also need to upload the custom World Factbook database to my site, however I think I will have it up and running by the time I finish this evening. It is about 4:20 PM my time and I have one or two other minor chores to take care of before I complete work on this project.