Using SQLite

I’ve noticed that using SQLite was mentioned before in relation to NodeJS etc. I know little about Docker, or NodeJS, but when I have used Docker (locally), I’ve used it with MySQL which suits me best as I’m familiar with it and can use Navicat etc.

Is there a particular advantage in using SQLite in this context, or is it just used as an example, as a simple way to get started? Also, can SQLite be used locally while the project was deployed using MySQL (for example), without compatibility issues? I imagine there could be some issues with custom queries for example.