knexfile.js

module.exports = {
    development: {
        client: 'pg',
        connection: process.env.DATABASE_URL,
        migrations: {
            directory: __dirname + '/src/db/migrations'
        },
        seeds: {
            directory: __dirname + '/src/db/seeds/development'
        }
    },

    test: {
        client: 'sqlite3',
        connection: {
            filename: 'testdb.sqlite'
        },
        migrations: {
            directory: __dirname + '/src/db/migrations'
        },
        seeds: {
            directory: __dirname + '/src/db/seeds/test'
        },
        useNullAsDefault: true
    },

    production: {
        client: 'pg',
        connection: process.env.DATABASE_URL,
        migrations: {
            directory: __dirname + '/src/db/migrations'
        },
        seeds: {
            directory: __dirname + '/src/db/seeds/production'
        }
    }
};