ChrisRichardMiles / ledger

0 stars 0 forks source link

Make the api work with a postgresql database and the frontend, both running in containers #6

Open ChrisRichardMiles opened 5 months ago

ChrisRichardMiles commented 5 months ago

I thought I could do this easily in the beginning but it proved very hard for me. I don't if it was permissions or a bug I didn't see but the api seemed to not be able to access the table, getting "table doesn't exist type errors". This was with running a postgresql database in a postgresql container. It also seemed hard even outside a container. It was eating up so much time I had to switch to sqlite, which made everything go much smoother.

ChrisRichardMiles commented 5 months ago

I couldn't do this with the postgresql database running in a docker container. Couldn't fix the issue of sqlalchemy not finding the table. I was able to do this with an sqlite database, the frontend in a container and the fastapi api not in a container. This will have to do for now.