Skip to content

A8: MySQL

SQLite3 to MySQL Conversion
Week 8 Assignment – Due 3/5/2024 – Beginning of Class
50 points

Overview:
Assignment 8 involves a significant step in database management for your web application: transitioning from SQLite3 to MySQL. MySQL, a more robust and scalable database management system, is well-suited for web applications. This assignment focuses on converting your existing SQLite3 database to a MySQL database, ensuring that your Flask application can interact seamlessly with this new database system. The transition to MySQL will enhance your application’s capability to handle larger datasets and more complex queries, which is essential for real-world web applications.

Objectives:
  • Learn and implement the process of migrating a database from SQLite3 to MySQL.
  • Adapt your Flask application to connect and interact with the MySQL database.
  • Understand the differences in database management between SQLite3 and MySQL, particularly in the context of web applications.

Deliverables:
  1. MySQL Database Implementation
    • Description: Convert your existing SQLite3 database schema and data to a MySQL database. This involves creating the necessary tables, relationships, and importing existing data into MySQL.
    • Requirements: The MySQL database should accurately reflect the schema of the original SQLite3 database, with data integrity maintained.
  2. Updated Flask Application
    • Description: Modify your Flask application to connect to the MySQL database instead of SQLite3. Ensure that all database interactions (queries, updates, etc.) are adapted to work with MySQL.
    • Requirements: The application should function as expected, with all database operations correctly implemented for MySQL. The code should be well-organized and free from bugs.

Submission Guidelines:
  • Submit the updated source code for the Flask application, including any new configuration files for MySQL.
  • Ensure all submissions are clearly labeled and organized.

Evaluation Criteria (50 points):
  • Successful migration of the database from SQLite3 to MySQL, with data integrity maintained.
  • Effective adaptation of the Flask application to interact with the MySQL database.