spacer.png, 0 kB
Personal Blog


My Camera Equipment

« Music | Main | NeatStuff »

MyApplications

Regina's personal blog

Thursday, June 25, 2020

WiredPages News Headline Feeds- Status

Late Friday, June 19, 2020, I noticed a couple of issues with several of the news headline feeds maintained on WiredPages.

Over the weekend, I had most of the issues worked out, however decided not to install all of the updates, because I wanted to thoroughly checkout the new resources.

Below, illustrative examples of the feeds that were not installed, however ready for live production.

Currently, the following WiredPages are using live versions of new headline feeds:

In total, there were 8 pages affected by the Friday night outage, so I was happy to find solutions as quickly as I did.

Another major issue, I had to switch the (site) server for the new Java Servlets used to provide the news headlines. qisoftware.com is my main site, however when I have SSL protocol issues, I have to move programs and applications to my hosting site-- hosting-q.com.

This the other reason, I am holding off on installing all of the new programs at the same time. I am always concerned about server overload, so I am installing one or two updates at a time and checking. I am not sure why I have site load issues. According to most statistics related to my sites, I should not have any. Why the conflict (FBI)?


Sunday, June 14, 2020

Instagram API Interface Migration

In July 2018 (blog post), I developed an Instagram API Demonstration Interface to showcase how social media API resources can be customized for individual sites and blogs.

Last fall, I noticed Facebook had taken over management of the Instagram API, however I thought- because my interface only accessed QiSoftware's Instagram data, there would be no need to migrate the tool to the Facebook platform.

I noticed something in a forum post last week, so I checked again and decided- to be on the safe side, I would migrate the interface to the Facebook platform. Spent most of the day (today) on this project.

This was a little more effort than I thought it would be, however when I realized my mistake, the task became relatively easy.

Another easy thing today- lunch.

Yesterday, I made enchiladas and tacos with enough in the way of leftovers for lunch today. So in between debugging and playing with Postman, in an attempt to figure out why I could not set up the correct access tokens for the Facebook/Instagram Graph API platform, I did not starve because I forgot to eat. I could not wait for lunch...


Saturday, June 06, 2020

WiredPages- New Tools Ready For Installation

I mentioned in the last post, there are several new tools ready for installation on WiredPages.

The following summarizes each tool, and provides illustration as to how the new tool will appear on each page.

The WiredPages Home page will get a Market Indices bug, which will provide timely information about stock markets.


The WiredPages Real Estate page will get a Mortgage Calculator.


The WiredPages Business & Markets page will get the Market Indices bug along with a Biz Zip Search tool.


The WiredPages Style & Events page will get the "This Day In History Calendar". Click on any day and the tool provides important events in history for that day.


The WiredPages Media page gets the NPR One StationFinder interface.


The WiredPages Health & Wellness page will get the FatSecret Nutrition Information Search tool.


The WiredPages Arts & Entertainment page gets the Youtube Music Video Search & Playback tool.


The WiredPages Reference page gets the World Factbook interface.


The WiredPages Technology page will get the Alexa Site Rank tool.


There are several other tools in the works, however the tools listed here are ready for installation. Why not install now? Security and potential server load issues. Why continue to develop new interfaces? I hope my issues will be resolved and quite frankly, I love developing new software tools for WiredPages.

Note, the overlay for each tool is larger for illustration purposes.


Sunday, May 31, 2020

SQL Driven World Factbook Preview...

Some of you may remember, the WiredPages Reference page maintained a mini version of CIA's popular World Factbook.

The original interface, parsed the actual World Factbook site files to provide abbreviated data for WiredPages' visitors. As soon as they redesigned the site, my interface was dead. However, I have the original code for proof.

Several years ago, I found online, a 2013 SQL database of the World Factbook. Periodically, I work on the new interface, a Java Servlet that incorporates JDBC to access the underlying SQL data tables.

