Database Progress

Posted By on October 29, 2014

I’ve been telling you about working on the databases which will be serving up most of the content for this site.  A relative who runs a successful web hosting company has been helping me with some aspects of the site and databases.

It’s still growing but at this time, there are:

  • 14 databases
  • containing a total of 64 tables
  • 768 total fields
  • 116 relationship paths
  • each containing about 70 to 38,000 rows.

The sum total should yield in excess of ~49,928 pages of U.S. philatelic information. A few foreign items but not many at this point.

Potentially this will grow by another 30,000 pages of US information and another 27,000 pages of other, more generic philatelic information including the largest philatelic glossary on the internet covering 31 languages.

Eventually I will add more topical and foreign information.

I have developed the requirements and specifics of each database.  This past weekend we had a meeting and reviewed the design requirements for the first set.  We discussed them and several good suggestions were made. I’m expecting comments and questions as they are being created over the next couple weeks.  The content for this set has been prepared, formatted and is ready to be imported.  After we’ve tested them, we’ll make the pages available to the public as a beta test and move to the next set.

The initial content will be basic until they have been beta tested and any corrections or additions are made.  Additional content will be added.  These include searchable directories for a stamp events, philatelic organizations, philatelic glossary/dictionary and a large directory of philatelic book and publications.

The next set will include a content management system, predominantly for serving articles.

The stamps database is in progress and is massive. For content development purposes has been broken into three subsections; technical data, subject bio data and related historical information. Although this represents the core of this website, it will probably be one of the last databases uploaded due to it’s size and complexity.

I’m real excited to see this all finally coming together.

Keep an eye on the site… much more is coming!





About the author


Leave a Reply

Please note: Comment moderation is currently enabled so there will be a delay between when you post your comment and when it shows up. Patience is a virtue; there is no need to re-submit your comment.

You must be logged in to post a comment.