Local SQLite

You should go with this option if you are making changes to the database on the fly. This will only migrate the changes in your current SQLite environment. This should specifically be used if you are constantly iterating on the API.

Install sqlite3

If you didn't install sqlite3 during your initial npm install, run the following command:

npm install sqlite3 --save

SQLite is essentially just a store in your tmp directory, so it doesn't need anything special for database-related functions. It makes it easy to get up and running on your computer easily.