Back to Blog

Introducing OpenUser

OpenUser is a place where people can express themselves fully by sharing what products they use, what they do and how they do it.

Posted by

banner

Introduction

x

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 OpenUser

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

  • .env.local
  • .env.production