First, type \l and then Enter to list the existing databases on your machine. Now we can test out some commands to get familiar with Postgres. Open the program and login by pressing Enter to use the defaults and then entering your password. The default username is postgres.Īfter the installation, you can log in to your local database instance and play with it on the command line! Search your computer for a program called psql, which is a Terminal/CMD prompt application that lets you interact with your postgres database. You will be asked for a password for the root user: no matter what you choose, ⚠ make sure to write down the password you selected⚠.
When you go through the download, stick with default settings. You can find the download for your OS here.
Prisma app crashing install#
It allows us to set up databases with tables and connect them with easily understandable relations.įirst, we'll install Postgres so that you can set up databases on your computer. PostgreSQL (sometimes called Postgres) is one extremely popular relational database following SQL standards. You can read more about their differences online by searching for comparisons! We'll use SQL in this tutorial, so I won't go into NoSQL too much here. This structure might feel more familiar to frontend developers, but both types of databases have advantages and disadvantages.
NoSQL is a document-based type of database, where generally documents are similar to JSON objects. id is the primary key in each table, and ownerId and carId are "foreign keys" because they refer to a different table's primary key. The ownerId column of the car table refers to the id column of the owner table. In this example, the carId column in the owner table refers to the id column of the car table.