Create a PostgreSQL Database in One Minute and Connect From Your Laptop

[julia-kafarska]

Full tutorial with screenshots: https://blog.light-cloud.com/tutorials/create-a-postgres-database

Part 1 of 8 of the series Databases on Light Cloud.

Create a PostgreSQL database on Light Cloud in about ten seconds, connect from your laptop with psql, load sample data, and connect from Node.js and Python.

Level: Beginner · Time: about 10 minutes · Plan: Lite · Stack: PostgreSQL, psql, Node.js, Python

Steps

• Step 1: Install psql
• Step 2: Create the database
• Step 3: Copy the connection string
• Step 4: Connect with psql
• Step 5: Load the sample data
• Step 6: See the data in the console
• Step 7: Connect from Node.js and Python

Source code: https://github.com/light-cloud-com/tutorial-database-basics

---

Questions, problems with a step, or a screen that no longer matches the console? Reply here. Every tutorial is re-run on the live platform before it is published, and this thread is where fixes get discussed.