Why Supabase is the open-source Firebase alternative - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Supabase's Open-Source Advantage

Which of the following best explains why Supabase is considered an open-source alternative to Firebase?

A Supabase offers open-source tools and services that users can self-host or use managed, unlike Firebase's closed-source platform.

B Supabase provides a fully managed backend with proprietary closed-source services.

C Supabase only supports frontend development without backend services.

D Supabase requires users to build their own database from scratch.

💡 Hint

Think about the difference between open-source and closed-source platforms.

Supabase is open-source, meaning its code is publicly available and can be self-hosted, unlike Firebase which is proprietary.

❓ Architecture

intermediate

Supabase Core Components

Which set of components correctly represents the core architecture of Supabase as an open-source Firebase alternative?

A MongoDB database, Lambda functions, Authentication, CDN

B PostgreSQL database, Realtime server, Authentication, Storage

C MySQL database, REST API only, Authentication, File system storage

D Oracle database, SOAP services, Authentication, FTP storage

💡 Hint

Supabase uses a popular open-source relational database and real-time features.

Supabase uses PostgreSQL for its database, includes a realtime server for live updates, authentication services, and storage for files.

❓ service_behavior

advanced

Realtime Data Updates in Supabase

What happens when a client subscribes to a Supabase Realtime channel and a row in the PostgreSQL database changes?

A The client connection is reset and must reconnect to see changes.

B The client must poll the database every few seconds to get updates.

C The client receives an immediate event with the updated row data via WebSocket.

D The client receives an email notification about the change.

💡 Hint

Realtime means updates are pushed instantly without polling.

Supabase uses WebSockets to push realtime updates to subscribed clients immediately when data changes.

❓ security

advanced

Supabase Authentication Security Model

Which statement correctly describes how Supabase handles user authentication securely?

A Supabase uses JWT tokens for session management and hashes passwords securely.

B Supabase stores user passwords in plain text for quick access.

C Supabase requires users to authenticate only once without token expiration.

D Supabase does not provide any authentication features.

💡 Hint

Think about common secure authentication practices.

Supabase uses JSON Web Tokens (JWT) for sessions and securely hashes passwords to protect user data.

✅ Best Practice

expert

Choosing Between Self-Hosting and Managed Supabase

Which scenario best justifies choosing self-hosting Supabase over using the managed service?

A When you want to use a proprietary closed-source backend.

B When you want to avoid managing any servers or updates.

C When you need a simple frontend-only solution without backend.

D When you want full control over data and infrastructure for compliance reasons.

💡 Hint

Consider reasons why organizations might prefer managing their own infrastructure.

Self-hosting Supabase allows full control over data and infrastructure, which is important for compliance and customization.

Practice

1. What is one main reason Supabase is considered an alternative to Firebase?

easy

A. It is open-source and uses PostgreSQL as its database.

B. It only supports NoSQL databases.

C. It requires proprietary software licenses.

D. It does not provide real-time features.

Solution

1. Step 1: Understand Supabase's core features

   Supabase is known for being open-source and using PostgreSQL, a popular SQL database.

2. Step 2: Compare with Firebase

   Firebase is proprietary and uses NoSQL, while Supabase offers an open-source alternative with SQL.

3. Final Answer:

   It is open-source and uses PostgreSQL as its database. -> Option A

4. Quick Check:

   Open-source + PostgreSQL = C [OK]

Hint: Remember Supabase is open-source with SQL, unlike Firebase [OK]

Common Mistakes:

• Thinking Supabase only supports NoSQL
• Assuming Supabase is proprietary
• Believing Supabase lacks real-time features

2. Which of the following is the correct way to initialize a Supabase client in JavaScript?

easy

A. const supabase = createSupabase('url', 'key');

B. const supabase = createClient('url', 'key');

C. const supabase = supabase.create('url', 'key');

D. const supabase = supabaseClient('url', 'key');

Solution

1. Step 1: Recall Supabase client initialization syntax

   The official method is using createClient with URL and key as arguments.

2. Step 2: Check each option

   Only const supabase = createClient('url', 'key'); uses the correct function name and syntax.

3. Final Answer:

   const supabase = createClient('url', 'key'); -> Option B

4. Quick Check:

   createClient() is correct method [OK]

Hint: Look for createClient function with two string arguments [OK]

Common Mistakes:

• Using incorrect function names like supabaseClient or createSupabase
• Calling create as a method on supabase
• Mixing up argument order or missing quotes

3. Given this Supabase query in JavaScript:

const { data, error } = await supabase
  .from('users')
  .select('*')
  .eq('active', true);

What does data contain after execution?

medium

A. All users regardless of 'active' status.

B. An error object because the query is invalid.

C. All users where the 'active' field is true.

D. Only users where 'active' is false.

Solution

1. Step 1: Analyze the query filters

   The query selects all columns from 'users' where 'active' equals true.

2. Step 2: Understand the result

   The data variable holds the filtered list of users with active status true.

3. Final Answer:

   All users where the 'active' field is true. -> Option C

4. Quick Check:

   Filter .eq('active', true) returns active users [OK]

Hint: .eq('active', true) filters active users only [OK]

Common Mistakes:

• Assuming it returns all users without filtering
• Thinking it returns users with active false
• Believing the query causes an error

4. You wrote this Supabase query but get an error:

const { data, error } = await supabase
  .from('profiles')
  .select('id, name, email')
  .eq('verified', 'true');

What is the likely cause of the error?

medium

A. The 'verified' field is boolean but compared to string 'true'.

B. The table name 'profiles' is misspelled.

C. The select statement is missing parentheses.

D. Supabase does not support .eq() filters.

Solution

1. Step 1: Check data type mismatch in filter

   The query compares 'verified' boolean field to string 'true', causing type mismatch.

2. Step 2: Validate other parts

   Table name and select syntax are correct; .eq() is supported.

3. Final Answer:

   The 'verified' field is boolean but compared to string 'true'. -> Option A

4. Quick Check:

   Boolean compared to string causes error [OK]

Hint: Match filter value type to column type (boolean vs string) [OK]

Common Mistakes:

• Assuming .eq() is unsupported
• Thinking select needs parentheses
• Ignoring data type mismatch in filters

5. You want to avoid vendor lock-in by using Supabase instead of Firebase. Which feature of Supabase helps most with this?

hard

A. It stores data in a custom binary format.

B. It only works with proprietary cloud services.

C. It requires you to use Firebase SDKs.

D. It is open-source and uses a standard PostgreSQL database.

Solution

1. Step 1: Understand vendor lock-in

   Vendor lock-in happens when you depend on proprietary tech that is hard to move from.

2. Step 2: Identify Supabase's advantage

   Supabase is open-source and uses PostgreSQL, a widely supported standard database, easing migration.

3. Final Answer:

   It is open-source and uses a standard PostgreSQL database. -> Option D

4. Quick Check:

   Open-source + PostgreSQL = less lock-in [OK]

Hint: Open-source + standard DB = easy to switch later [OK]

Common Mistakes:

• Thinking Supabase requires Firebase SDKs
• Believing it uses proprietary cloud only
• Assuming data is stored in custom formats