Database Cleanup Part II

After spending a lot of time on this I failed. Well, I failed to do this how I wanted to. I wanted to create a loop of sort – set it off once, walk away and come back to an empty table. I tried numerous times. I’m not going to list all the code examples...

Database Cleanup

Work’s been busy, so I’m only just starting to get some time to continue writing my plugin – Medieval Realms for Rising World. Continuing on from my bulk INSERT code I was testing – which works fantastically. Although at the time of writing...

MySQL Performance Tests

I’m continuing to work on my Medieval Realms project and one of the obstacles I’m faced with at the moment is the storage and retrieval of large amounts of data. My initial test application which consists of approximately 410,000 data sets using a single...

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...

Databases, databases, databases

No tech updates since October the 16th huh? Well, I realised that my SQL skills were somewhat limited to some basic stuff I still remembered from Uni days (when beer and having fun was more important than learning about RDBMS’). I know enough to get by, but...