07: Access a SQLite3 Database

You'll now learn the basics of a project named knex.js to access a SQLite3. You'll need to create a database for the next exercise that stores TODO lists, so you might want to check out the next exercise to get an idea of where this database is going.

Step 1: Migrations

To do this you'll first need to learn how to create a migration that creates your database. The documentation for migrations is in the knex.js migrations documentation. You're specifically looking at how to use createTable and dropTable in a migration.

Your TODO list table should have the following fields:

Learn JavaScript Today

Register today for the Beginner Basics course and get the new releases by just paying the difference. There's also special discounts for existing customers when new courses are released.


Still Not Sure? Check out more curriculum!