Supabase vs Firebase comparison - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to initialize a Supabase client with the correct URL.

Supabase

const supabase = createClient('[1]', 'public-anon-key');

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

Ahttps://myproject.firebaseapp.com

Bhttps://firebase.google.com

Chttps://xyzcompany.supabase.co

Dhttps://api.supabase.io

Attempts:

3 left

💡 Hint

Common Mistakes

Using Firebase URLs instead of Supabase URLs.

Confusing API URLs with project URLs.

The Supabase client requires your project URL, which looks like https://xyzcompany.supabase.co.

2fill in blank

medium

Complete the code to sign in a user with Supabase using email and password.

Supabase

const { data, error } = await supabase.auth.[1]({ email, password });

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

AsignInWithPassword

Bregister

CloginUser

Dauthenticate

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect method names like 'register' or 'loginUser'.

Confusing Firebase method names with Supabase.

Supabase uses signInWithPassword to sign in users with email and password.

3fill in blank

hard

Fix the error in the Supabase query to select all rows from 'profiles' table.

Supabase

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

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

Aget

Bselect

Cfetch

Dquery

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'get' or 'fetch' which are not Supabase methods.

Confusing with Firebase query syntax.

The correct method to fetch rows in Supabase is select.

4fill in blank

hard

Fill both blanks to write a Firebase Realtime Database reference for the current user.

Supabase

const dbRef = ref([1], 'users/' + [2].currentUser.uid);

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

Adatabase()

Bauth()

Cstorage()

Dfirestore()

Attempts:

3 left

💡 Hint

Common Mistakes

Using Firestore or storage instead of database.

Using auth() in the first blank instead of database().

Firebase Realtime Database uses database() to get the database instance and auth() to get the current user ID.

5fill in blank

hard

Fill all three blanks to write a Supabase insert query with error handling.

Supabase

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

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

Aprofiles

Binsert

Cjohn_doe

Dselect

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'select' instead of 'insert'.

Wrong table name or missing quotes around the name.

To insert data into the 'profiles' table, use from('profiles') and insert method with the data object.

Practice

1. Which database type does Supabase primarily use?

easy

A. SQL (relational database)

B. NoSQL (document database)

C. Graph database

D. Key-value store

Solution

1. Step 1: Understand Supabase database type

   Supabase is built on PostgreSQL, which is a relational SQL database.

2. Step 2: Compare with other database types

   Unlike NoSQL or graph databases, Supabase uses structured tables and SQL queries.

3. Final Answer:

   SQL (relational database) -> Option A

4. Quick Check:

   Supabase = SQL database [OK]

Hint: Supabase uses SQL, Firebase uses NoSQL [OK]

Common Mistakes:

• Confusing Supabase with NoSQL databases
• Thinking Supabase uses Firebase's database type
• Assuming Supabase is a key-value store

2. Which of the following is a correct statement about Firebase?

easy

A. Firebase is managed by Google and uses NoSQL

B. Firebase is open-source and uses SQL

C. Firebase requires manual server setup

D. Firebase only supports relational databases

Solution

1. Step 1: Identify Firebase management and database type

   Firebase is a Google-managed platform that uses NoSQL databases like Firestore.

2. Step 2: Eliminate incorrect options

   Firebase is not open-source, does not use SQL, and does not require manual server setup.

3. Final Answer:

   Firebase is managed by Google and uses NoSQL -> Option A

4. Quick Check:

   Firebase = Google-managed NoSQL [OK]

Hint: Firebase = Google-managed + NoSQL [OK]

Common Mistakes:

• Thinking Firebase is open-source
• Assuming Firebase uses SQL
• Believing Firebase needs manual server setup

3. Given a project requiring complex SQL queries and relational data, which platform is better suited?

medium

A. Firebase, because it supports SQL queries natively

B. Firebase, because it is open-source

C. Supabase, because it uses PostgreSQL with SQL support

D. Supabase, because it uses NoSQL for flexibility

Solution

1. Step 1: Analyze project needs for complex SQL and relational data

   Complex SQL queries and relational data require a relational database with SQL support.

2. Step 2: Match platform capabilities

   Supabase uses PostgreSQL, a relational SQL database, making it suitable. Firebase uses NoSQL and does not support SQL natively.

3. Final Answer:

   Supabase, because it uses PostgreSQL with SQL support -> Option C

4. Quick Check:

   Relational + SQL = Supabase [OK]

Hint: Relational + SQL = Supabase choice [OK]

Common Mistakes:

• Choosing Firebase for SQL support
• Confusing open-source status
• Assuming Supabase uses NoSQL

4. You try to write a SQL query in Firebase's Firestore database and get an error. What is the likely cause?

medium

A. You need to use Firebase CLI to run SQL queries

B. Your SQL syntax is incorrect

C. Firestore requires a special SQL mode enabled

D. Firestore does not support SQL queries; it uses NoSQL syntax

Solution

1. Step 1: Understand Firestore query language

   Firestore is a NoSQL database and does not support SQL queries; it uses its own query syntax.

2. Step 2: Identify why SQL query fails

   Trying to run SQL in Firestore causes errors because SQL is not supported at all, not due to syntax or CLI issues.

3. Final Answer:

   Firestore does not support SQL queries; it uses NoSQL syntax -> Option D

4. Quick Check:

   Firestore = NoSQL, no SQL queries [OK]

Hint: Firestore uses NoSQL, not SQL queries [OK]

Common Mistakes:

• Assuming SQL syntax error instead of unsupported query
• Thinking Firestore has SQL mode
• Believing Firebase CLI runs SQL queries

5. You want to build a real-time chat app with easy setup and tight integration with Google services. Which platform fits best and why?

hard

A. Supabase, because it is open-source and uses SQL

B. Firebase, because it offers real-time database and Google ecosystem integration

C. Supabase, because it supports NoSQL and Google Cloud Functions

D. Firebase, because it requires manual server management

Solution

1. Step 1: Identify requirements for real-time chat and Google integration

   Real-time updates and easy Google service integration are key for this app.

2. Step 2: Match platform features

   Firebase provides a real-time database and is tightly integrated with Google Cloud services, making setup easier.

3. Step 3: Eliminate incorrect options

   Supabase is open-source and SQL-based but less integrated with Google. Firebase does not require manual server management.

4. Final Answer:

   Firebase, because it offers real-time database and Google ecosystem integration -> Option B

5. Quick Check:

   Real-time + Google integration = Firebase [OK]

Hint: Real-time + Google = Firebase best choice [OK]

Common Mistakes:

• Choosing Supabase for Google integration
• Thinking Firebase needs manual servers
• Confusing database types for chat apps