How to manually add indexes in SQLite with knex?

Wappler General Need Help
9

I don't know exactly how Wappler processes, but Jon's steps were the only way I was able to get it to work.

  1. Make some database change in Database Manager to create a migration file and add a record in wappler_migrations table.
  2. Go to the Change section and "Undo this Change"
    image
  3. Open the migration file that was created and change the code to whatever custom code needed and save the file.
  4. Go back to the change and click "Appy this Change" (that option is not currently showing in the menu since I've already reapplied the change)
    image

It's only after following these steps that the custom code (e.g. creating indexes) gets applied to the database.

1 Like