I am in no hurry to install the interface because my online server is too open and not secure enough. I have no desire to provide the data nor my interface to anyone who wants the data. Some justify, access to my servers by claiming an ongoing investigation. I have reminded the FBI and other legal authorities, they claimed in 2012 a huge mistake was made and they were looking at cleanup efforts. What are they investigating where I am concerned? I said no, I do not authorize illegal access to my sites. I repeat, FBI what questions do you have for me?

I am told that Q's Wire has been tampered with so much, those hoping to claim a libel suit, cannot, because the FBI knows about the tampering. My Thingamablogs [this blog, Remix] are maintained off-line so I do not have the same concerns.

That said, I keep all of the original text files for all posts to any blog on qisoftware.com. So, I can prove what I wrote and what I did not write. The other problem? Timeliness. There is a statute of limitations on a libel suit. I am also not malicious. I wanted others to notice the odd things about my case.

In any case, I stopped posting to Q's Wire long ago, however will add a post every now and again. This post is typical of the type of post I used to post to Q's Wire.

That said, as I have done with many of the interfaces ready to install however sitting safely in my briefcase or a hard drive that goes where I go, I provide a preview of what I am doing and how it will work.

This morning, I did a little more work on the World Factbook interface.

I did not anticipate any problems with development of the new World Factbook interface, just how to get it done in my local environment. You might be surprised by how hard it is to work in a secure area even in my local development environment.

I am pretty pleased with the number of interfaces I have ready to install on WiredPages. Part of the problem, malicious users might take my server down just playing around with the many tools. The other problem-- just too many have too much access to my online sites, and I said no... FBI this is repeated here.


Friday, April 10, 2020

NPR Station Finder Demonstration

As I have already mentioned, I have been working several projects including a new tool for the WiredPages Media page, the NPR Station Finder.

Work on the new interface, a Java Servlet is mostly complete and ready for installation however, a slight delay because I am still checking for any issues that might be problematic.

The following graphic, illustrates how the tool will render search requests based on location.

The video, demonstrates the tool running in local mode from the Netbeans Integrated Development Environment (IDE).

The video suggests a demonstration of the portable features of my development platform is in the offing however, is provided through the following photos.


Monday, March 30, 2020

NPR One API Interface

Recently, when I finished work on the new Amazon Product Advertising API interfaces for WiredPages, I decided to continue with other software projects, specifically an effort I put aside sometime ago.

The NPR One API resource is an interesting project, and quite frankly when I signed up over a year ago, I thought I would get back to the project a lot sooner. Part of the problem, it took longer than usual to set up the correct authorization procedures. When I finally "correctly" initialized all of the codes, I felt most of the hard work was done and it was only a matter of writing the interface.

Below, illustration of work completed on the project, with still lots more to do...

One of the biggest obstacles, I thought I could use HTML5 audio features to enable live streaming of radio programs. I could not. So I spent most of the weekend coming up to speed on a popular jQuery Player.

Over the years, I have decided against using cutting edge technologies like JQuery and AJAX because a lot of my development hardware is older and cannot support those newer technologies. However, what this has enabled me to do, is insure my sites work with both new and old technologies. My old desktop Mac can still run most of the tools on my sites without issues. Today, there are very few sites my old desktop Mac computer can visit.

Now, I do have access to newer hardware, however up until recently, my newer hardware was for testing and not development work. These days, I am using a Windows 10 Pro mini for a lot of development efforts. Updates to SSL protocols left me with little choice but to afford a newer development platform-- see the Items I Have link for more information.

So, back to my efforts this weekend... I am pretty happy with the jQuery Player I will be using for the NPR One API project, and will have to get over the fact that some of my hardware platforms will not be able to provide the live radio streams from NPR's network of stations.

The new tool is a Java Servlet and will be installed on the WiredPages Media page.


Saturday, March 21, 2020

Amazon PA API5 Updates

Earlier this week, I noticed I had access to the Amazon PA API, so I decided to take the opportunity to convert my old PA API 4 tools, to the latest release (PA API 5). Efficiency guidelines, periodically disabling the resource, so this was my first opportunity to work with the new API.

