Converting our application to a SQL backend will be no small task. The application was built around the assumption of the CSV files, and although we've taken care to separate our concerns, many things are going to need to change.
Let's break down the steps we'll need to take:
- We'll need to write a SQL model
- Our Application class will need to use the SQL model
- The record form will need to be reordered to prioritize our keys, use the new lookups, and autopopulate using the database
- The record list will need to be adjusted to work with the new data model and primary keys
Along the way, we'll need to fix other bugs or implement some new UI elements as needed. Let's get started!