Darragh ORiordan

PostgreSQL and typeorm - Intro to persistence

Photo by Lorenzo Herrera

Introduction

This database course is designed to help you get into the world of persistence with typeorm and postgres when working on projects with nodejs or just typescript.

By the end of this course you'll also have a strong vocabulary for discussing persistence in any scenario so you can find answers to any database questions online or from your colleagues.

This first module is an introduction where we cover many terms and concepts that we'll use later.

Database course index

There is a github repo to go with this course. See part 2 for instructions.

You can see examples of typeorm in a real app on Use Miller on GitHub

  1. Intro to persistence
  2. Creating a local instance
  3. Storing data in postgres
  4. Getting into relations
  5. Advanced querying
  6. Transactions
  7. Tips, tricks and common issues
  8. Database administration glossary
  9. Intro to caching

Software programs and data

All software programs read data, process it, output the results. At the core, this is all software does.

Sometimes the source or destination for data is not persistent, it is ephemeral. An example of a destination for data that is not persistence is the UI screen of an application.

Very often the source or destination of our data is some persistence technology. Examples of persistence technology is a database table, a usb drive or an AWS S3 bucket.