Question

.So I have a project, I just want a general answer on how would you start it. I have to make the Backend read/write from the database. What does that mean and how you u do that general example, please. in php please

EX - would i just make a script that just connects to the database , or is it more to it

Answer 1

The important thing you should always keep in mind while writing the back end scripts is the security, As a back end developer all your constumers trust you on their privacy.

So, always validate each and every request before taking action such as read and write to databases.

• You should avoid sql injections,
• Try to avoid using default user names and passwords instead have a strong password that is dificult to crack.
• Never let the database connection open after you done working with it,
• you should always backup logs so that way it it easy for you to detect the root cause for crash and can recover easily.
• You should build outlier detector if you are dealing with the sensitive data.
• Always strore the user sensitive data such as passwords,credit card number bank details in encrypted form.
• For better performance cache the most requested data from the database that is less dynamic for speed response.

Finally read implies taking data from the database using queries and transmitting to user using back end script, in similar manner write implies taking data from user and pushing it into database.