knexjs-tutorial

KO | EN

gitlite — search

#hacktoberfest #llm #android #docker #java #windows #awesome #vue #pytorch #security #ios #mcp #openai #open-source

knexjs-tutorial

(★ 34)

A knex.js tutorial with Postgres

knexjs-tutorial Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Knexjs Tutorial with Postgres and Express

This tutorial demonstrates how to connect to a [Postgres](https://www.postgresql.org) database with [knex.js](http://knexjs.org).

It also demonstrates how to create database migrations with the [knex.js](http://knexjs.org) migration tool.

<h3 align="center">Please help this repo with a ⭐️ if you find it useful! 😁</h3>

This repository is contains the code for the [Node knex.js tutorial on Youtube](https://www.youtube.com/watch?v=wfrn21E2NaU)

[![Knex.js tutorial in Node](https://raw.githubusercontent.com/jangbl/knexjs-tutorial/master/images/node-knex-js-tutorial.png)](https://www.youtube.com/watch?v=wfrn21E2NaU)

Please also check out my website at [jangoebel.com](https://jangoebel.com)

For updates, please follow [@_jgoebel](https://twitter.com/_jgoebel) on Twitter.

# How to run this application

This application needs a local [Postgres](https://www.postgresql.org) instance.

## Installing Postgres

On macOS you can install [Postgres](https://www.postgresql.org) with [Homebrew](https://brew.sh/).

```
brew install postgresql
```

and start it with

```
brew services start postgres
```

You can stop [Postgres](https://www.postgresql.org) with
```
brew services stop postgres
```

For other operating systems, please check the [Postgres website](https://www.postgresql.org/download/).

### 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](https://www.postgresql.org) instance. You can either use a UI like [PgAdmin](https://www.pgadmin.org) to create the database or you can do so with `psql`

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

When installing locally, [Postgres](https://www.postgresql.org) 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](https://www.postgresql.org) 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
```

knexjs-tutorial

knexjs-tutorial Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

knexjs-tutorial

knexjs-tutorial Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README