Store Procedures

I decided that I would be best that I use store procedure to better allow me to manage my database without putting to much strange on my front end, with will likely already be slightly bloated with all of the strange files that come preinstalled with react-boiler plate.

I discused this with Dr Todd after my last date class for the week. He gave me a few way about going though some of my procedures such as login which I orgionally had as three procedure which all passed data back and forth.

He surgested that I use case statement and declar local varable after writing some sudo code and looking at some of the resouces he provided I think I have got more funtional better scaling qurries.

While I’m at I I should plan out some of the strange usecases which I probably should have but keep any way. There exist a user table which sercvers to connect all types of users. I should use a transaction to avoid messy parsally commit updates and inserts.

Currently I need to look into hashing and how to applie it I think somesort of hashing middle ware wuld be good i

Giving up on redux

I have broken and restarted my redux about three times now. This last time I started looking into redux tool kit.

Tool kit is everythink redux is without its problems.

Tool kit work by wrapping the statandard pieces of redux in other funtions with automaticallu fillout need things.

My main problem with redux is that for a single piece of redux I need to create an unnecisery web of data. React-boiler-plate how information on uninstalling redux and it extention. I haven’y looked into this because I don’t want having to reset my conatiners again to set me back.

The main reason I like tool kit is the funtion such as splices will automatically fill out what is needed for a full action, reduxer, store root.

What I mena by this is I use to have to a constation for action, an action to hand cases and payloads and a reducer to commicate with my store. I would then also have to add dispatcher and map my comands to props. This lead to an extremely clutter and hard to navigate file and code struture.

Where for example with tool kit splice the action I have been admititedly over using, lets me declar most of the thing that would be need for an action chain, inside of the funtion, this includes cases and recucer.

The other part I like about tool kit is that it remove a lot the the trerible js syntx. I have a dislike for it not because of the langagues it’s self just that with reducer I have always personally felt that it was visable that this was not the langages oriogional purpose.

I have been carefully remove all of my unneed files to try and simlplie down my redux. I feel off about it because it honestly just because I’m struggling to keep up as each container has about 4 pieces of middleware which Ijust don’t understand.

with redux tool kit the two middleware I like are included, immer which allows immutible states to be correctly edited though the proper means and another middleware which I forget the name off nut is design for managing states with a browser pluggin.

The one thing I need to keep in mind is unlike standard redux which provides the user with many different options for doing simple task redux has a stronger tendance to enforce it rules. I probably will not notice as a lot of my middleware seems to already enforce ‘best practices’;

Hosting

Currently I mesing with hosting. I been doing some strange use cases of ftp piplines. How its meant to work is linting hook > commit > build > test > ftp post. I spent a long time deletiing my local runners with were briking my files. Currently I have very fragile working pipline. It’s fraglile in the fact that I wont suceed if it detects any missing commits I understand this is for safty because you don’t want to commit a broken website. The problem is that it makes it hard to work with other branch when I waiting for the commit. I was having another issue with the files not sticking, I have a theory about why. I feel like I spent enought time on this so I think I going to leave it at that. I do feel like I can talk about my pipline in my report as I think I done about 6 to 12 on this and it is very simlar to other thing and I defently made a mistake focusing to much on this.

I purchase I correct hosting. The hosting package I purchase doesn’t havr ssh or root access and I don’t have access to termial. This seemed fine as it has a lot of really good features but after playing around with it I realised I could work effiecently with express as running node packages is not doable in a useful way if I don’t have terimal + I have crated an unstoppable demon of nodemon who just can not be turned off turns out directly ignoring flassing warning message has concequences.

My web host want me to validate my second purchase by EMAILING them my mastercard this , is , not , gonna , happen. I’ve email them and opened a surport ticket, We will see where this gets me.

Currently I plain on abandoning my hosting plain I feel I have got enought to write about it and have been side track on work with is taking my project sideways instead of forward. I understand that a large amount of my grade is in the report but I would like to get my site finished. Not intirely but to a working and compete degree. Currently that is just achievable if I stop getting sife tracke

RES701 Journal 7 28/5/20

Feedback on Jonathan Macgregor’s Research Proposial.

Short Description.

Very broad topic area that can likely be specialised later. The Choosen area of interest seems to be one with may possibities that could be explored.

Things You Know.

The questions here seem to be from a point of veiw. This is a bad thing as it creates persective basied of what the you considures to be ‘fact’. As they are presective based I give the you the ability to further exspand on these points. Some additional information could be useful for use in justification of your project. For example ‘It can be challenging but rewarding’ could be use as a comparision between average grose earnings and time require for a project.

Things You Believe.

These all seem like resonable things to believe. Some of these could be used as possible questions. For example, I believe that it is doable, but it will take a lot of time and effort could be used as a question of ‘What is time need to make a certain sized project.

Things you don’t know

These are simlar to the things I have surgested in the previous areas. You could possible look into these to create your research question.

Possible Questions.

