Any Possible way to migrate on db user version base ?

[HimeshAsite512]

Any Possible way to migrate on db user version base ?

There is a scenario db file have few columns available in data structure and when migration file executes again it throughs error and the query which is written below that line will not getting executed.

can any one help out in it ?

[beenotung]

My workaround to avoid the migration to be ran partially is to run it inside transaction.

For example:

db.transaction(()=>{
  // run the migration here
})()

A working example: https://github.com/beenotung/better-sqlite3-schema/blob/f30b6ffe5140380005fbeca764cc1697db55fb3c/src/migrate.ts#L45