This gist details the decisions I made, the tests I conducted, the observations recorded, and the directions I took while building out an API for Project Greenfield.
Last active
February 29, 2024 01:46
-
-
Save trentgoing/3a0b8ac55c0f77fd73299823f75da4b9 to your computer and use it in GitHub Desktop.
SDC Engineering Journal
Today was the first day of the project. I spent the morning reviewing expectations and diving into my work...
Given the challenge of rebuilding the API for the project, I started by identifying what data needed to be stored. From there, I worked to design how this could fit within my RDBMS.
I designed a schema with 6 tables to hold the needed data. The schema I decided on ended up being this:
It was interesting to note the number of different ways I could design my schema for the same data set. Ultimately my decision to go with _ was based on _.
I recieved the data for the application. It was very unlike my initial schema design.
In order to insert the application data, I needed to transform it into my expected format. In order to do so...
I have a fantastic database that now contains ALL of my application's data!!!
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment