Switch to better-sqlite3 #728
Description
What would you like?
Switch sqlite3 to better-sqlite3
Why is this needed?
Large improvements in performance for local development.
How could it be implemented?
Change the npm package and drivers to better-sqlite. Make sure to also update the workflows.
Other information
This was attempted in #726, however the switch wasn't plug and play. The issues seem to be with how the schema from typeorm decorators is transformed into sql, having small differences between sqlite3 and better-sqlite3.
This could be because better-sqlite3 is stricter. To fix this, we should switch (as done in #726 and slowly work our way to the error.)