by Yahwho | Feb 2, 2022 | SQL
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...
by Yahwho | Jan 30, 2022 | SQL
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...
by Yahwho | Nov 30, 2021 | Java, SQL
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...
by Yahwho | Dec 19, 2020 | SQL
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...
by Yahwho | Nov 21, 2020 | SQL
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...
by Yahwho | Oct 27, 2020 | SQL
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...