the coolblog

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 BibleDiem!

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 BibleDiem

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

• .env.local
• .env.production