A lot of these seem to relate to what would make a video game ‘fun’. This could be a possible focus. I would surgest rewording them to be about sucessful. This is because sucess may be a easier meteric to messure rater than fun, which is subjective. It realy depends on what sort of apporch you want to take. If you wanted the research to be more people based, fun could be messured by having people play the game. Where if you wanted to be more staticic based success would be easier to messure.

Selected Questions

I like the selection of questions. I might surgest extending ‘What makes a good video game’ to be more spicific.

Chosen question.

I think this is a good start but might need to be a little more focused. What about selecting game engines are you interested in? You could connect it to previous question. What is the best devlopment engine for beginners? How does the enginee effectt the success of the game?

Title.

I think you need a more indepth title.

Ethical issues and IP.

I like what you have here. I would surgest looking into copy right issues. You game will need assests such as graphics sounds and music. You might want to think about how you are going to acquire these.

You might want to dicusse the terms of the delopment plateform such as revenue limits and licencing.

13/8/19 PFW601

This lesson I showed Sharon my manual.

Sharon feed back: There needs to be less space between the titles of the work. The subtitle on the manual cover page could be shorter. There is to much focus on the parts of the manual which explain the game and not enough on the steps which are meant to be the main focus of the manual. I need to put more pictures to make the steps easier to follow. I need to make my list more consistent by removing full-stops. I could also use bold headings and shading to make the command table stand out more. My image captions need to include the word ‘figures’ within their captions.

This is a lot of feedback and some of it contradicts some of the other feedback I have gotten. I have implemented the easy parts of this feedback such as shortening the title, removing full stops, altering captions and table formatting. For the conflict I have chosen to reduce the spaces between titles as I am already struggling to fit thing into the space I have available.

To make my manual focus more on the steps I will need to follow the other recommendation of adding more pictures this means I have to remove a large of the already writing manual.

8/8/19 PFW601

This week I noticed that my line spacing reset back to the default again. I realized that the line spacing was incorrect after I had finished laying out the manual.

In the future I need to be more careful about this, as it caused me to delete part of the manual, as it was no longer within the page limit.

Once my manual was reformatted, I showed it to a few people just to see what their first impressions were. They all said my manual looked good.

6/8/19 PFW601

This week we peer reviewed each other’s manuals and I got useful feedback from the people who reviewed my work.

Person One Aline: This person pointed out that my writing had many spelling and grammar mistakes in it. I will need to fix these before I publish my work. One of the items of feedback I got was to do with my text placement. I had placed the part of my work which explains traits after the part of my work which shows the user how to create a character. In order to create a character, the player must understand traits. I have moved the trait section to the appropriate place. Following future feedback, I decided to add more space after my images.

Person Two Gigs: This person said my manual looked good and was ‘in-depth’. This is a good sign that my manual is on the right track. If I were to try and extrapolate some criticism from this, it would be that I have too much information and might need to reduce the amount of text used in my manual.

Person Three Asriel: This person suggested that I change and add more titles, to allow people to easily refer back to important areas of the manual. I have altered the third title type to allow for more titles to be added to the hierarchy. In the future I will not use the same colour that I have used for my current manual, as it was hard to find a shade of this colour that allows the reader to see the difference in the title hierarchy.

Class 25

Based on the 17/6/19 Dat 602 class.

Even though it’s possible to connect a database directly with the program. This is not recommended because I can create additional connect and compleicate the code. Other programer might find it hard to understand our coded if we use this method.

For our project we will use data bindings. Any object using Ilists in .net will be able to use databinding. Only one datasource for binding object.

We will create our own connections as .Net is not completely compatible with mySQL.

We need to create our own list from our datasource as they wont bind properly, as the datasource doesn’t return the correct information.

We must clear a datasousre before we call it.

Class 17

Basie on the dat602 5/06/19 class.

Read umcommited means that if a query is reading data while another querry is changing the data, this allows us to avoid blocking.

Read commited allows the proceess to be blocked if another funtion is editing it.

Repeated read reads a funtion from when the select statement is run regardless of what the program is doing.

Selrialable means that the everything including select statement will corse the data they are working with to become locked.

In an uncommit means that we are seeing the data even though they are not commited yet so if they user doesn;t commit it the data we have read will be wrong.

Seliablizable will effect performances.

Recommended to talk about Issolation levels when we talk about ACID in our report.

Class 16?

Based on the 4/6/19 dat602 class.

Transnational sql is where any changes we make to our database will not be save until we commit the change. We started by turning auto commit of in sql.

We can use start translation to declare a part of code in which we can roll back if we wish.

Rollback can be used to undo any changes we make.

Transnational handlers can handle mistakes within sql. If the query finds an error then the program can use roll back to return to the position before changes began.

Roll back will return the database to the position before the translation happened this. THis include everything in the translation which is relevant if an error is the coarse of the rollback. If part of a translation is run and the next part coarse an error the first part is also returned to it’s original state.

Operational information is keeped out side of the database in it’s own scheme.

Atomicity is where the database will only do one thing at a tie where isolation is where the database tries to switch who is doing anyone thing at any time.