Completed SQL Quests
Indexing in MySQL
I have been working a lot with JavaFX recently and it's been a while since doing any SQL work. After loading my project and running a few...
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...
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...
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...
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...
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...
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...
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 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...
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...