Hello world ūüėĀ. Welcome to my Quest Log of Computer Science enlightenment. Here you will find such learnings as the LAMP Stack (Linux,¬†Apache, MySQL, PHP/Perl/Python). My long standing quest companion Java, padawan C# and his partner in crime; Unity. Who knows what other beasts we might meet along the way. Onwards!

Completed Quests

Vectors, Dot Product, and Cross Product

Being as thought Vectors are critical to both 2D and 3D game design (like you need to know this stuff) it looks like I need to understand them, backwards! A Vector is a line drawn between two points in 2D or 3D space which also has a length, known as its magnitude. A...

read more

RDBMS’

So I decided to slam the brakes on MySQL and do some research into RDBMS before I got too involved again. The next biggest RDBMS next to MySQL that I know of is PostgreSQL. So I thought I would take a peek at the data and see what other people are using (and therefore...

read more

MySQL Workbench Database Design

So I'm designing a database in MySQL Workbench for the first time. Previously they've all been on scraps of paper. Designing a database in MySQL has a lot of benefits. The biggest of which is the ability to populate it with data and test it as you go, not only for...

read more

Medieval Realms and BufferedImage

I've not posted any Unity build stuff recently (in fact since April 24th). I've been working away on an update for my plugin called Medieval Realms for the game Rising World. The update uses an API feature that takes screenshots of the users screen returning a...

read more

Back to Basics – MySQL

So it's been a few years now since I created a database in MySQL (version 6 in fact). I installed the latest version MySQL - version 8 for my new project. A little different from before as you now need need to add a preceding sql to the command. Looks like the shell...

read more

Concatenating Strings Best Practice

So I've always done it with the plus (+) operator turns out using a prefix $ is much more efficient in terms of memory usage. //less efficient string newString = firstString + " said hello"; //more efficient string newString = $"{firstString} said hello"; Also, don't...

read more

Public Variable vs Public Property

Remember to always use a public property over a public variable. Public variables such as below are potentially dangerous; //bad practice public float myFloat = 0.1f; Instead use; //public variable - the best solution public float myFloat { get; set; } Why use a...

read more

Player Input

public class ButtonInput : MonoBehaviour { void Update () {  bool down = Input.GetKeyDown(KeyCode.Space);         bool held = Input.GetKey(KeyCode.Space);         bool up = Input.GetKeyUp(KeyCode.Space); if(down) { } else if(held) { } else if(up) { } else { } } }...

read more

Lerp Lerp Lerp

Linear interpolation known as Lerp. Why it's called Lerp I do not know! Is it L for "Linear" with an erp for 'ERPolation? Who knows. Take three inputs. A start value, and end value, and a percentage value between the start and the end. // In this case, result = 4...

read more

Cubes Version 1.0

58 lines of C# code to create 5000 "magic" cubes. I've been learning a lot over the last three weeks about terrain generation and manipulation of terrain data. So I thought it was about time to actually cover the basics!   Cube Controller using UnityEngine;...

read more

Splat Prototypes is Obsolete

So it looks as though after learning all about SplatPrototype's in Unity it turns out that the SplatPrototype is now depreciated!       The (old) method I (just) learned using Unity 2018 goes something like: SplatPrototype[] newSplatPrototypes;...

read more