Run tests on MYSQL or SQLITE?

Question

MySQL

Hello everyone =)
Nodejs. MySQL (+ Sequelize ORM). Tests.
We run tests on sqlite:inmemory (speed is class!). However, there is a difference in code behavior between mysql and sqlite.
What to do?

running tests
Development: sqlite
On staging and production servers: mysql
Is this correct?
Thank you! =)

Answer 1

It strongly depends on whether you got into raw sql and whether you use the specific features of this "subd"
In the general case, there will be no differences

It is right?

yes, that's right
Over time, start writing load and volume tests that will run on staging