Database Setup In Part 6 we created an Entity Relationship Diagram for our database, including a junction table to link the ‘keyword’ table to the ‘photo’ table. Now it is time to set up the database so we will be able to use it when we begin the coding. The first thing we want to … Read more
Database Design So far we have designed two tables, created the relationship between them, and designed an ERD (Entity Relationship Diagram). Let’s look at that again: I mentioned that we would be looking into the ‘keywords’ column. So what problem do we have here? In its current design we could have a photo with multiple … Read more
Database Design Previously we created our tables and I said we would look at a graphical representation – also called an Entity Relationship Diagram (ERD) – which will help us visualise the lists for our table columns. This is extremely helpful because it can show if a relationship (the connection between tables) has any errors. … Read more
Database Design I previously talked about creating lists for what we require for our site and how messy our initial lists were. Before I get into improving these, I would recommend reading the link below. It covers database normalisation which is a method to organise your databases – making them simpler to use, improving the … Read more
What it does… Rainmeter uses very few resources to run which makes it a very popular customisation program for your desktop. However it can still affect gameplay by causing stuttering – especially if you have a lot of skins running. Instead of exiting the program to play your game and starting it again after, Rainmeter … Read more
Creating Lists In the previous article I described the website idea from the point of the user – what they will be able to do on the site. Now we need to work out what we need from a developer’s point of view. I will get the idea, pull out individual parts, and create a … Read more