SQLite, saved as float instead of int on electron

[George]

As explained here check what is generated in your connection.js

Wappler does not migrate SQLite database

What kind of alter are you missing because it all looks good to me. Here is what happens in the background: The SQLite database file you create in Wappler with its Knex migration is a dev only database. In the runtime in electron or a mobile app based on capacitor, when the app is started for first time, a local user SQLite database file is created specially for this user. To create it, and later on update its schema runtime, special sql migration statements are used that are stored in the …