When dealing with databases it wouldn’t be uncommon to have a website that stores users email address in the database. You can imagine that some companies have a massive collection of emails so it is important you know how to catch an email that is trying to be used again by a new user, even though the email is already being used by a current user. One way to catch this is when the PUT request to create a new user goes through and it catches that the email is already in use, simply return an error code 409. This means that there is a conflict and you can alert the user that the email or username that they are trying to use, are already taken up by another member!
If you’re in the website making business it is common knowledge that your site will be accessed on an array of devices. So when using images you have to consider that somebody is going to be viewing your site on a 50 inch monitor, or a 5 inch phone. With that in mind you have to be mindful of when using images. One common way to deal with this is to have your stylesheet have media queries that get the screen size from the device. You can then have different sizes for the same image and the correct one will get loaded up depending on the return from the media query.
When dealing with dependencies it is not uncommon to end up with hundreds or even thousands of them. One way to make sure that they are safe and secure is to always keep everything updated. This is a nice way to ensure that all the bugs are taken care of.
Here recently the class and I have begun working in mySQLworkbench. So far I have enjoyed it, and even gives me a sense of feeling that I work in an office somewhere sorting out users information. Two SQL datatypes are CHAR, and VARCHAR. A difference between the two is that CHAR is a fixed length and VARCHAR has a variable length field. This means that the storage requirements are different.