Question
App Platform not automatically getting the database schema changes.
- Posted on March 28, 2023
- DatabaseDigitalOcean App PlatformPostgreSQL
Asked by Osama Ehsan
The issue is that whenever I make changes in the database, such as adding a new column in any table, or anyother change that result in schema change, these changes are not immediately picked by the APP platform. but if I query the database using PGAdmin or view the content of the database using prisma studio these new columns are there.
For example; I recently created assignees column in the task table and if I view the table from prisma studio I can see that there is a assignees column . but the error that I’m getting in the Runtime logs of the lobster-app platform stats that there is no assignees column.
This has happened before too and I haven’t still got satisfactory answer to why that is happening. Sometimes it got fixed when it detach and reattach the database BUT that’s not a solution to the problem and as I’m using a “Dev Database” in the lobster-app there is no option to detach and reattach the database.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hollie's Hub for Good
Working on improving health and education, reducing inequality, and spurring economic growth? We’d like to help.
Hi there,
That is very interesting, what is the exact framework that you are using? Usually I would recommend avoiding making schema changes to your database manually, but using database migrations within your app itself.
It sounds like that your database changes are either not being committed, or somehow your app is caching the results hence not picking up the new changes.
I could suggest two things:
Feel free to share more details on the framework or the CMS that you are using so I could advise you furhter!
Best,
Bobby