Next Fullstack Configuration

.env.local

DB_CLIENT=mysql
DB_PORT=3306
DB_HOST=127.0.0.1
DB_NAME=nextfullstack
DB_USER=
DB_PASS=

BASE_URL=http://localhost:3000/

database\db.js

const db = require('knex')({
  client: process.env.DB_CLIENT,
  connection: {
    host: process.env.DB_HOST,
    port: process.env.DB_PORT,
    user: process.env.DB_USER,
    password: process.env.DB_PASS,
    database: process.env.DB_NAME,
  },
});

export default db;

knexfile.js

const dotenv = require('dotenv');
dotenv.config({ path: '.env.local'});

module.exports = {
  development: {
    client: process.env.DB_CLIENT,
    connection: {
      host: process.env.DB_HOST,
      port: process.env.DB_PORT,
      user: process.env.DB_USER,
      password: process.env.DB_PASS,
      database: process.env.DB_NAME,
    },
    migrations: {
      directory: './database/migrations'
    },
    seeds: {
      directory: './database/seeds'
    }
  },

  staging: {
    client: process.env.DB_CLIENT,
    connection: {
      host: process.env.DB_HOST,
      port: process.env.DB_PORT,
      user: process.env.DB_USER,
      password: process.env.DB_PASS,
      database: process.env.DB_NAME,
    },
    pool: {
      min: 2,
      max: 10,
    },
    migrations: {
      directory: './database/migrations'
    },
    seeds: {
      directory: './database/seeds'
    }
  },

  production: {
    client: process.env.DB_CLIENT,
    connection: {
      host: process.env.DB_HOST,
      port: process.env.DB_PORT,
      user: process.env.DB_USER,
      password: process.env.DB_PASS,
      database: process.env.DB_NAME,
    },
    pool: {
      min: 2,
      max: 10,
    },
    migrations: {
      directory: './database/migrations'
    },
    seeds: {
      directory: './database/seeds'
    }
  },
};

structur-folder-next-fullstact.md

-> project_name
   |-> component    // Berisi React Component
   |-> database     // Berisi file yang berhubungan langsung dengan database
        |-> migrations  // Database Migrations
        |-> seeds       // Database Seeder
        |-> db.js       // File Konfigurasi Database
   |-> layouts      // Berisi Layouts Page
   |-> middleware   // Jembatan penghubung
   |-> pages        // Halaman yang ditampilkan ke user. Routing berdasarkan struktur folder
   |-> public       // File yang berada disini akan ditampilkan secara public
   |-> styles       // Berisi style halaman