4. Database connection

Let's create the database connection in a separate file:

// Contents of database.js

import knex from "knex";

const dbFile = "PATH_TO_YOUR_SQLITE_DB";

const knexInstance = knex({
  client: "sqlite3",
  connection: {
    filename: dbFile,
  },
});

export default knexInstance;

For Express to handle JSON requests, we need to add app.use(express.json()) to app.js:

// Contents of app.js

import express from "express";
const app = express();
const port = process.env.PORT || 3000;

app.use(express.json());

app.get("/", (req, res) => {
  res.send("Hello Class!");
});

// Rest of the file...

Test the app

Run the main app. Can you access the database from your endpoint? To make sure, add a simple knex request in the endpoint.

End file structure

At this point verify that your project structure looks like this:

• api

  • snippets.js

• app.js

• database.js

• package.json