Database Applications with JavaScript

Summary

This course takes the lessons of LS180 and introduces the concept of working with databases from your applications. We'll build a simple command-line application, then move on to a more advanced database-backed Todo application that uses a high-level relational abstraction library. We'll also talk about how to manage security, optimize SQL queries, and how to deploy your applications.

Phase

Programming and Back-end Development

Prerequisites

Detailed Syllabus

Introduction

  • The node-postgres Package
  • async/await
  • Executing SQL Statements from JavaScript

Interacting with a Database in Code

  • Database Design
  • Listing Expenses
  • Displaying Help
  • Adding Expenses
  • Error Handling
  • Handling Parameters Safely
  • Code Structure
  • Searching Expenses
  • Deleting Expenses
  • Clearing Expenses
  • Counting and Totaling Expenses
  • Creating the Schema Automatically

Database-backed Web Applications

  • Session Persistence
  • Creating the Session Persistence Module
  • Display the List of Todo Lists
  • Loading and Sorting Todo Lists
  • Working With Todos
  • Working With Todo Lists
  • Working With Databases
  • Accessing the Database
  • Executing and Logging Database Queries
  • Loading Data From the Database
  • Refactoring the try/catch Blocks
  • Updating the Database
  • Drop-In Replacement

Multiple Users and Other Topics

  • Signing In and Out
  • Restricting Actions to Signed-in Users
  • Storing User Accounts in an External File
  • Personal Todo Lists
  • A Note about Security
  • Optimization Assignment
  • Configuring an Application for Deployment
  • Creating a Heroku Application
  • Deploying PG Applications to Heroku