I am not sure why, I thought the new release of the API would be easier to use, as related to development efforts for Amazon Product Search tools. In my opinion, the earlier release, PA API 4 was easier, especially the signing process.

That said, after some research and testing, I was able to get three program versions working using different frameworks:

  • Java Servlet not using the Amazon supplied SDK
  • Java Servlet using the SDK
  • PHP Version

When I install the new tools on WiredPages, I will be using the Java Servlet version which does not incorporate the Amazon supplied SDK. The following graphics illustrate how the new tools will look on the site, however [shown below] running in local mode from my IDE (NetBeans).

If you are familiar with my earlier Amazon Product Search tools, you will note the new tools are similar to the old. Updates also included new search categories. I will probably release the new tools sooner rather than later, however I am still researching security issues. Think I have found most of the program bugs.


Saturday, February 15, 2020

New Tool in the Works, Alexa Rank Check

Yesterday, I completed most of the work on a new tool that will provide Alexa Rank information for a specified website.

Plans are to install the tool on the WiredPages Technology page, however not sure when this opportunity will present itself. Related issues include; (1) Access to Amazon Web Services (AWS) data is billed based on usage, (2) the popularity of a tool like this could affect my web hosting plan and (3) security is always an issue for me. At this time, too many have access to areas of my site, which I cannot prevent.

Keep in mind, I am a sole proprietor and have no business partners as related to software development (see Business Partnerships for more details). I do maintain several advertising affiliate relationships as outlined in my disclosure policy.

Also note, the tool is still in checkout mode so I may change elements of the user interface, i.e., graphics, font sizes, etc., before the actual installation.


Thursday, February 13, 2020

Ham & Cheese on a Croissant...

Yesterday, I stopped by Costco and Safeway. I thought I would be doing all of this shopping on Friday, however weather forecasts though calling for rain, seemed to indicate the precipitation would begin late in the day, so I thought I could get most of this done by noon. Actually, arrived home after two, so it took longer than I expected.

For some reason, I have been craving a ham and cheese sandwich on a croissant along with a strawberry milkshake. So along with necessary staples, i.e., bottled water, paper products, coffee, etc., I thought I would get the ingredients to satisfy my cravings.

Strawberries were a little more expensive than I thought they would be, so I did not get the ingredients for a shake but did get everything I needed for my sandwich.

The croissants and pepper jack cheese purchased from Costco, and the ham, lettuce and tomato picked up from Safeway.

Other things I have been working on?

  • Updating my local master copy of the Celebrity Birthday Database (security issues preventing the online installation of the master version of the database). The almost 4000 entries included in the offline version are being checked for dead biography.com links which are being replaced with Wiki links. Very tedious process, however the database should be pretty robust by the time the work is complete.
  • Researching a problem with the "Who Are My Legislators?" interface accessed from the WiredPages Government page.
  • Reading, "Secrets of a Charmed Life" by Susan Meissner

Things are working out with my new Windows10 Mini insofar as duplicating my software development environment. Working a number of issues and ensuring I can duplicate development efforts normally worked on my older Mac system.

The cost to provide this duplicate development environment, given I needed new hardware and operating system to work effectively with newer technologies, was something I could afford at this time.


Monday, January 13, 2020

Upgraded Windows 10 Development & Productivity Environment

Recently, I upgraded my Windows 10 work environment from a tablet to a mini Pro environment.

Components of the new system include:

