CRUD operations with supabase-js - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does CRUD stand for in database operations?

CRUD stands for Create, Read, Update, and Delete. These are the four basic operations to manage data in a database.

beginner

How do you create a new record using supabase-js?

Use the insert() method on a table reference. For example: supabase.from('table').insert([{ column: 'value' }]) adds a new row.

beginner

How do you read or fetch data from a table using supabase-js?

Use the select() method on a table reference. For example: supabase.from('table').select('*') fetches all columns from all rows.

intermediate

How do you update existing data with supabase-js?

Use the update() method with eq() or other filters to specify which rows to update. Example: supabase.from('table').update({ column: 'new' }).eq('id', 1).

intermediate

How do you delete records using supabase-js?

Use the delete() method with filters to specify which rows to remove. Example: supabase.from('table').delete().eq('id', 1) deletes the row with id 1.

Which method is used to add new data in supabase-js?

A insert()

B select()

C update()

D delete()

The insert() method adds new records to a table.

How do you fetch all columns from a table in supabase-js?

A delete('*')

B insert('*')

C select('*')

D update('*')

select('*') fetches all columns from the table.

Which method updates existing rows in supabase-js?

A update()

B insert()

C select()

D delete()

update() modifies existing records.

What is needed to specify which rows to update or delete?

A insert()

B select()

C No filter needed

D Filters like eq()

Filters like eq() specify which rows to affect.

Which method removes data from a table?

A select()

B delete()

C update()

D insert()

delete() removes rows from the table.

Explain how to perform each CRUD operation using supabase-js with simple examples.

Think about which method matches each operation and how to specify rows.

Describe why filters like eq() are important when updating or deleting data in supabase-js.

Consider what happens if you update or delete without telling which rows.