Home
DC Hero?
The Beginning
The Database
The Event
The Split
The Money
The Company
The Business
The People
The Plan

Questions / Comments??

All original content is ©2003 DC Hero & Co. All rights reserved. All copyrighted material mentioned is © of their respective owners.

 

The Database

 Too Much Work

Back in the early days of the Tie Fighter Alliance, things were easy.  We had a few pages that Shawn and I could keep up without a problem.  We were a small and growing club, then Shawn got us into a War with a fairly new but very large club called the New Republic Navy (NRN). 

Between being in an open war with one of the largest clubs on the zone and allowing just about anybody to join the out club, we ended up getting about 10 - 15 people joining our club every week. Between adding new names to the rosters and squads, making changes to rank and squadron assignments and just general maintenance I ended up with not much free time.

 The Database

I knew there must be a better way.  Our web hosting service offered a free database with the account we had so I ordered one.  I had a little dbase experience at work, but had no clue about how that translated out to the Internet.  My first project was to automate the rosters and squadron listings so that they could be maintained from a secure web page.  This proved to be a daunting task that I spent well over 2 months actually figuring it all out. 

The database itself was mSQL and I used PHP/FI (aka PHP2.0) to access it. PHP3.0 came out and I made the changes, then mSQL had problems with a new version of Apache (the stuff that actually serves up web pages) and I had to do an emergency switch to a different database called MySQL, which was reported faster, more stable and had more functions.  This proved to be true.

Note: These pages are for historical purposes and content has not been updated since 2003