Building a Trial-Based Registration Service with Supabase

In the competitive landscape of SaaS, offering a trial period can significantly boost user acquisition by allowing potential customers to experience your product's value firsthand. However, integrating this trial mechanism seamlessly into the user registration flow requires careful design. For our ims-platform/ims-api project, we've developed a robust registration service that instantly grants new users a trial period, streamlining their onboarding experience.

The Core Challenge: Seamless Onboarding

The primary goal was to create a user registration process that immediately activates a trial account without additional steps. This means when a user signs up, their account is not only created but also tagged with trial status and a defined trial expiry. This approach eliminates friction and encourages immediate engagement with the application's features.

Traditionally, this might involve complex database transactions and separate service calls. Our solution leverages Supabase, a powerful open-source Firebase alternative, to manage both authentication and user profile data, including trial status, in a cohesive manner.

Implementing the Service with Supabase

Our new registration service orchestrates two main actions: user creation via Supabase Auth and then the initialization of a user profile in our database, marking them as a trial user. This ensures that every new registration automatically starts a trial period, typically 7 days, stored directly within our user_profiles table.

Here’s a simplified illustration of how this can be implemented using TypeScript and the Supabase client library:

import { createClient } from '@supabase/supabase-js';

const supabase = createClient(
  'https://your-project-ref.supabase.co',
  'YOUR_SUPABASE_ANON_KEY'
);

async function registerTrialUser(email: string, password: string) {
  // 1. Register user with Supabase Auth
  const { data: authData, error: authError } = await supabase.auth.signUp({
    email,
    password,
  });

  if (authError) throw authError;
  if (!authData.user) throw new Error('User data not returned after signup.');

  const userId = authData.user.id;
  const trialEndDate = new Date();
  trialEndDate.setDate(trialEndDate.getDate() + 7); // 7-day trial

  // 2. Create a profile entry and set trial status in a custom table
  const { data: profileData, error: profileError } = await supabase
    .from('user_profiles')
    .insert([
      {
        user_id: userId,
        is_trial_active: true,
        trial_ends_at: trialEndDate.toISOString(),
        created_at: new Date().toISOString(),
      },
    ]);

  if (profileError) throw profileError;

  console.log(`User ${email} registered with trial ending on ${trialEndDate.toDateString()}`);
  return { user: authData.user, profile: profileData };
}

This TypeScript function registerTrialUser first uses supabase.auth.signUp to create a new user entry in Supabase's authentication system. Upon successful creation, it proceeds to insert a corresponding record into our custom user_profiles table. This record includes the user_id, a flag is_trial_active set to true, and trial_ends_at calculated for a 7-day period.

Managing Trial Lifecycles

Beyond initial registration, managing the trial lifecycle involves periodically checking trial_ends_at for active trial users. Supabase's PostgREST API and Row Level Security (RLS) can be configured to restrict access to certain features once a trial expires. Automated jobs can then transition users from trial to a trial_ended or free_tier status, prompting them to subscribe for continued access.

Streamlining user entry into a trial not only improves conversion but also provides immediate value to your users. By leveraging tools like Supabase, developers can build robust, scalable, and user-friendly registration flows with trial management baked in from the start.

Generated with Gitvlg.com