GrapesGoober / des424-g11-todo-cards

0 stars 0 forks source link

Setup Cloud Database Solution #5

Open GrapesGoober opened 1 week ago

GrapesGoober commented 1 week ago

Problem

Right now we're using Sqlite3 for development. However, we need to keep an open minded, and find better database services, containers, or whatever. Need to come up with a solution.
This is related to #4 but specific to setting up a server, networking, and finding general solutions for this.

GrapesGoober commented 2 days ago

Update

I got the fastapi container to run and connect to mysql container. It works! This is a good solution for now, but I only have test scripts to show for it. Still need to incorporate this into codebase.

GrapesGoober commented 21 hours ago

Update

@6422781441 I've found a way to auto-run sql script as part of mysql container initialization. Here's the compose.yaml code. Add this new host bind to the volume.

volumes:
  - ...
  - ./init.sql:/docker-entrypoint-initdb.d/init.sql