Skip to content

jangbl/knexjs-tutorial

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Knexjs Tutorial with Postgres and Express

This tutorial demonstrates how to connect to a Postgres database with knex.js.

It also demonstrates how to create database migrations with the knex.js migration tool.

Please help this repo with a ⭐️ if you find it useful! 😁

This repository is contains the code for the Node knex.js tutorial on Youtube

Knex.js tutorial in Node

Please also check out my website at jangoebel.com

For updates, please follow @_jgoebel on Twitter.

How to run this application

This application needs a local Postgres instance.

Installing Postgres

On macOS you can install Postgres with Homebrew.

brew install postgresql

and start it with

brew services start postgres

You can stop Postgres with

brew services stop postgres

For other operating systems, please check the Postgres website.

Database setup

Make sure to update the configuration app with your database credentials in the ../db/knexfile.js file. There you need to specify the user, password (per default no password required) and the database you want to connect to.

The default database we try to connect to is called knexjs_tutorial. Please make sure it exists in your local Postgres instance. You can either use a UI like PgAdmin to create the database or you can do so with psql

psql -h localhost -U <your-username> postgres

When installing locally, Postgres creates a database user with your operation system's username. You can run

whoami

on any Unix-like operating system to find out your user

Then you can create a new database with:

create database knexjs_tutorial;

Execute database migration

Once you have installed Postgres and updated the credentials in the ./db/knexfile.js, you can run the initial migration to create the database schema with.

npm run migrate

Starting the application

npm run dev

About

A knex.js tutorial with Postgres

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published