Back to Blog

Introducing Supabase to Shipprofit

Supabase is an open-source Firebase alternative. It's a great tool for building a backend for your app. It's now integrated with Shipprofit!

Posted by

Supabase and Shipprofit logo combined

Introduction

Supabase is an open-source Firebase alternative. It's a great tool for building a backend for your app. It's now integrated with Shipprofit!

1. Create a supabase account

First, go to Supabase and create an account. It's free for up to 10,000 rows per table.
Then create a new project and a new table. You can use the following SQL schema:

CREATE TABLE public.users (
  id bigint NOT NULL DEFAULT nextval('users_id_seq'::regclass),
  email text NOT NULL,
  password text NOT NULL,
  created_at timestamp with time zone NOT NULL DEFAULT now(),
  updated_at timestamp with time zone NOT NULL DEFAULT now(),
  CONSTRAINT users_pkey PRIMARY KEY (id)
);

2. Add your credentials to Shipprofit

Copy the API URL and API Key from your Supabase project settings and add them to your Shipprofit project settings. Add these files to your project:

  • .env.local
  • .env.production
Introducing Supabase to Shipprofit