Currently, I develop software using a Macbook and Netbeans. Just for your information, however not related to my software development issues, my Thingamablog blogs are hosted on the Macbook (Remix) and a Windows XP (It's Personal [this blog], Résumé) platform. Thingamablog runs on a local system, i.e., PC or Mac and is written in Java.

The reasons I needed to upgrade this work environment? New security protocols (SSL) my older systems could not handle because newer releases of Java were not supported on the older systems.

The other problem? My Windows 10 tablet did not have enough, in the way of resources, to handle the installation of more recent software development tools.

I chose a Windows 10 Pro Mini, because it offered a quick, less expensive solution.

I installed recent releases of the Java SDK and Netbeans on the new Windows 10 Pro system. This enabled my development environment to handle the newer security protocols being used by today's websites and producers of API and XML data.

Happy to report this upgrade went well, and looking forward to adding a newer Mac Mini to my development environment in the coming year.


Saturday, November 09, 2019

The Start of Something New (Research Phase)

Recently, I have been giving serious thought to the start of something new. Two years ago, I registered two new domains:

  • Hanover-Magazine.com
  • hanovermaryland.org

My thoughts at the time were to expand on my efforts related to the Hanover MD Businesses page, I maintain on Facebook.

The expansion would include an online magazine with hard-copy editions for the eleven or so area hotels, features related to the areas many social and media events, community events, the exponential growth in the real estate market as well as the business environment which has always had a strong presence in the community.

The related hanovermaryland.org site would be more of a directory, dynamic information site about the area and businesses. What's new, business listings, events calendar, etc.

Recently, I also started two new social media accounts (in addition to the older account, also listed):

  • HanoverMagazine on Instagram
  • HanoverMagazine on Twitter
  • HanoverBusinesses on Instagram (older account)

Shown below, existing pages associated with my Facebook account which may also- be of use with this project.

I love Autumn, so with the onset of the new season, I thought I would roam the area, researching and gathering ideas for this magazine project. Below a collection of some of the photos I have taken.

The area has all of the right elements to take seriously a project of this nature, including location, an international airport, one of the largest malls in Maryland, a major casino and easy access with plenty of parking.


Monday, May 20, 2019

Lazy Sunday

Yesterday morning, Sunday, I got up early, took a shower and made dessert (fruit tart discussed here).

Then I dressed (hair & makeup), and decided to enjoy Sunday morning driving around town. Some things I noticed...

Last week, because I am always researching new ways to generate revenue from my sites, I signed up for a new affiliate marketing program. Often, I try to develop new programs for use on WiredPages and this blog using affiliate API network resources. For example, see this link.

So yesterday, after returning from my drive, I sat around reviewing some of the affiliate merchant programs offered by ShareASale.com.

I also made a pizza and watched a movie, "Jennifer 8" on television. The illustration below shows the other side (see last post) of the main entry. Behind me on the right, is the closet and on the left, the hallway leading to the informal dining room off the kitchen (working on the smile, issue).

Then I went out to my gardens and took photos...

Came in, updated some of my stores, had dessert and went to bed around 9:00 pm.

Thought the new episode of Showtime's "Billions" was coming on last night, however research provided the new segment is scheduled for next Sunday. Think it is the season finale.

Did you have a nice weekend?


Thursday, April 11, 2019

This Day In History Calendar: Java Applet to Servlet Conversion

Work continues in the process to convert all of my Java applets to servlets. The latest effort, the "This Day In History (TDIH) Calendar" applet illustrated in the following graphic.

You may recall, the TDIH applet originally ran on the WiredPages Style & Events page.

Since most modern desktop and tablet i.e., iPad/Android browsers no longer support Java Applets, I have been in the process of converting the applets to servlets.

The graphic on the left, illustrates the new TDIH Calendar as a Java Servlet. The html code snippet on the right demonstrates in real time, access links to the history.com site for April historical events that happened on the specified day.

Sun Mon Tue Wed Thu Fri Sat
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30        

Though most of the work on the new servlet has been completed, I am not sure when I will install the new tool.

Related Effort: The old Blogger Calendar applets will also be rewritten using a lot of the underlying code from this conversion effort.


Monday, March 04, 2019

Go Figure.

On February 24, 2019, I installed a new tool for job seekers, refer to this post.

On the first of March, I noticed both CareerOneStop resources I installed on the WiredPages Employment page no longer worked. I tweeted about it.

The Occupation Wage Data tool as discussed in this post, was installed September 23, 2018.

The CareerOneStop APIs are offered by the U.S. Department of Labor. On March 1st both tools were rendered inoperable because of a new requirement dealing with TLS protocols put into place by the government agency running the API service.

On Saturday, March 2, 2019, I fixed the TLS handshake problem by adding the following line of code to each of the Java servlets used in the deployment of the tools (keep in mind I use a private JVM on my hosting platform):

static {System.setProperty("https.protocols", "TLSv1,TLSv1.1,TLSv1.2");}

This morning, the tools are again inoperable.

Go Figure.......................................

More information: As I indicated the tools were operable all day Saturday and Sunday, however this morning the Protocol Handler was paused (reviewing Private JVM log files-- not shown "null pointer returned" for each request). Not sure why.

Mar 03, 2019 3:01:27 PM org.apache.catalina.core.StandardServer await INFO: A valid shutdown command was received via the shutdown port. Stopping the Server instance. Mar 03, 2019 3:01:27 PM org.apache.coyote.AbstractProtocol pause INFO: Pausing ProtocolHandler ["http-apr-13895"] Mar 03, 2019 3:01:27 PM org.apache.catalina.core.StandardService stopInternal INFO: Stopping service Catalina Mar 03, 2019 3:01:27 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc SEVERE: The web application [] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. Mar 03, 2019 3:01:27 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads SEVERE: The web application [] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak. Mar 03, 2019 3:01:27 PM org.apache.coyote.AbstractProtocol stop INFO: Stopping ProtocolHandler ["http-apr-13895"] Mar 03, 2019 3:01:27 PM org.apache.coyote.AbstractProtocol destroy INFO: Destroying ProtocolHandler ["http-apr-13895"]

A lot of my case involves, how could all of this have happened. When I work hard to install operable tools and someone interferes with my efforts, I have to show how and why these issues might be in play. Just wanted this issue noted.

I spent a bit of time researching and developing these tools. I do not like my work tampered with, especially when I have an ongoing case.


Thursday, January 24, 2019

January 2019

I have been working a number of projects, illustrated in the diagram below.


  • Several license/registration related renewals this year, including MVA.
  • Gathering tax related documents and starting my TurboTax process.
  • Finance moves, hoping to get the best returns on my meager savings. Switched funds in a recently matured CD, to a CD with higher interest rates. Went from 1.75% to 2.85%. Happy with the timing on all of that.
  • Last but not least, preparing (setting up development environments on my MacBook and WindowsXP systems) for more efforts using the c++ programing language.

Lately, I have spent a lot of time on software efforts. Several problems with API resources that have me searching for workarounds. You may have noticed issues with WiredPages.

To a lesser degree; efforts with taxes, finance and state renewals-- nevertheless important projects that I need to get out of the way. Simply a matter of gathering paperwork and submitting requests.

Maryland's Motor Vehicle Administration- in keeping with Federal law, now requiring new procedures for renewals. Happy to report, this seems like an easy adjustment to my plans and moving along.

Several in my family are affected by the Federal Government's partial shutdown so things are a bit low key. I am self employed. I have been working late hours and hoping things work out.


Sunday, January 13, 2019

Snow Day

It started snowing yesterday evening around six, and has continued throughout the morning.

I am working an OAuth issue with an API service, (the WiredPages WeatherTool is unavailable at this time), so I had no plans to venture out.

The new year brought any number of issues, I was not expecting. That said, pretty pleased I think I have found solutions for most of the problems.


Wednesday, December 19, 2018

USPS Biz Zips Tool

I started work on the USPS Business Zip Tool. The tool (Java Servlet), is powered by the USPS Webtools APIs and will be installed on the Wiredpages Business & Markets page. Work is almost complete.

The following video provides a simulated look at how the tool will function. This is a simulated demonstration because I used the HTML results file provided by the program and not real time program execution results. The screen recorder(great resolution) I use is installed on my Android.

Screen grabs of the new tool.

I have minor changes I want to make, however in no hurry to install the new tool. I probably will have it up before the end of the year, however I may wait until the new year. Security and server loads always an issue.


Monday, November 19, 2018

Amazon API Quick Search

Busy week. My Mother's birthday was Saturday, so preparations for Thanksgiving and her birthday kept me busy. In addition, I continued working the many software projects I have on my to-do list.

A recent software addition, or I should explain- replacement interface is illustrated below.

The tool replaces the Amazon Gift Ideas interface that was in place on the WiredPages Shopping page. I chose to replace the interface because (1) it mirrored the items found here, and (2) the Amazon Product Advertising API had to be called individually for each item listed. Server and timing issues were not as efficient as I would have liked.

The new interface only calls the API once per search, however offers several different products as part of the results. Of course, users may want to search again and again, so that might generate multiple calls to the API.

The new Amazon interface, like the Best Buy Tool, is quick. This was an important reason in the decision to replace the original interface used on the Shopping page.

Though the new interface is already installed on WiredPages, I am still taking it through its paces [debug checkout], however I think there are very few issues, if any. If you want to drop me a line-- you may use the email address provided by the WiredPages news service.


Friday, November 09, 2018

Instagram API Demo Fix...

This morning, I added two new photos as part of a story to my Instagram feed. When I checked the QiSoftware Instagram API Demonstration Tool, I noticed the error illustrated below, in the image on the left.

I am happy to report, the correction involved a simplification that is going to make my server happier. I was parsing the data, based on the type of post, i.e., single image, story carousal or video, and not the top level container for the post. Less "if" branching. Pleased with how this worked out.

Other projects?

Planning for the Holidays? Lots of things going on in my hometown. How about yours?


Wednesday, October 10, 2018

Best Buy Developer API Demonstration

This is a brand new interface that uses the Best Buy Developer API to search for products from their catalog. My predefined search criteria [UHD 65" TV] was selected based on Fall television viewing habits, however you may try anything.

The interface is in checkout mode, so feel free to let me know about any problems you find.


Thursday, September 13, 2018

WiredPages Weather Tool

Started work on the new WiredPages Weather Tool.

The old interface, illustrated in the QiSoftware Product Catalog is a Java Applet/Servlet combination.

The new weather interface, is a server side Java web application [Servlet]. The new tool will allow access via web browsers installed on most platforms including iPads, Androids, wireless devices, desktops, smartphones, etc.

Not sure when the new interface will be installed. Still working design issues and checking security risks. The new tool will be accessible through the WiredPages home page.


Monday, September 03, 2018

Ready For Fall

Labor Day, the unofficial end to summer. It has been a busy summer for me.

Some of the things I have been up to:

Friday (08/31/18), I started work on a new interface to replace a Java Applet that provided a snapshot of the market indices. The old applet was located on the home page and the Market & Business page.

This 30 second video, shows where I am in the development process for the new Java Servlet.

Also on tap this summer, like every summer- my age climbs higher. Recent photos...

Why not dye my hair? Believe it or not, some are not sure if it is my hair. Four years ago when I dyed it a darker brown than my actual color-- it looked more like a messy wig.

Today, I really do not get out a lot, however when I do-- you might be surprised by what tends to be a curiosity. Why is that hair so big and messy? I have a lot of hair that is very porous [like a sponge it absorbs steam and humidity]. People have done odd things. I do not want to be tested.


Tuesday, August 21, 2018

New Wages Data Tool (coming soon)

Big event over the weekend, however about all I want to say at this time. Everything on track. Waiting on repair people.

In other news, working on a new tool for the WiredPages Employment page.

Short video to demonstrate how the interface will work.

You may have noticed one of the tools on the Employment page was removed, so this interface will be integrated sooner rather than later. I am still tweaking the appearance and testing different results [debugging] from the API. Should be installed within the week.


Friday, August 17, 2018

Celebrity Birthdays- Database Tampering

On November 29, 2011, I wrote about an incident involving my Celebrity Birthdays Database. The article is rather lengthy, however discusses in some detail how and why I created the database and related Java Applet & Servlet that were used to both update and display the database information.

The article, provides an illustration of the number of records I had in my local [offline] database at the time of the article [Nov. 29, 2011]. The following diagram shows the same illustration side by side with today's record count in my local database.

The data is credible because it was extracted from the Biography.com site. Initially, the data was gathered using a custom program [Java JDBC/servlet] I developed which parsed the biography.com html file relating to current birthday information and added the entries to the online database.

When I first developed the servlet which extracted data and updated the database, I was unaware my server and database were so accessible by anyone who wanted the data. I also discovered the data was being tampered with. That is why on April 29th, 2011 I accidentally, deleted all of the records. I used the "<>" the wrong way. So it really was an accident. I was trying to make the data less attractive.

Biography.com provides an HTML page showing all of the birthdays for the current day. The page also lists separate article links about each celebrity with a birthday on that day.

The custom program extracted each day; the individual celebrity article link, celebrity name, and the month and date mm/dd".

I could have left the program in place, however did not want others to use it so I deleted it. That program only needed to run for a full year. When I manually updated my local database, I did not do it with the program. I would have had to run the tool every day in local mode-- so I manually extracted the data from biography.com using cut and paste. Keep in mind, only the offline database is complete. I purposely left the online version corrupted.

The following illustration shows data in the online version of the database that I recently deleted. The records were deleted because someone inserted records with links to the biography.com html page of birthdays for the day and not the individual biography.com articles about the celebrity. I did not do this nor did my program.

In my current effort to remove all of the applets used on WiredPages, thereby using only servlets, I recently replaced the Celebrity Birthday interface used on the WiredPages Style & Events page to the new program which only uses the Java servlet.

If you do not see the interface that means the online version of the database does not have birthday records for the current day. My offline version does, and periodically I will export the records from the offline version and import them to the online database, as was the case for today, August 17, 2018.

I will install the entire Celebrity Birthday Database to hosting-q.com, when I am able to control who has access to the server. In the meantime, this provides explanation of why the interface is sometimes unavailable.

QiSoftware is a legal business entity and registered in the State of Maryland. When you tamper with my online assets you are interfering with my business ventures. Please cease and desist at once.

As of the entry time of this post-- hosting-q.com is having a problem with the with JSP, i.e., Java Servlet support. This means there are many "Service Temporarily Unavailable" messages throughout the pages of WiredPages, even though the main site, hosting-q.com is available. I host a lot of my programs on the hosting-q.com site.


Tuesday, August 14, 2018

World Factbook Project 2018

I have started work on the new World Factbook Tool for WiredPages. The interface will be located on the Reference page, same as in the past, however now- powered by a SQL/MySQL database.

I spent most of the afternoon [yesterday], loading the data to a local MySQL database on my Macbook, in preparation for the software development phase.

Some of the datasets [tables] were so large, I initially divided the data into separate files for the import. Initially, I did not use gzip files to import data, however if this had been the case I could have saved an hour or so during this phase of the project. The largest table (factbook_values.sql 5.5MB), was imported using a gzip file. I consider this an important lesson. That said, I did have to override some of the php.ini settings for phpmyadmin.

This new effort will incorporate parts of the software from the old interface [Java Servlet], including:

  • Data requests [user interface] are the same as shown in the illustration above.
  • Text output formats the same.
  • Rendering of graphics [World Flags]-- very similar.

The CIA World Factbook SQL gzip file I found in 2014, uses 2013 Factbook data. This data is relatively new [in terms of what the CIA releases to the public in this format (SQL)] and should be fine for this project.

I plan to submit a FOIA request for the latest available data, however since security issues prevent loading data to an online database, I am only concerned with development and testing of the new Java JDBC/Servlet in my local environment. If and when my security concerns are allayed- the installation of the new software and latest available database should be a breeze.

This post- provides notes on the development progress for this project.




Business Directory

spacer.png, 0 kB



Contact | Accessibility | Products | CSS and XHTML
Disclosure Policy
© Copyright 2011-2020 QiSoftware
You may not copy this work.

spacer.png, 0 kB