Well, I’ve just finished my UESPA-9 design in time for today’s update! Take a look at the development of the design:
I should make it clear than not everything about the design is finished. An orthographic and internal schematic is yet needed to give a complete picture, but this complete sideview will be enough to allow me to begin incorporating the design into the website fully. By the end of today, I should have most of the ship’s database entry done. By this time next week, I should also have a few paragraphs about the ship written for insertion into chapter 1. For now, you can read more about the design here!
Another significant addition to the website is a section of the (currently only UESPA) database dedicated to warp reactors. Since reactors are probably the single best way to signify technological development in starships, I decided it was time to put some attention there. Currently, information on the Cochrane-type fusion, Yoyodyne-type pulse fusion, and Cochrane II-series fusion reactors is present (which are written in chapter 1 and 2 to be the most prominent reactors in the mid-to-late 21st century). A Yoyodyne II-type pulse fusion reactor page will be done within the next few days to compliment the completion of the DY-732-class ship database entry next Thursday.
When I completed the draft to chapter 1 of the website’s History repot, I wrote the blog post “Rationalising and solving UESPA problems” to complement it and show some of the thought behind it. Today I have put up chapter 2, which mainly deals with the formation of the Earth Cargo Service (ECS) and reactor progress for the UESPA. I will not be writing a post that large on here for it. Just a brief.
So. The ECS was a major theme of two episodes of Star Trek: Enterprise (“Fortunate Son” and “Horizon”), where it is shown to be an agency responsible for governing the operations of Earth freighters. This chapter follows a similar sort of format to the first one, combining what we know canonically with my own creative approach of bringing it to life; explaining political, economic, and social reasons for the development of the ECS and contemporary ships.
I’ve also been experimenting with colours. I want the Red/Blue theme, but I want it to be easy on the eyes too.
The biggest addition is the first starship review, which is of USS Shenzhou from Star Trek: Discovery. All things considered, I gave it a weighting of 6.3/10. I should have the rest of the Federation background ships from the Battle of the Binary Stars done soon. Other than that, not much to report really.
Due to starting a new semester this week, I will now be confining my time for everything in a schedule. 6PM to 10PM on Thursdays is dedicated for this website, which gives me 3 and a half hours of actual work and 30 minutes to write an update on this blog. Since I have been busy trying to quickly get back into the routine of university life, I have not done much this week.
The only noticable change is the new home button image. It’s just a plain white version of the “UFP” text from the 23rd century Federation banner. The favicon has also been updated according (albeit black instead).
Chapter 1 is mostly complete at this stage, only requiring the addition of my UESPA-9 design. Ship information on Bonaventure is complete, and Friendship is almost complete. In preparation for Chapter 2, a DY-732 database entry will be worked on soon. Chapter 2 primarily focuses on the development of the Earth Cargo Service (hence the chapter title “Space Boomers”), but it will also include UESPA and civilian ships from roughly 2080 to 2110. Already there are database entries for some of these ships; Emmette (from the Star Trek: Enterprise title sequence), aforementioned DY-732, and Declaration (which includes Enterprise XCV-330). There will probably be more ships in the chapter as well, likely including some of the later DY series ships.
(I think it is safe to designate Thursday as the Starfleet’s Path to 2265 development update day.)
Since my last update: UESPA-9 design is taking a bit longer to complete. I am still on the detail phase, stuck trying to prevent the design from looking too advanced for its area. But that in itself inspired me to write this short essay today. The other notable update was the acquisition of the domain for the website.
Anyway, let’s get into this.
The United Earth Space Probe Agency (UESPA), the best-known agency for Earth’s pre-Starfleet exploration missions, has a few seemingly very advanced designs that The Powers that Be of Star Trek thought were fitting. I am by no way criticising the aesthetics of those designs as I personally like them, but they seem too advanced for being designed, constructed and launched only a few years after Zefram Cochrane’s warp flight and deadly conflicts like World War III. SS Valiant (canon mission designation, non-canon visual design) and SS Conestoga (fully canon design) are examples of two fully-functional deep space vessels launched way less than a decade after the Cochrane’s achievement. Whilst writing the first chapter of my website, this has presented a few challenges for me to overcome since I have to rationalise these canon or well-known non-canon designs, and then fill gaps with my own designs based on canon designs! One thing I should also point out is that only a few decades after these designs, civilians then had unprecedented access to space via things like the DY-500-class and the Earth Cargo Service.
There were two solutions I could chose in my mind to the problem. One, Earth had most of the technology mastered thanks to military advancement in spatial travel due to World War III. Two, first contact inspired humanity to race to the stars at an astonishing rate.
Based on how things turned out in World War I and II, the first solution can seem plausible since many innovations and/or wide-scale adoptions were made in those deadly conflicts that we take for granted, in most fields of science. Examples include things like tracked-based vehicle development, nuclear development, aviation advancement, and even the adoption of penicillin! There is one elephant in the corner though. Probably the biggest requirement for deep space travel is a solid, powerful reactor system. If nuclear fusion or even matter/antimatter technology was available in WWIII, surely the level of destruction granted from those immature (for mid-21st century humans) technologies would be far greater than 600 million dead and Earth’s majority recovery in only a decade or so?
Now considering the second solution, it is clear that it is more idealistic to think that all of humanity embraced a brighter future right on the spot in 5th April 2063. We are aware of a well-established post-atomic horror that lasted for a few decades, which resulted in some humans retaining the ‘old ways’ for a large period of time. However, this is Star Trek and I think large amounts of optimism is not out of reach. So I have developed the premise of my UESPA writing based on this solution. But, with a twist. The UESPA could have simply duplicated Cochrane’s reactor and nacelle designs (I’d like to think of Cochrane’s Warp reactor as a fusion reactor, instead of a matter/antimatter reactor) to begin with and scaled them up. We have done similar things in our history, even with spacecraft such as the Boeing X-37 (which is a 120% scaled derivative of the Boeing X-40). Early ships such as SS Valiant uses a system of multiple Cochrane reactor clones, and then most of the spaceframe technology is derived from earlier space programs. The only technologies that would be considerably different (or invented) from now to then is gravity generation, radiation shielding and weapons. Seeing as Star Trek seems to indicate that the Eastern countries were worse off, I have written than the strongest American, European or Eurasian countries spearheaded these advanced programs in an effort to rebuild Earth with whatever we could hope to find in space. Whilst the governments were exploring options, a guy from Montana launches an ex-nuclear missile with an advanced propulsion system that his isolated team developed. He gains the attention of the Vulcans, and the most stable governments of Earth realise that space IS the answer. After hearing from the Vulcans that there are indeed other sentient lifeforms in the universe as well, Earth establishes the UESPA and human ambition pushes us to the stars in only a few short years.
Now the specifics. I have written that the UESPA was founded after a popular uprising began to persuade the rebuilding governments that Earth’s future was in the stars. Which even from my perspective today, Earth’s position future in the stars might be a necessity – we will eventually need more living space, and new and unusual building materials or food products from some planet out there would be cool too. So in light of the WWIII disaster, I think it’s safe to assume a space-based economy using the resources from other planets is the logical solution. This rebuilding effort is definitely a gamble, but since Earth is unwilling to suffer more, humanity takes the bet. The UESPA designs the first explorers as large boxes with Cochrane’s engine designs to find these new worlds. Deep space probes with antimatter technology follow (but I have written that the lack of methods to properly mass-produce antimatter results in Earth being stuck with fusion for at least 6 or 7 decades) to seek out new life and civilisations to make friends with and trade with. Colony ships come not long after suitable planets for human expansion are discovered. To add balance, I have peppered in a few large accidents that indicate the immature state of this advanced technology (my UESPA-9 design is one of them – an ambitious but fatal design). The rest you’ll have to see on the website itself.
I have had other issues to resolve too, such as the timeline placement of the Bonaventure spacecraft seen in the background of a few Star Trek episodes – it’s clear it exists, but it was once attributed to the discovery of Warp! My website’s Articles section will eventually have pages detailing those minor decisions.
For today though, that’s enough (1,000+ words)! See you next week!
That’s the date my Star Trek-themed website will be fully launched and online. As that day approaches, I will be continuing to refine the website’s design and adding launch content. Today, I am currently working on my first original ship design for the website. But before we get into that, I think it is about time I brief what this website is all about.
“Starfleet’s Path to 2265” is as nerdy as it sounds. It is mainly a creative written piece on the subjective fictional history of starships belonging to Earth and Federation design. It’s based around the Star Trek’s prime universe and conforms to canon (mostly). My biggest intention is to fill in the blanks in the timeline between Star Trek: First Contact and Star Trek: Enterprise. Over a year ago, I wrote a small piece about SQL and PHP (In the deep end: MySQL & PHP) that demonstrated an older project called the “Federation Starship Database”. It is kind of like a continuation of that with a refined goal and scope. Pre-TOS and TOS ships are my favourite from Star Trek, and this website is dedicated towards them.
Now, the ship design.
This first of many starship designs I am creating is an early explorer of the United Earth Space Probe Agency, SS Voyager (UESPA-9). I have designed and written the ship to be an early ambitious failure – a complex deep space explorer design in a period of Earth’s history where it is still suffering from the effects of a World War. A recipe for disaster. The design is largely based on a successful canon design from the same period, SS Conestoga (which I have given the registry of UESPA-8).
In order to explain my process, I have briefly documented the design process here. The first thing I did was sketch up some small low detail forms for the ship based on a few well-known references from the same period (SS Valiant of 2065, SS Conestoga of 2067 and DY-500-class of 2076).
I found that the last form I did was the one I liked the most, as well as the most unique. So I took that form, refined the details, and did some basic annotations on the design.
I then roughly recreated the form on a CAD software (I use TechSoft’s 2D Design V2) so that the design would be confined to a proper scale. I then made a copy of the form and revised the layout of the ship to better suit the length and draft I specified in my annotated drawing (although my specified width of 20 metres will likely cause problems and I am now presuming the width to be around 50 to 60 metres to accommodate the “wing” span of the nacelle pylons).
Finally, I produced a colourised detail basic render of the ship as a current progress preview for this blog post.
I hope to have this design completed by the end of the week, and it will be included in my next week’s blog update for the website. Have a good day!
(This is actually a repost since I made an mistake before. Whoops.)
The last three days were about considering and mastering the search feature for Starfleet’s Path to 2265. I write this blog post whilst I ponder ways to made the search feature more powerful and intuitive.
As it currently stands, it is a basic search function. When a viewer submits a search query, and SQL query is searches a database and returns an array of results. An if statement checks to see if there are any results. If there aren’t results present, a ‘no results’ message is echoed. If there are results present, the code proceeds to a while loop that iterates until there are no more results to echo out.
In pseudocode, the operation needed to make a search currently looks like this:
Connect to MySQL Server
Select MySQL database
Create variable for the query string received from the search request
Create variable for the SQL SELECT query that searches for matches within two fields of a database table.
Create variable to store the raw results from the running the SELECT query, and handle possible MySQL errors
If number of raw results is more than zero:
While able to print out raw results:
Echo a tile containing the data for the result (includes a hyperlink, page name, category, description, and an optional image)
Echo a tile containing a ‘no results’ message
FYI, a “tile” is the CSS class name I use for the layout element that contains a result or message.
Following that procedure, you can generate results like this…
…from a search box like that:
I have clearly broken the statement I made on my last post about this project saying that I will not be doing any more serious non-styling code! But a search feature is something I should have had from the get-go. There are refinements that ideally need to be made before the website goes onto the internetz; a more advanced search algorithm that can intelligently display relevant results instead of echoing the results in the order they are stored in the database, a more space-efficient results page with filters, and compliant code for when I switch to PHP7 which also requires I use mysqli_* functions instead of just mysql_* or PHP Data Objects (PDO).
Now. Before I end this blog post, below is an example of an implementation of that pseudocode that should work with little modification. Starfleet’s Path to 2265 uses code that is very similar currently. It might be basic, but it works for now. I am more focused on other parts of the website. So if I run behind schedule, I at least have this to fall back on.
Example PHP code:
Example HTML code of a search box that works out of the box with that PHP code: