Introduction to the newline guide to building and deploying a REST API using Deno.

Welcome to Build and Deploy a REST API with Deno!

In this lesson, we will install Deno and create our setup for the rest of the course.

How to Install Deno Locally and in Docker Containers

Introduction

Deno vs Node: A Deno Fresh Start to JavaScript Runtimes

We will look at the command line interface for running Deno

How to Use the Deno REPL Command Line Interface

In this lesson, we will look at general usage of Deno by running a file and also introduce the config file

Executing TypeScript Files With Deno With the Config File

Learn how to use the Deno standard library and other external modules with URL imports

Deno vs Golang's Standard Library

How to Start a Deno Server and Set Permissions

You will learn how to make a simple token authentication in Deno

How to Build a Token Authentication Server With Deno

Getting Started with Deno

Using Databases with Deno

How to Use PostgreSQL in Docker with Deno

How to Integrate MySQL or MariaDB With Deno

How to Add SQLite to Deno with deno-sqlite

Connect to a database

Introduction to database migrations - what, why and how

What is Database Migration? The Strategy to Migrate Data

Get started with database migrations using Nessie

How to Add Nessie to Deno to Migrate Databases

We will go through creating a migration using the Nessie CLI

How to Create a New Database Migration With Deno Nessie

We will look at how to write a migration script where we create a table

Edit a Deno Nessie Database Migration to Catch Errors

We will run our migration and learn how to roll back the migration

How to Run and Roll Back a Database Migration With Deno Nessie

We will create a seed file using the Nessie CLI

How to Create a Database Seed File With Deno Nessie

We will run our seed file and populate our database

How to Import JSON Data and Seed a Database With Deno Nessie

Database migrations

Introduction to the concept of REST APIs and why we use them

REST API Introduction

We will go through the thought process of planning an application.

Best Practices for a REST API: Endpoints and Database Schema

We will create the initial project files and set up our environment

How to Prepare Deno to Build a REST API

We will create the router and look at how to test our endpoints

How to Build REST API Endpoints in Deno

It's time to add Nessie! We will now initialize Nessie in our project and also spin up our development database

Integrate a PostgreSQL Database With Nessie Into a Deno API

Time to connect our models to our database!

Building a MySQL or PostgreSQL Database Pool in Deno

In this step, we will create our first data model and create a corresponding table using a migration

Migrating Data to PostgreSQL and Modeling Data in Deno

Creating the methods to access the database

Build API Calls That Generate SQL Queries in Deno

Creating the server endpoints for the Duck namespace

Create a Database Controller in Deno

We will look at how to set up authentication and further authorize the requests

How to Authenticate and Authorize REST API Requests in Deno

We will create two new tables using a migration and create the equivalent models

Create New Tables and Models With Deno Database Migration

We will create our Quack service and controller

Add List, Create, Read, Update, and Delete Requests in Deno

The last stretch! We will create our final namespace, Crumb, and connect it to our other models and our router

How to Build Many-to-Many Namespace Connections in Deno

Now that our application is completed, we will consider some improvements and discuss alternative approaches.

API Afterthoughts

REST API

We will introduce deployments and what we will learn in this module

Deployment Introduction

We will create a Docker image for our application

How to Create a Docker Image to Containerize an Application

You will learn how to create a basic CI file for GitHub and GitLab, and run tests on them

How to Create Continuous Integration Files for GitHub and GitLab

We will deploy our application to a server using CI, SSH and git.

How to Deploy a Deno API Server With the Digital Ocean API

We will deploy our application to Digital Ocean Apps. This is by far the easiest (but most costly) approach.

How to Deploy a Deno Docker Image to Digital Ocean

Similar to how we did it in lesson 1, we will be deploying using CI and SSH, but instead of git, we will be using Docker.

Deploy with Docker

Deployment

In this course, we will learn how to work with [Deno](https://deno.land) to create a REST API using TypeScript with the web framework [Oak](https://github.com/oakserver/oak) and the migration tool [Nessie](https://github.com/halvardssm/deno-nessie). 
Deno is a JavaScript runtime created by [Ryan Dahl](https://tinyclouds.org), the same creator for Node, as an attempt to simplify the JavaScript landscape by strictly following the WebAPI specs. 
If you are interested in learning more about the motivation behind Deno, you can watch this video where Ryan Dahl explains "[10 Things I Regret About Node.js](https://www.youtube.com/watch?v=M3BM9TB-8yA)"

We will explore how to create an application using the powers of TypeScript, and learn how to traverse the Deno ecosystem which is much like the native web ecosystem. 
There are 5 modules that will take you from installing Deno and running your first lines of code, to working with web frameworks and databases, and in the end, deploying your application to a web server using a deployment pipeline.

Throughout this course, you will experience all the different aspects of Deno which you will need to create your own application in the future. 
And from this course, you will get a good feeling for if Deno is ready to be your next default for new projects.

In this course, we will learn how to create and deploy a REST API with Deno from scratch.

Build and deploy a REST API with Deno

Integrating databases into your application

Importance of database migrations in production applications

Deploying Deno applications to production using CICD

Now that we have our endpoints ready, we need to add a database to use with our
application.

We can start by adding the database connection variables to our 

DB_PORT=5432
DB_PASSWORD=root
DB_USER=postgres
DB_NAME=quacker
DB_HOST=localhost

Start by spinning up a new database called 

 for our local development.
I will be using 

, and if you are using a different database, there
might be some differences in the queries you have to use as each database uses
slightly different syntax.

See Module 2 for how to run a database locally if you do not want to use
Docker. If you don't want to install any external tools, I would recommend
using SQLite.

As the Docker command is fairly long, and it is annoying to write and edit it in
the terminal, we can simply slap it into the 

As I mentioned earlier, we are using both a 

 file
to store our scripts, and now you will see why. We could store all our scripts
in the Deno config file, but it has one slight problem, and that is the fact
that we would need to use an external tool to load the environment variables
from the 

 file. Sure there might be easy solutions out there, but none
that are cross platform compatible. By utilizing a 

include .env

db_start:
	docker run -d --rm -p $(DB_PORT):5432 --name $(APP_NAME) -e POSTGRES_PASSWORD=$(DB_PASSWORD) -e POSTGRES_DB=$(DB_NAME) postgres:14

db_stop:
	docker kill $(APP_NAME)

task:
	deno task $(filter-out $@,$(MAKECMDGOALS))

%:
	@:

As you can see, we are using the variables which are available in the 


file for our script. We have now added a db creation command and a db kill
command which can be used by you or any of your project members for creating the
local dev environment.

An improvement to the current local dev environment would be to use a Docker
compose file instead, but for now our focus will be on creating a REST API in
Deno.

---
title: Integrate a PostgreSQL Database With Nessie Into a Deno API
description: It's time to add Nessie! We will now initialize Nessie in our project and also spin up our development database
code: https://gitlab.com/fullstackio/books/newline-course-apps/halvard-morstad-build-and-deploy-a-rest-api-with-deno-app/-/tree/main/app_with_sqlite_db%20(updated)/module_4.4?ref_type=heads
---

## Databases and Nessie migrations

Now that we have our endpoints ready, we need to add a database to use with our
application.

We can start by adding the database connection variables to our `.env` and
`.env.example` files

```typescript { actualFilename=../../code/module_4.4/.env.example endLine=7 startLine=3 statedFilename=.env url=https&#x3A;//gitlab.com/fullstackio/books/build-a-rest-api-with-deno-and-postgresql/module_05/lesson_04/.../code/module_4.4/.env.example#L3 }
DB_PORT=5432
DB_PASSWORD=root
DB_USER=postgres
DB_NAME=quacker
DB_HOST=localhost
```

### Spin up the database

Start by spinning up a new database called `quacker` for our local development.
I will be using `PostgreSQL`, and if you are using a different database, there
might be some differences in the queries you have to use as each database uses
slightly different syntax.

> See Module 2 for how to run a database locally if you do not want to use
> Docker. If you don't want to install any external tools, I would recommend
> using SQLite.

As the Docker command is fairly long, and it is annoying to write and edit it in
the terminal, we can simply slap it into the `Makefile`.

> As I mentioned earlier, we are using both a `Makefile` and a `deno.jsonc` file
> to store our scripts, and now you will see why. We could store all our scripts
> in the Deno config file, but it has one slight problem, and that is the fact
> that we would need to use an external tool to load the environment variables
> from the `.env` file. Sure there might be easy solutions out there, but none
> that are cross platform compatible. By utilizing a `Makefile` we can simply
> ask `make` to load it for us.

Add the following commands to the `Makefile`:

```typescript { actualFilename=../../code/module_4.4/Makefile endChar=250 endLine=14 startChar=0 startLine=1 statedFilename=Makefile url=https&#x3A;//gitlab.com/fullstackio/books/build-a-rest-api-with-deno-and-postgresql/module_05/lesson_04/.../code/module_4.4/Makefile }
include .env

db_start:
	docker run -d --rm -p $(DB_PORT):5432 --name $(APP_NAME) -e POSTGRES_PASSWORD=$(DB_PASSWORD) -e POSTGRES_DB=$(DB_NAME) postgres:14

db_stop:
	docker kill $(APP_NAME)

task:
	deno task $(filter-out $@,$(MAKECMDGOALS))

%:
	@:
```

As you can see, we are using the variables which are available in the `.env`
file for our script. We have now added a db creation command and a db kill
command which can be used by you or any of your project members for creating the
local dev environment.

An improvement to the current local dev environment would be to use a Docker
compose file instead, but for now our focus will be on creating a REST API in
Deno.

### Adding Nessie

As we did in Module 3, we can now run the following query to set up Nessie in
our project to handle any database migrations we are going to need. In the root
folder, execute:

```shell
deno run -A --unstable https://deno.land/x/nessie@2.0.7/cli.ts init
```

You will now have a newly created folder called `db`, and a `nessie.config.ts`
file. We will get back to them soon, but first let's set up the database
connection object.