Delete a Foreign Key if exists

I’m currently developing a new database, requiring the initialisation code to be run over and over again. Creating tables with IF EXISTS is easy. Delete a foreign key if one had been created already was a little more problematic. set @var=if((SELECT true FROM...

Todays MySQL Timestamp Learnings

Today I have decided to take a look at the redesign of the Medieval Realms database. This is the first production database I’ve ever written. It’s ugly. It’s not really relational. And it’s bloated to 34 tables. This database has grown...

Pixel Art Applications

Just a (minimal) list of applications I’ve found so far for Pixel Art. Placed into two basic categories, commercial and free. Apps that are too expensive for pixel art (like photoshop) or lack descent animation functionality (like Gimp) have been left out....

My First Pixel Art

I love old computer game, games like Simon The Sorcerer and Cannon Fodder. The artwork – to me – is inspiring, beautiful, and very nostalgic. So as part of my quest to build my very own computer game, I thought I would give pixel art a go. I reckon it will...

RigidBody and RigidBody2D Script Initialisation

So yeah. Two different ways. Not sure why one is better than the other. Yet. Method 1. Attach RigidBody2D to the Game Object and then create a local private variable in the script. This approach feels better imo, so that is what I’m using. RigidBody2d rb2d;...