Introduction
When monitoring application logs or database activity in Mendix offline-first applications, DROP TABLE SQL statements appear in application logs or database activity during page refreshes or full synchronization events. This can raise concerns about potential data loss or unintended database modifications. This knowledge base article clarifies that this behavior is by design and part of the normal synchronization process.
Environment
Studio Pro (all versions)
Details
When a full synchronization is triggered in a Mendix offline-first application:
- Full synchronization drops the local database tables using a
DROP TABLEstatement. - The synchronization process immediately recreates the tables with the current schema.
- The process repopulates the tables with the latest data from the server.
This cycle ensures that the local offline database is completely synchronized with the server database, maintaining data consistency and schema integrity.
DROP TABLE statements may be observed when:
- A full synchronization is triggered
- The application performs a page refresh that initiates a full sync
- The offline database requires a rebuild
This DROP TABLE behavior observed during full synchronization in Mendix offline-first applications is expected and by design. It is not a defect or error, and it does not result in data loss. The local browser database is immediately recreated and repopulated with current data from the server as part of the synchronization process.
Internal information related
Not applicable
Additional information
Mendix documentation:
0 Comments