Apple
January 18, 2023, 8:31pm
1
Database manager: Automatically refresh schema from database
The schema shown on database manager might not be in sync with the actual database, causing users to create incorrect migrations (changes)
I highly recommend for the database manager to refresh the schema proactively
This is an evolution of my previous feature request:
The refresh button in the database manager may cause confusion for beginners, as it doesn’t refresh the schema:
[Screenshot]
To refresh the schema, the following button must be used instead:
[Screenshot]
Here’s a bug report I found:
Latest incident:
Hi Wapplers all the way from Sydney Australia,
Im having a problem which is driving me nuts. As I opened my project I received the followin error when I clicked on one of my database tables to view the contents:
[Screen Shot 2023-01-18 at 10.17.09 pm]
Its basically telling me no tables or users exist when in fact they do. Any idea how to resolve this? I tried restarting services and closing wappler and reopening. My stack is as follows:
NodeJS,Postgress, Docker
It’s worth noting I had do…
George
January 18, 2023, 9:26pm
2
Well ideally we really would like to do this but fetching the full database schema is a very heavy operation which can take minutes depending on the number of tables.
That is why we do refresh on demand only per table to have it retrieved in the fastest way.
There is also no way to know in front which tables has been changed.
So I’m afraid we already have the most optimal way.
Apple
January 18, 2023, 11:26pm
3
Ok, what about we show a warning to the user if he/she attempts to edit database schema while there are pending changes (migrations) to be run? That should stop users from mistakenly messing their migrations
Incident:
Okay I know what cause this problem, and I think it’s a huge bug. Here is what I am doing to replicate this issue:
On macbook 1:
I rebuilt the table objects again. No errors popping up. I commit and push the update to github.
On macbook 2:
I clone this project, and as soon as I open up the tables, the same error pops up on this device. I refresh the schema and all the tables disappeared.
So the problem is pulling and pushing from github- the tables are not synching.
Unless I a not doing th…
This might be slightly different or maybe what you’re asking, but I don’t understand why the edits/additions to the database aren’t auto applied.
Why do I need to “Apply Database Changes”?