February 8th, 2024 – What is your favorite technology from your project and why? What is it used for? How could it be made better?
My favorite technology is our use of databases using SQlite and SQL with Python. This week I have been focusing on setting up the database to store information for our web app and it has been my favorite part of the project to work on so far. Databases make it easy to store common information in one place that can easily be accessed by all the different parts of our program. Using databases reduces the time we have to spend managing data and SQL queries allow us to access that data easily and in various useful ways. It also provides greater security and privacy for user data and removes data redundancy. Implementing this technology into our project will make it a lot easier to work on our separate parts without having to worry about how we will all access the data.
One way this technology could be made better is by making writing SQL queries easier. Some of the queries can be long and someone confusing to write especially for someone who doesn’t have a lot of experience with it. The syntax can be a little confusing and I would recommend researching and practicing before attempting to implement a database. Another potential risk of a database is if the database fails so does your whole program since it is a centralized data storage. If it goes down all parts of our program will lose access to the data and cause issues. But this is pretty unlikely and can be avoided if we make sure that we set up our database correctly early. I have been creating a number of functions to make querying data from the database easier for all of us using the CRUD operations. This is a Create, Read, Update, and Delete function for each of our tables so all of the data will be easy to access and manipulate. The Database has been really fun to implement so far and I am excited to see how we will use it to handle different tasks for our web app.
Leave a Reply