ProjectDocs PersonalWebsiteDocs
<< ---------------------------------------------------------------- >>
--- Last Modified: $= dv.current().file.mtime
DataBase
<< ---------------------------------------------------------------- >>
Needed Fields:
each project:
- Name
- Description
- Picture URL
- Tags
- Github Link
- Deployment Link
- Design Link
Tables:
- one for tags to load in the left bar for sorting(one to one)
- one for status to load in the
- one for detailed project details. (one to one)
- one relational for what tags each project has (many to many)
Triggers:
- one for when inserting a new project-tag relationship make sure if one of its tags doesn’t exist in the tag table you add it
Needed Features:
- needs to be sortable by tags, loads the first 10, then after hitting next page, loads the rest on the same page.
- Searchable by name, description, and tags
- thats pretty much it
Pretty sure the whole thing has to run in a docker container DB Setup
Migrating to RDS was a bit of a pain bc of the triggers, had to change a bunch of settings and sql specific user defentions https://stackoverflow.com/questions/9446783/remove-definer-clause-from-mysql-dumps