Supabase dashboard overview - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select all rows from the 'users' table in Supabase.

Supabase

const { data, error } = await supabase.from('[1]').select('*');

Drag options to blanks, or click blank then click option'

Ausers

Bprofiles

Corders

Dproducts

Attempts:

3 left

💡 Hint

Common Mistakes

Using a table name that does not exist in the database.

Forgetting to put the table name as a string.

The 'from' method specifies the table to query. Here, 'users' is the correct table name.

2fill in blank

medium

Complete the code to filter users where 'age' is greater than 18.

Supabase

const { data, error } = await supabase.from('users').select('*').[1]('age', 18);

Drag options to blanks, or click blank then click option'

Agte

Beq

Cgt

Dfilter

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'filter' which does not exist in Supabase JS client.

Using 'eq' which means equals, not greater than.

The 'gt' method is used to filter where age is greater than 18.

3fill in blank

hard

Fix the error in the code to insert a new user with name 'Alice' and age 30.

Supabase

const { data, error } = await supabase.from('users').[1]({ name: 'Alice', age: 30 });

Drag options to blanks, or click blank then click option'

Ainsert

Bupdate

Cselect

Ddelete

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'update' instead of 'insert' to add new data.

Using 'select' which only reads data.

To add new data, use the 'insert' method. 'update' changes existing data, 'select' reads data, and 'delete' removes data.

4fill in blank

hard

Fill both blanks to update the 'age' of user with id 5 to 40.

Supabase

const { data, error } = await supabase.from('users').[1]({ age: 40 }).[2]('id', 5);

Drag options to blanks, or click blank then click option'

Aupdate

Binsert

Ceq

Dfilter

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'insert' instead of 'update' to modify data.

Using 'filter' instead of 'eq'.

Use 'update' to change data and 'eq' to specify which rows to update by id equals 5.

5fill in blank

hard

Fill all three blanks to delete users older than 60.

Supabase

const { data, error } = await supabase.from('[1]').[2]().[3]('age', 60);

Drag options to blanks, or click blank then click option'

Ausers

Bfilter

Cgt

Ddelete

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'filter' instead of 'delete' and 'gt'.

Using 'gte' or 'eq' instead of 'gt' for the operator.

We delete from 'users' table using .delete().gt('age', 60).

Practice

1. What is the main purpose of the Supabase dashboard?

easy

A. To create graphic designs for marketing

B. To manage projects, databases, and monitor usage in one place

C. To design mobile app interfaces

D. To write complex SQL queries only

Solution

1. Step 1: Understand the dashboard role

   The Supabase dashboard is described as a control center for managing projects and data.

2. Step 2: Identify main functions

   It helps manage databases, authentication, storage, and monitor usage, all in one place.

3. Final Answer:

   To manage projects, databases, and monitor usage in one place -> Option B

4. Quick Check:

   Dashboard = Manage projects and data [OK]

Hint: Dashboard = control center for projects and data [OK]

Common Mistakes:

• Thinking dashboard is only for SQL queries
• Confusing dashboard with design tools
• Assuming it is for marketing tasks

2. Which section would you NOT expect to find in the Supabase dashboard?

easy

A. Storage file browser

B. Database table editor

C. Video editing studio

D. Authentication management

Solution

1. Step 1: List dashboard features

   The dashboard includes authentication, database, and storage management.

2. Step 2: Identify unrelated feature

   Video editing is unrelated to database or project management in Supabase.

3. Final Answer:

   Video editing studio -> Option C

4. Quick Check:

   Dashboard excludes video editing [OK]

Hint: Dashboard manages data, not video editing [OK]

Common Mistakes:

• Confusing storage with media editing
• Assuming all tools are included
• Mixing dashboard with external apps

3. Given this Supabase dashboard snippet showing usage stats:

{"active_users": 120, "db_size_mb": 500, "storage_used_mb": 300}

What does the db_size_mb value represent?

medium

A. The size of the database in megabytes

B. The amount of storage used for files

C. The number of active users currently logged in

D. The number of tables in the database

Solution

1. Step 1: Analyze the JSON keys

   The key db_size_mb suggests a size measurement in megabytes related to the database.

2. Step 2: Match key to meaning

   It represents the database size, not user count or storage files.

3. Final Answer:

   The size of the database in megabytes -> Option A

4. Quick Check:

   db_size_mb = database size [OK]

Hint: Look for '_size_mb' to find storage size info [OK]

Common Mistakes:

• Confusing db_size_mb with active users
• Mixing storage used with database size
• Assuming it counts tables

4. You see this error in the Supabase dashboard when trying to view database tables:

"Error: Permission denied for relation users"

What is the most likely cause?

medium

A. You do not have permission to access the users table

B. The users table does not exist

C. The dashboard is offline

D. Your internet connection is lost

Solution

1. Step 1: Interpret the error message

   The message says "Permission denied" which means access rights are missing.

2. Step 2: Identify cause

   Permission issues mean the user lacks rights to read the users table, not that it is missing or offline.

3. Final Answer:

   You do not have permission to access the users table -> Option A

4. Quick Check:

   Permission denied = access rights missing [OK]

Hint: Permission denied means access rights missing [OK]

Common Mistakes:

• Assuming table is missing
• Blaming internet connection
• Thinking dashboard is offline

5. You want to monitor your Supabase project's database size growth over time using the dashboard. Which approach is best?

hard

A. Ignore dashboard metrics and guess usage

B. Only check the active users count daily

C. Delete old tables to reduce size without monitoring

D. Regularly check the database size metric and export data for trend analysis

Solution

1. Step 1: Understand monitoring goal

   You want to track database size growth, so you need size data over time.

2. Step 2: Choose best method

   Regularly checking the size metric and exporting data allows you to analyze trends accurately.

3. Step 3: Eliminate wrong options

   Checking only users or deleting tables without monitoring won't track growth properly.

4. Final Answer:

   Regularly check the database size metric and export data for trend analysis -> Option D

5. Quick Check:

   Monitor size metric regularly for trends [OK]

Hint: Track size metric regularly for growth trends [OK]

Common Mistakes:

• Ignoring size data
• Confusing user count with size
• Deleting data without analysis