'Better sql lite gives error for the code written in migration file

Better sql lite gives error and stops executing further code written in .sql file for the migration. due to which we might have to perform\write manual code.

For Example

  1. you have table x in db file.
  2. you add column through migration .sql file which is not available in table x.
  3. run exe, column gets added.
  4. closing the exe
  5. run exe again

Now you will find error for the column already exists and stop execution further for .sql content.

I found some issues like it also not supports 'IF NOT EXIST' etc. may I know the reason as I'm not much familiar with the Database things.

here is which I have used for the database and it's helper packages manager.

https://www.npmjs.com/package/better-sqlite3 https://www.npmjs.com/package/better-sqlite3-helper

Thank you for helping hand in advance.

sqlelectronnode-sqlite3better-sqlite3better-sqlite3-helper


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions