Run SQL in the Browser: Queries, Joins and Quick Fixes on a Live Database

[julia-kafarska]

Full tutorial with screenshots: https://blog.light-cloud.com/tutorials/run-sql-queries-in-the-console

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

Run SQL on a Light Cloud PostgreSQL database from the browser: read-only queries, joins and totals, then a quick UPDATE with Allow writes and RETURNING.

Level: Beginner · Time: about 10 minutes · Plan: Lite · Stack: PostgreSQL, SQL

Steps

• Step 1: Run a first query
• Step 2: Join three tables
• Step 3: Try a write
• Step 4: Make the fix with Allow writes

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.